Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [excel-services]

Excel Services is a server technology included in SharePoint. This shared service enables users to load, calculate, and display Excel workbooks on Microsoft Office SharePoint Server.

Filter by
Sorted by
Tagged with
3
votes
7answers
30k views

Excel Services 2010 Error - “The workbook cannot be opened.”

I enabled Excel Services and added a Excel Web Access viewer to my page. It's just a simple spreadsheet (which incidentally works fine on my standalone development server) that displays the error "...
4
votes
3answers
26k views

Disable Excel Web Access?

Is there a way to disable Excel Web Access (_layouts/xlviewer.aspx) completely on a Site Collection? (SP2010 Enterprise) I have enabled the "Open in Client Applications" feature and it works fine in ...
10
votes
9answers
67k 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 ...
1
vote
2answers
3k views

Excel Services REST API returns 401 Unauthorized in Workflow

I am trying to make a call to the Excel Services REST API in a workflow to retrieve information on a workbook's charts. The URL format is siteurl/_vti_bin/ExcelRest.aspx/Workbooks/Chart%20Test.xlsx/...
12
votes
8answers
223k 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, but ...
7
votes
3answers
42k views

Excel VBA code to upload document into SharePoint online 2013

I'm looking for a snippet in VBA to upload a document (PDF file) into SharePoint online
4
votes
4answers
7k views

Excel Services - Using parameter for query

I have an excel spreadsheet that returns data based on a cell value. In essence, it's Select * from table where field = Sheet2!A1. All works like expected, except when I publish it to SharePoint, ...
6
votes
3answers
20k views

how to reload worksheet displayed in excel web access webpart

I have an XSLX file in a SP 2010 document library. I use the excel web access webpart to display it in a web page. However, if I modify the file, the changes are not immediately visible on the page. I ...
3
votes
2answers
6k 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. ...
3
votes
4answers
69k views

Excel document opening in browser (unsupported features)

I am using Sharepoint 2010 and when users click on an .xlsx document in a document library it says the following: "The workbook cannot be opened because it contains the following features that ...
2
votes
2answers
5k views

When I try to view Excel in browser I got error We don't know what happened, but something went wrong

When I try to view Excel in the browser I got error We don't know what happened, but something went wrong. When I try to edit file is ok? In the event log I get: There was an error in ...
2
votes
1answer
1k views

How to access Excel PROTECTED spreadsheet in SharePoint Web Access Web Part in SharePoint2013?

I have excel file which is protected by password. I need to access Sheet 1 on SharePoint Web Part Page on Dashboard. While I add protected I can not able to Excel Sheet is corrupted as per below image....
1
vote
1answer
5k views

Unable to refresh data for a data connection in the workbook.

I am trying to use an Excel Web Part that connects to a list in Sharepoint 2010. On my local drive the spreadsheet updates when I open it and all is well but when I uploaded to sharepoint the data ...
0
votes
1answer
2k views

Event Attachments Opens Excel Spreadsheets in XLViewer

I have a calendar list with attachments enabled. When i attach an XLS file to an event, SharePoint wants to open it in xlviewer.aspx, but throws an error every time. I don't want to open the file in a ...
0
votes
1answer
674 views

SharePoint 2010 List Excel Export Error

I have some problems about exporting a SharePoint List to excel. I'm getting "Excel cannot connect to the SharePoint list" error while exporting it to excel. There wasn't any error in the same list ...