Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.

learn more… | top users | synonyms

1
vote
0answers
140 views

Excel -> SP List with correct column types?

Are there solutions available for importing an Excel to SharePoint with SharePoint column types? Or has someone tried this with the help of OpenXml (with a custom import web part with default values, ...
1
vote
0answers
552 views

Exporting Custom List view in Sharepoint 2010 to Excel

I am creating a custom list view programatically which hides some of the columns in the actual list. But while exporting to excel all the columns are visible. Any tips/help is appreciated.
1
vote
0answers
290 views

Want to link to specific sheet in Excel workbook which is stored in SP10 doc library, but usual method not working

I have an excel workbook stored in Sharepoint 2010 document library. It contains several named sheets. I wwant to link to the workbook from a Wiki or List but I want specific sheets to be visible ...
1
vote
0answers
272 views

Integer field/column lost at export to Excel [closed]

I have created a list in SharePoint 2010 via a published InfoPath 2010 form. The fields/columns of the list are of different types like Single line of text, Integer, Date and Time, Yes/No, Number etc. ...
0
votes
2answers
67 views

Upgraded SP Servers and now webpart can't access C drive

We had one WFE server and upgraded to 2 WFE servers with a load balancer. We are using the SharePoint Server Standard edition. Because we are using the Standard edition and do not have access to BI ...
0
votes
2answers
299 views

Hard limit to have number of Excel webparts on SharePoint 2010 page?

Is there any hard limit to have number of Excel webparts on the SharePoint 2010 page?
0
votes
2answers
1k views

SharePoint list not accepting copied excel data

Hello I am having an issue with a SharePoint list not accepting copied data from an excel sheet while in datasheet view. The sheet has 130 rows of data I have done this before and made sure the ...
0
votes
3answers
164 views

How to export list items in same order in a list to excel 2010 (console application)?

I require to export list items from a SharePoint list to Excel. The order of items in the Excel sheet should be the same as in the list. Can somebody suggest console application code for this?
0
votes
1answer
42 views

Force a document to open in the application and not the web app?

I have a large Excel file (under 1 meg, but almost 25 tabs) that none of my users can open in Excel Online. If you click on it in the document library, it spins for a while before giving this error: ...
0
votes
1answer
32 views

Can I apply check out rules to a single document in a document library and not the whole library?

Is it possible to apply check in/out rules to a single document in a document library without applying the same rules across the document library via the Library "Version Settings" section?
0
votes
1answer
69 views

How To Create An Excel Type Grid Application In SharePoint 2010

I have a requirement to create an application in SharePoint 2010 where the user interface presented is like a grid/spreadsheet. But each cell in the grid needs to represent a SharePoint item in a ...
0
votes
1answer
88 views

SharePoint Exports to Excel, can't I get directly in .xlsx file?

I am using SP 2013 foundation. I am able to export list into .iqy file. Which is good. But users wants directly .xlsx or .xls files. Is it possible to do that?
0
votes
1answer
307 views

Linking an Excel document to a List

I have an excel document which is sent daily to me. I have a SharePoint List that is then update daily by me with all the excel documents information (complete overwrite each day). The list is used ...
0
votes
1answer
201 views

Issues in some contents of Excel web access web part in mozila firefox and google chrom

Whenever we create an Excel web page, using Excel web access web part, we got an option "open in excel". That "open in excel" option is not working in google chrome but it is working in Internet ...
0
votes
1answer
1k views

How to modify an Office (Word, Excel) file in sharepoint programmatically

I need to Open and modify a document that resides on a Sharepoint Document Library. These changes on the file are done during an event generated by a Document Library, so I must change it by code. ...
0
votes
2answers
2k views

Excel Web Access Not Disabled?

I uploaded a spreadsheet to one of my sharepoint 2007 sites. When I click on the link I get the error "Exxel Web Access An error has occurred. Please contact your system administrator if the problem ...
0
votes
2answers
2k views

Excel file opening in XLViewer for some users

We have a corporate internal portal with lot of subsite and document library for various department/BU. When a user tries to open a excel file from a document library it opens in Excel client from ...
0
votes
3answers
3k views

Open docs from SP2010 in excel/word crashes

I have: SP2010 rented from a company. 1 site collection I have IE 9.0.8 For about a 6 months I have this consistent problem. When I click on a Word doc or Excel doc, I get a choice to edit, I do ...
0
votes
3answers
6k views

Import Excel to SharePoint list -> Auto-synchonize based on Id

Are there tools available for importing an Excel file to a SharePoint list so that the importing data would be synchronized based on specified field(s)? I would mostly be interested in a ...
0
votes
2answers
2k views

How to Export sharepoint 2010 SPGridView data to excel

How to Export sharepoint 2010 SPGridView data to excel. My data with tree strutured is avilable in spgridview. Note: if any of the column value contains multiple value then i need to convert into ...
0
votes
2answers
2k views

How to read excel file contents from the database?

I have a problem that involves reading contents of an Excel file after the excel file has been added to a document library in SharePoint 2010. Reading the file contents was easy on client machine with ...
0
votes
4answers
766 views

Access denied on edit in excel

Has anyone seen an error occur when a user performs the edit in excel action and the user gets an authentication prompt which they can't get past with their correct credentials and then a similar ...
0
votes
1answer
18 views

Who has precedence?

If there's only one user who has "can edit" permission and he has it open on his Desktop, do his changes over write what a "can view only" user is seeing in Excel Online? When would the viewer see the ...
0
votes
1answer
50 views

Mail Merge with Excel Document stored in SharePoint

We have an Excel Document we would like to use as a source file for a Mail Merge in Word. When we open the Excel file in the mail merge wizard we receive the following error. "Sorry we couldn't ...
0
votes
2answers
52 views

how to export the data from a webpart to excel and pdf in sharepoint 2010

I have a custom Web Part which retrieve the data from SQL Server 2008 manipulates it and shows the data table in UI. Below is the UI of the data on the Web Part. The data contains URLs, Dates, Names ...
0
votes
1answer
22 views

How many webparts are available in SharePoint for displaying an excel sheet/excel report?

We are doing some R&D on displaying excel sheets (simple sheets with no external data connection) and excel reports(which connect to sql db) on a SharePoint page. I would like to know what are ...
0
votes
3answers
211 views

Files downloading instead of opening in Chrome

User is accessing SP through Chrome (rest of us have IE). When they click on a spreadsheet they don't get the usual prompt to select read only/edit mode. The spreadsheet opens and they make their ...
0
votes
1answer
54 views

Extract infopath xml data into excel

I have around 2000 InfoPath forms in SharePoint 2010 document library. I want to extract all forms in excel using macro. Any help?
0
votes
2answers
100 views

List Items Export to Excel on SharePoint 2013

I have a list on SharePoint 2013 and I want to export the list items to excel file. How can I do export process?
0
votes
1answer
35 views

Sharepoint Excel files Capacity Planning

I have requirement to upload 30K records every year in document library and further attach workflow and do some stuff based on business criteria. I need to plan for capacity in SharePoint, so I need ...
0
votes
1answer
24 views

Alternative ways to read excel in Sharepoint

Now I'm facing with a problem of reading excel file on SharePoint server. In the old ways I usually use the OLEDB to read excel through the connection string, but it's just work on 32 bit system, ...
0
votes
1answer
95 views

How do I have a workflow update a field/column in the current list(InfoPath created list)?

I have a column with this formula: =YEAR(Created)&"-"&(ID) , the YEAR(created) part works as intended but the ID part doesnt. It often shows only 2014- but it should show 2014-50, the 50 beign ...
0
votes
1answer
30 views

column formula help

I've asked a question a couple days ago, wich gave me the answer =IF( OR(INT(A)+INT(B)+INT(C) = 3, INT(A)+INT(B)+INT(C) = 0), "Accepted", "Not Accepted" ) But that only works if they have to fill ...
0
votes
3answers
222 views

Why does this multi-field validation forumula work in Excel but not in SharePoint 2013?

Why does my simple formula work in Excel but not-work in SharePoint? Why does this formula... =IF([Request Type]="Review",(IF(ISBLANK([Request Date]),FALSE,TRUE)),TRUE) ...work in Excel but fail ...
0
votes
1answer
81 views

Updating excel information to a list matching a custom ID column

I'm on SharePoint 2010. An excel file is uploaded to a document library.This excel file has a custom ID column(alphanumeric) and many more columns. There is a list which contains many columns along ...
0
votes
2answers
185 views

Error when I fill in metadata in excelsheet Document Information Panel

I am using sharepoint 2010. I have a document library with a contenttype. I have some word, excel and pdf documents inside of it. When I open an existing excel sheet and go to the Document Information ...
0
votes
1answer
410 views

How to get excel file from sharepoint library and write to it programmatically

we would like to read an Excel template stored in a SharePoint 2010 library create a new Excel file from it fill the new Excel file with data programmatically we tried already Excel Services but ...
0
votes
1answer
1k views

SharePoint List View - Export to Excel with Formatting and Grouping

I have a SPList View with 2 levels of grouping. First level is Company and the second level is 'Month - Year' which is a calculated field. Below is the view's screen shot: The issue is when a do ...
0
votes
2answers
3k views

Sharepoint 2013 pasting text into a cell of multiple lines type

I am trying to copy & paste a cell of data from excel to my sharepoint list. The excel cell of data consists of multiple lines of text, so when I copy & paste in the data it pastes it onto ...
0
votes
1answer
6k views

Import Excel Sheet and append items to SharePoint list [duplicate]

I have Excel sheet and existing SharePoint list (Import spredsheet app) on my SharePoint server. We need to append the data from the new excel sheets to the existing lists items of the SharePoint ...
0
votes
3answers
758 views

Can we create Excel file using c#?

I would like to know if it is a good idea to create an excel file using c# in sharepoint? I've tried to find js libraries but despite ExcelBuilder which seems really complicated to use i can't find ...
0
votes
1answer
72 views

Setting to enforce use of Excel Services rather than Excel Web App

Our site and sub-sites are defaulting to Excel Web App rather than Excel Services. We require Excel Services. I think maybe I hit a setting somewhere at the root which has caused this change. Where ...
0
votes
1answer
110 views

Collect data from SharePoint and make from that a report

I want to create a report , the data source will be a SharePoint list . I tried to use the PowerBI (unfortunately , its configuration is not going so well) , then I thought about Excel (a combination ...
0
votes
1answer
216 views

SP13: Overwriting Excel Importing List

This task seems easy, but is turning out to be more complex than I expected. I have a excel spreadsheet that I have imported into a custom list. In order to import the excel spreadsheet by using ...
0
votes
2answers
2k views

Import File from SharePoint and Link this file with SharePoint (File- Excel File)

I am using SharePoint 2013 and Microsoft Office 2007 or above. Scenario: I upload a Excel file to a SharePoint 2013 list. Now, I want to import this Excel file from this SharePoint list back to ...
0
votes
2answers
544 views

How to show version number when using 'Export to Excel' command

my firm is transferring a project to another firm. The new firm wants a list of all of our files. I went into our sharepoint library and selected "Export to Excel" which returned a spreadsheet with ...
0
votes
2answers
829 views

Unable to save excel to SharePoint 2007

I have a user who is having issue saving changes he made to an excel file stored in a document library. He has contribute access to the library. The setting on the library does not require check out ...
0
votes
1answer
46 views

In Excel, OnClick I need to save then add a workbook to a SPT 2010 Standard Edition doc Library? How to do this?

I am not a coder, but I have seen VB scripts that "kind of" does this.. I'm willing to try (nervous smile). I need to add a button in an Excel workbook that will "auto upload" the workbook to a ...
0
votes
2answers
2k views

ECB “Edit in Microsoft Excel” is missing for users

I have bunch of user in a SharePoint group with Special Contribute access (same as contribute permission but No delete). These users are not seeing "Edit in Microsoft Excel" in the ECB menu. If I log ...
0
votes
1answer
428 views

Export all of Sharepoint 2010 data (list, webapp data, etc. )

I need to export all of Sharepoint 2010 data (list, webapp data, etc.) in to a easy to import file. Meaning I have "SiteName" with lists and webapp data, and I need all the information of that site in ...