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

learn more… | top users | synonyms

0
votes
1answer
18 views

Excel document opening in web view even though default is to open in program

I have a document library with one Excel spreadsheet in it. The document library's settings are such that the spreadsheet should be opening in each client's Excel program, not in Excel Web View. I ...
0
votes
1answer
296 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 ...
2
votes
4answers
14k views

Excel links open files as read-only mode. How to change this to edit mode?

Does anyone have any idea why using the link on excel opens the file as read-only mode? How can I change the behavior to open as Edit mode? I checked almost all of the Document Library settings, ...
1
vote
1answer
301 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 ...
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
0answers
18 views

SharePoint Portal

I am completely new to the SharePoint development environment, though I have experience in VBA. I am attempting to create a SharePoint site that will allow several vendors to view an Excel ...
4
votes
2answers
1k views

Run an Excel Macros from SharePoint

I was wondering if it's possible to initiate Excel macros (Excel file is located on a network drive) from SharePoint? Are there any add-in features within SharePoint that can communicate with macros?
1
vote
1answer
625 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
61 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 ...
6
votes
1answer
4k 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 ...
1
vote
2answers
7k 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 ...
2
votes
1answer
40 views

Excel web app Sharepoint Online

I am currently implementing some Powerview in excel that is used on sharepoint online. My problem is that I can't get excel web app to save automatically when something is changed in excel web app ...
0
votes
0answers
5 views

Excel Web Part: add a chart with an ambiguous name

I have an excel file with a bunch of macro-generated charts in it. The charts span across different sheets, and when the macro runs to generate them, they get different names every time. I want to ...
0
votes
1answer
22 views

Excel Services data refresh does not return updated data from data source

I have an Excel include some data which from a SharePoint list. This excel is created by using "Export to Excel" button of the SharePoint list form. I created a pivot table in the excel based on the ...
0
votes
0answers
32 views

Export to Excel is slow

I am working with SharePoint 2010 / 2013. Very often I have to export large lists (>1000 Items) to Excel. This always takes some time (e.g. about 3 Minutes for 3500 list items). Is this normal, or ...
0
votes
0answers
15 views

SharePoint Designer 2013 and Excel issue

I have custom Excel addins which were getting loaded and working (in Excel 2007,2010) before installing MS SharePoint Designer 2013. After installing it the addin is always getting the LoadBehaviour ...
0
votes
0answers
5 views

Loss of formulas when using excel to move sharepoint lists

I need to move a list in Sharepoint 2010 from one site to another. I have tried doing this by (1) saving original list as an excel worksheet and (2) creating a new list from that worksheet. The ...
0
votes
1answer
26 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 ...
1
vote
1answer
356 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 ...
1
vote
3answers
5k views

Export to excel - large lists

I am having when Exporting large lists to excel (over 14K records). It displays “Running security Scan” at the bottom of the screen and then gives “An unexpected error has occurred. Changes to your ...
0
votes
0answers
14 views

Generate ppt slides from Sharepoint data

There is a form in SharePoint and I need to generate an one page Powerpoint slide using some data from that Sharepoint list. I'm thinking about creating a template in Powerpoint. Let's say there will ...
0
votes
1answer
96 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. ...
3
votes
2answers
517 views

We're sorry. We can't open the workbook in the browser because it uses these unsupported features: • Interactive report sheets

I use SharePoint 2013 and Power Pivot Services. I create a Excel report with Power Pivot and I fetch data from my Data Warehouse. I upload this Excel file in SharePoint Documents. For update my ...
1
vote
3answers
2k views

Can an Excel file be used as an external content type?

or an external datasource? Can that be set up in SP Designer 2010
0
votes
1answer
597 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 ...
7
votes
6answers
21k views

Unable to open office files in Office client

While trying to open an excel document stored in "Shared Documents" library, the excel application opens up with a login prompt, to which I passed the login credentials of the site. After which the ...
3
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
1answer
17 views

Is permission level affecting Excel links from updating?

I have some Excel documents on a Sharepoint site. I added some links to other Excel documents on a network drive. When I open the Excel files on the Sharepoint directory, they update just fine. ...
0
votes
0answers
33 views

How to get list data to Excel to create chart with date filter?

I have to create chart from a custom list in o365 site. There is one column named "Due Date" in my list. I want only those records whose Due Date is today or gone, I mean Due Date <= Today. How ...
0
votes
0answers
13 views

Cannot connect to server Excel file

I have a user in my company's portal (SharePoint 2007) that cannot upload changes made in an Excel file. He needs to have the compatibility view active in IE in order to be able to open the ...
1
vote
2answers
929 views

Export SharePoint Search Results and List View to Excel

Can we export SharePoint Search Result to Excel? Note that our client is using SharePoint Foundation 2010. I have searched the web and found a free tool that does this but unfortunately it works only ...
2
votes
3answers
6k views

create button that export custom list to excel file

I'm using sharepoint 2007, custom list. from the datasheet view I can export the list into excel/access file. is it possible to create a button that proposes to export the list to excel. (in order to ...
0
votes
0answers
17 views

Show User List in Cell Value of Excel App

I had created an app using Import Excel SpreadSheet. I have one column named as "User" in the list. I want whenever any user add the record in the list, for "User" column it should show list of ...
0
votes
2answers
46 views

Exporting SharePoint Members into Excel

Is there a proper way to export a group of sp group members into excel? I have been able to select a group from permissions and export them into excel. The problem I face was that even when I ...
0
votes
0answers
23 views

Excel web app 2013 title field disapearing

We have a document library that users will be using office web apps to edit. When using Word or PowerPoint, everything works fine. When they use Excel, it gets weird. When they edit a document, ...
0
votes
1answer
111 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 ...
3
votes
6answers
16k 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 ...
3
votes
1answer
158 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 ...
4
votes
3answers
2k views

Filtered SharePoint List for Export to Excel

I have an Issues List is SharePoint that contains over 75 different categories. I would like the ability so that when I use the filter on the column title and select a particular category, that then ...
0
votes
1answer
109 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
1answer
33 views

How to save a ExcelBook generated using ExcelTemplate on SharePoint2013 Cloud

wbook.SaveAs("c:\\temp\\blah", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, ...
0
votes
0answers
38 views

This workbook was opened from a server in read-only mode

I'm double clicking an odc file stored in the connections library of a SP site. When the workbook opens I get the following: The error window pops up when I hit Edit Workbook - can anyone shed any ...
0
votes
1answer
70 views

How to work with Excel in c#?

I have a template/format in excel which has to be used to generate salary slips. I have saved it in a document library and using interop, open an instance of it in a workbook programmatically. After I ...
0
votes
0answers
17 views

'Invalid signature' in Excel 2007 when trying to open an Excel file

In SharePoint 2010, I'm trying to open an Excel 2007 document, there I get following error: "Invalid Signature". Still the certificate of the user is valid.
0
votes
1answer
44 views

Populate an excel object with List entry items

I have a requirement that requires generation of an Excel document programmatically in SharePoint. I need to use an Excel template that has labels like Name: Designation: Email: I have a list with ...
1
vote
1answer
43 views

Importing values from a SharePoint Calendar to Excel form

My company runs EMS Service for private parties, sports events etc. We are scheduling our tasks with a SharePoint calendar. For each event one has to create a Excel sheet containing time, date, task ...
0
votes
0answers
33 views

Excel error: Cannot connect to the SharePoint list

I am trying to export some data from external list to Excel 2010 and the error is: Cannot connect to the SharePoint list (My SharePoint Server is 2013). However when I do that within Excel ...
3
votes
2answers
267 views

Retrieving list items from multiple sites via OData with Excel

I want to build a report: with Excel 2013 + PowerPivot Add-In using data from SharePoint Online that should work in Excel Services (so I'm not able to use VB, Power Query, etc.) Report should be ...
0
votes
0answers
20 views

SharePoint 2010 Workbook cannot be open in Chrome [duplicate]

The Workbook cannot be opened because it contains the following features that are not supported by excel i n the browser: Data validation Sheet Protection I'm trying to open excel document in ...
1
vote
1answer
46 views

Read excel data from attachment and display in SharePoint and allowed to edit

User would like to upload a excel file into SharePoint and he expect system to read his file and display out the data that he have uploaded in SharePoint. Besides, from SharePoint, he requested to ...