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

learn more… | top users | synonyms

1
vote
3answers
8k views

Export Survey Results to Excel option not in Action Menu

I have a survey and all the needed results. I need to export the results to excel, though in the process of setting up the survey I changed or removed the Overview.aspx page/view. Now when I add a ...
0
votes
1answer
15 views

How to exctract filtered items from SharePoint List to Excel

I'm using Javascript and AngularJS to get all data from a SharePoint list in JSON and displayed it into a table. User can sort it, filtered it and etc. There is a really nice paggination. Everything ...
0
votes
0answers
10 views

SharePoint 2013 - Excel SUMIF between to Excel files

In our system are since two weeks some Excel files where a connection between the files was made with the "SUMIF" function. the problem is that the user wants to update the data in the 2nd file (which ...
0
votes
0answers
6 views

when user chooses Edit in Excel the spreadsheet just hangs trying to open

A user has complained that when they try to open an Excel spreadsheet on SharePoint by choosing 'Edit Workbook' then 'Edit in Excel' it tries to open but just hangs. This happens for any Excel ...
0
votes
0answers
11 views

Export data from excel to sharepoint list through a form

Is it possible to export data to sharepoint list from excel using vba macros. The list is populated through a form which has combination of check boxes, drop downs and text boxes and you have to press ...
0
votes
1answer
21 views

Sync Excel and SharePoint List

Has anyone ever done this successfully using Excel 2010 ? I downloaded the Add-in (SynchronizeWSSandExcel: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=9345 ) but it's ...
1
vote
1answer
27 views

create Content Types like Excel,PowerPoint,One Note documents for document library in SP2013?

I want to create Content Types like Excel,PowerPoint,One Note documents for document library in SP2013,by default once enable the content type in Advance settings,we can able to see the Word content ...
0
votes
1answer
1k views

Add and Update Single Item in Sharepoint List via VBA

I am trying to add and/or update single items in a SharePoint list via VBA and I found a similar question: But I have to say that I can only delete items with this code and I am not familiar with ...
5
votes
7answers
19k views

Update Sharepoint list using excel

I have a SharePoint that has list and I need to be able to update this list with new values from an Excel sheet (using VBA). This can be done from Access not a problem however I need it to be Excel ...
2
votes
1answer
430 views

Saving an Excel file: You do not have the correct permissions. Contact the server administrator

A user is attempting to open an excel file from a SP 2010 library, make edits, and save it back. when clicking save, he gets this error message in a popup window: You do not have the correct ...
0
votes
1answer
431 views

Dashboard from Excel file with Data Validation and Protected Sheets

I want to create a dashboard in Sharepoint using data from Excel Workbooks. Each Workbook has 2 sheets: Data and Dashboard. The Data worksheet contains raw data and the Dashboard tab contains KPI's ...
0
votes
0answers
9 views

Open html exported from Excel as a webpage

I've been troubleshooting this one for a while now. SharePoint 2013 is opening my htm/html files that I export from Excel as an Excel Worksheet. I want the htm/html files to just open as a html ...
0
votes
1answer
442 views

Trouble opening Excel Document

I have Microsoft Excel 2007 and am trying to open and edit a document from my Employer's SharePoint (I am not sure what version of SharePoint they are running, unfortunately). I have attempted to ...
0
votes
1answer
306 views

Sharepoint 2010 / Google Chrome / Excel

From one of our users: Now that many of the items seem to work with Sharepoint and Chrome, one of the biggest outstanding issues is that it wants to open the documents in the browser by default. ...
1
vote
0answers
36 views

Excel data doesn't appear, in the Excel Web Access

I've added an Excel Web part into my page. I did check out this excel workbook. But, when I want to run my page , I'm getting as follows error. Also,when I want to open xslx file in my desktop, the ...
0
votes
0answers
9 views

how to stop DATEDIF function when employee is terminated

I'm using the DATEDIF function to Calculate the time an employee has been employed. I'm using =DATEDIF(G25,TODAY(),"y") But what I want to do is to stop calculating the time when an employee is ...
1
vote
3answers
816 views

How to create an auto-updating chart from a Sharepoint list

Is there a way to create a chart/graph from a Sharepoint list, whether through Sharepoint graphing or MS Excel, so that the chart will automatically update when the data in the list changes? I've ...
1
vote
0answers
748 views

SharePoint 2013 Excel Services & External Data Refresh Failed

I need advice how I can fix problem with Excel external data connection. I have an excel file, which have connection to SSAS. Excel file "refresh all" works fine if I download it out from SharePoint. ...
0
votes
0answers
40 views

Update Excel document without checking in and checking out

Suppose we upload a shared Excel document in the SharePoint 2013. If we try to edit it allows to edit for a windows user and allows to save it. If then another windows user tries to edit the same ...
1
vote
1answer
269 views

Sharepoint Excel data table and Chart

Need help about sharepoint. I have a table data collection currently in ms excel document look like the following image. every last day of the week the information will be updated (append new ...
4
votes
1answer
2k views

Error while opening sharepoint list in datasheetview and exporting to excel

I have a List which is having around 14000 items in it.while opening that list in datasheet view it is giving error . Below is a summary of the issue: After selecting datasheet view : "Cannot ...
0
votes
0answers
11 views

Sharepoint Excel Error IE9 - Workbook is larger than the maximum workbook size allowed to be opened in the browser

A few of my users who are using ie9 for a sharepoint housing a few excel files around 19mb are experiencing a recent issue where they cannot see 'read only or edit' options; (this is enabled to open ...
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. ...
1
vote
1answer
636 views

Export to Excel for sharepoint 2010

Export to excel was previously not working for clients that were using Office 2007 because we we are using claims based authentication. A few days ago a few clients noticed that the export to excel ...
0
votes
1answer
630 views

Can't open excel file in edit mode, currently open by 256 users

I got an issue from one of my users, where he would get the following message whenever he opened a particular excel file stored in a document library. The workbook is currently open by 256 users. ...
2
votes
1answer
2k views

SharePoint Foundation [Unable to process the request in Excel Web App]

I am encountering below error msg whenever I try to open excel file (.xls, .xlsx) in SharePoint Foundation 2010 portal. Other Office files such as word, ppt opens correctly without any error but ...
0
votes
2answers
95 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
0answers
9 views

refreshing a query in Excel from a list of Sharepoint

When I have added more records to a list on SharePoint and I run "refresh query" in Excel, I don't see the added records in Excel. Looking at the table the range of it can not be extended, for the ...
3
votes
1answer
385 views

Export to Spreadsheet option missing from Actions in SharePoint 2013

I am unable to export a SharePoint List (Survey) to a spreadsheet. The option "Export to Spreadsheet" is missing from the Actions dropdown menu for the list. I've done lots and lots of searching for ...
0
votes
1answer
56 views

Automatically Import Excel Data to SharePoint List

This question has been asked before but I haven't found an answer that works for me and my limitations. I have an excel spreadsheet that is currently being used to input data with 20+ records each ...
0
votes
0answers
38 views

excel macro to vlookup sharepoint list

I am trying to create a macro that looks up data (vlookup) from a SharePoint list. Once done, I want all the contents in my excel file to replace those in the SharePoint list. I can do all this from ...
1
vote
1answer
423 views

Why does SharePoint 2010 Excel WebPart not find Excel spreadsheet in Share Documents?

I have a SharePoint 2010 single instance. The Web site has an Excel worksheet in Shared Documents, which I can navigate to as a user. I have enabled Excel services. I have activated Excel services ...
0
votes
3answers
51 views

Export selected item from list to excel

I'd like to know if there are a way to export to excel the selected items in a sharepoint list i'm in sharepoint 2010
0
votes
0answers
11 views

Disabling copy/past in Excel Web App

Is there a way to prevent a user copying and pasting cells from online version of excel - either excel web services or web app?
0
votes
1answer
6k views

Cannot open file using Edit options

We recently had a few users in our environment upgrade to Excel 2010 and all these users are now experiencing the same problem where they cannot edit files by clicking them in the library or using the ...
0
votes
0answers
39 views

How to insert new records on an sharepoint list from EXCEL VBA

I have an worksheet with the code below and I wanna populate a SharePoint list with it, but the code returns me the error: It isn't possible update the changes while there is validation errors in ...
0
votes
1answer
17 views

Can I extract a list with a button in infopath 2010?

I'm working on sharepoint 2010. I want to know if it's possible to create a button which extract the list the infopath is based on in an excel sheet. Thanks.
0
votes
0answers
15 views

Opening older Office files in SharePoint 2013

We have an external SharePoint site set up using version 2013. We have saved Word documents and Excel spreadsheets in older formats such as Office 2003. The reason for this is that customers ...
3
votes
1answer
13k views

Documents open read-only when user should have write access

Scenario: We have an internal application that ties Excel spreadsheets stored in a SharePoint doc lib with specific Opportunities in CRM. The user clicks on a button in the Opportunity and a Web ...
0
votes
1answer
36 views

Unable to update an excel file in SP

One of our users is currently trying to update an excel file that is saved directly to our SP document library. Whenever he tries to update it and save it the changes for some reason never save. It ...
0
votes
1answer
30 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 ...
7
votes
2answers
5k views

Adding document version number on Excel Spreadsheet as label for printing purpose

I have a situation where I need to have version number on each document in version controlled document library. Having version number on printed sheet would help to see the validity of document. I ...
0
votes
0answers
17 views

how to change the headers of a list exported to excel?

I want to use the sharepoint 2013 feature exporting to excel from a list but I want to change the name of the fields, how can it be done?
3
votes
0answers
3k views

We cannot locate a server to load the workbook data model

This is the error that appears when I try to refresh data. I have been struggling with this issue for a few weeks. Researching in internet but with no luck. My sharepoint site is 2013 and SQL Server ...
1
vote
0answers
24 views

Use a workflow to filter a list

I have a spreadsheet that contains numerous products, each one with a unique PN, desc and price. There is similarity between products, contained in additional columns with simple YES or NO values ...
1
vote
0answers
57 views

“Open in Excel” prompt disabled when accessing workbook through office web apps

We're trying to share an excel workbook through SharePoint which sends a link through mail with "web=1" which calls for excel web access. since the document has unsupported features in OWA, it prompts ...
1
vote
0answers
35 views

Unsupported features: Display of formulas in cells

I have a number of Excel templates that are stored in SharePoint library. When trying to either view or edit the files in my browser, I get the error message that the browser can't be used because ...
5
votes
0answers
52 views

Export to Excel adds  to currency field in sharepoint 2013

I am trying to export the data to .xls file using below code GridView2.DataSource = dt; GridView2.DataBind(); DirectoryInfo dir = new DirectoryInfo(@"C:\New List Reports"); ...
0
votes
0answers
37 views

Insert SharePoint metadata into excel cell

What is the best way to create a system that inserts metadata fields of the document in SharePoint in a cell in Excel? I've done this behaviour multiple times in a Word document using the 'Quick ...
0
votes
1answer
36 views

Quick edit List URL field

I need to use the quick edit on a Link List (I am copying data from an Excel file). I am having trouble with the URL field, I can easly insert the URL but I don not know how to insert the URL name. ...