Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
4answers
522 views

Be careful. This workbook contains one or more queries that might be unsafe

I try to display data using Excel services in a web part. First of all, my Sharepoint version is Sharepoint 2013; In addition, all authentication processes are working properly and I can retrieve the ...
0
votes
1answer
1k views

Change Excel web access dynamically using javascript

I have a page with a button and an Excel web part. When I click on the button I want to load another Excel file in that web part. Is it possible to do this? Please suggest some ideas on it.
1
vote
1answer
2k views

SharePoint List lookup from Excel file

I would like to know, whether we can look up for a value in an excel file within a SharePoint list. I know that we can setup look up within different lists within a site. But i would like to know, ...
12
votes
8answers
213k 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 ...
0
votes
0answers
21 views

Excel lost all recent changes, even though the versions are there

I have an excel sheet in sharepoint on premise that was opened and edited several times - I saved every now and then and the version number kept increasing, however when I closed and opened the file ...
0
votes
0answers
28 views

PowerPivot Management Dashboard Processing Timer Job failed with error, “We cannot locate a server to load the workbook Data Model”

All of sudden PowerPivot Management Dashboard Processing Timer Job has started failing in my SharePoint 2013 server. I have verified below: The Power Pivot SQL server instance is running SQL Server. ...
5
votes
2answers
5k views

An error occurred while loading the model for the item or data source 'EntityDataSource'

I use SQL Server 2012 SP1 U8 and SharePoint 2013. I configure Excel Service and Performance Point Service and PowerPivot Service. I create an Excel File`that fetch data from Data Warehouse in ...
4
votes
1answer
1k 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
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 ...
0
votes
1answer
2k views

Unable to save workbook in SharePoint Online / Office 365

We have a team site with a document library with 4 excel documents in it. When we want to edit the document using the Excel online editor we get an error: "Unable to save workbook". The changes are ...
0
votes
1answer
635 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 ...
1
vote
1answer
741 views

Sharepoint 2013 Excel Services not able to pass parameters to spreadsheet

I'm new to Excel Services. My requirement is to use parameters in the Excel spreadsheet to refresh the data from External data sources. In an Excel spread sheet, I have created an ODBC connection ...
0
votes
1answer
798 views

How to delete a row from an Excel Table using the client-side Ewa object in a SharePoint Excel Web Part

The SharePoint Excel Web Part client side API ,Ewa (https://msdn.microsoft.com/en-us/library/office/ee589018.aspx) does not seem to have any methods to manipulate an Excel Table (i.e. a ListObject in ...
1
vote
1answer
315 views

Object doesn't support property or method 'readAsBinaryString' IE 11

I am using xlsx.core.min.js to upload excel files to SP and pass their contents to a new list. I have it working in Edge but it will not work in IE 11. The first console error I received was "Object ...
3
votes
4answers
5k views

Open Excel file in browser returns error

I have configured an excel document library to open in the browser. The file was published to the document library. The document library was set to open the file in the browser. When the file is ...
0
votes
1answer
38 views

Excel service on sharepoint 2010

Trying to start excel services application web service application. The status just seems to be stuck on stopped. Timer service is running and so is excel calculation service. Any ideas?
0
votes
1answer
23 views

After migration the custom Export excel is showing an error

After upgrading from SharePoint 2010 to SharePoint 2013 ,the custom Export All is displaying this error : An error occurred while generating your excel file, whereas the default Export to excel is ...
0
votes
2answers
33 views

How does Excel Service applications worked on Sharepoint Online

I would like to know how to get my Excel Service applications on the Sharepoint Online started. As I am still quite new to this SharePoint Online environment and be working a lot on this environment ...
1
vote
1answer
35 views

Linked images (cells copied from other spreadsheets pasted as linked image) do not show in Excel Web Acess Webpart on SharePoint page

I uploaded Excel file with multiple sheets and a Summary sheet(just another spreadsheet in same file) containing charts and cells pasted as "linked images" from other sheets in a document library in ...
0
votes
0answers
12 views

WAS excel deletes the Title

I have a peculiar problem. When I edit an Excel file online (Web App Server server), it empties the Sp field Title. When I edit it using the pc Excel, everything is fine. I'm using a document library. ...
1
vote
0answers
3k views

We couldn’t load the Data Model. This may be because the Data Model in this workbook is damaged

Requirement Criteria I have SharePoint 2013 on premise. I have an excel sheet which loads data from the SharePoint list using listdata.svc service. I am able to load the data into the excel sheet ...
3
votes
0answers
26 views

ADO.NET Data Services for SharePoint 2016?

As I was asking in a related question, I'm trying to figure out how to get a PowerView report going that is using a SharePoint list as its data source. In researching how that can be done, I found ...
1
vote
1answer
46 views

Requirements for excel data refreshing

What are the requirements to be able to update data that came from Sharepoint (using Export to Excel button) by Excel "Refresh All" button? On some machines I can refresh (when authentication prompt ...
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
341 views

Excel 2010 issue in Sharepoint 2013 - We are sorry we cant open your work book

Can anyone help me with this issue? I am getting an error while opening a excel file in the SP 2013 browser window: "We're sorry. we could not open your workbook. Its possible corrupt or using a ...
0
votes
2answers
237 views

Excel Web Access cannot open file

I have a site that was backed up and restored from one content database to a new content database using the below command. Backup-SPSite -Identity https://sp.domain.org/sites/thesite -Path D:\backups\...
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 ...
0
votes
0answers
49 views

Links to Excel files in doc libraries are opening differently for different users

I have a link to an Excel file in a doc library that opens in Excel Online. When opening it, some users are getting prompted to open the file in Excel 2016 and some users are getting prompted to open ...
1
vote
1answer
58 views

powerpivot excel sheets in Sharepoint online?

We have finally decided to move SharePoint On prem to SharePoint Online. In our on prem site we have BI site where we house 15-20 excel sheets which utlize powerpivot within them which gets refreshed ...
4
votes
1answer
34k views

Lock Cells to Certain People But Give Access to others in a Live Excel Online Worksheet

My company has switched from Google Docs to SharePoint and Office 365. One of the things that we need to be able to do is have a collaborative live/dynamic spreadsheet that give lock some cells to ...
0
votes
1answer
141 views

Excel web part vs rest api

I want to DISPLAY multiple excel charts on a dashboard. I Do Not need the functionality of the excel web part. So, what I plan on doing is getting an image of the charts via the excel rest api and ...
0
votes
1answer
264 views

Links inside Excel files should open Excel files in another library

We have a bunch of excel files that contains so many relative URLs to other documents. Now we are uploading source file to one location (Document Library) in SharePoint and uploading the linked file (...
16
votes
3answers
598 views

SharePoint Online List limitations

Is it just me or is it really strange that SSRS 2012 still does not support Claims based authentication or OData connections? Anybody know of plans? Reasons for such a hole in the strategy? Part of a ...
7
votes
3answers
38k 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
1
vote
0answers
535 views

Excel services MSOLAP.8 provider for SSAS OLAP cube

I have an Excel file in SharePoint 2013. This file has an underlying connection to SSAS OLAP cube. However, when trying to open this file using Excel Services, the following error occurs: The ...
0
votes
1answer
124 views

sharpoint list doesn't connect to excel service via web browser

I am running with an issue which caused me a lot of waste time in vain, I customized a SharePoint with InfoPath 2013 and connected it to an excel file(using excel service)to perform some complicated ...
0
votes
1answer
550 views

Error while Refreshing Excel data using connection with SharePoint Online List

We have created a SharePoint list with 50000+ items in it which has different views. We exported the same SharePoint list using Export to Excel functionality. After that we created a dashboard on ...
1
vote
1answer
95 views

Hide the Left Bar of XLViewer.aspx

I've the need to hide the "Edit in Excel" button of XLViewer.aspx of SharePoint 2013. Unfortunately in the organization I'm working is not possible to access to the SharePoint Server, so I cannot ...
1
vote
0answers
30 views

SP2013 + Excel Services .. Help!

I've next scenarios, two server A and B, A is the server of front-end and B is the server of services, We have this in Internet, any users could select the information, this case de users anonymous, ...
1
vote
0answers
21 views

Excel Services PowerPivot - Item Level Permission

I have implemented PowerPivot Chart, PowerView and uploaded the same to PowerPivot gallery on BI Site. Excel Services is configured with "Unattended Service Account" to retrive data from Data Source. ...
2
votes
0answers
116 views

Read excel file in library1 and update excel file in library2/list using powershell in sharepoint online

If user enters/updates raw data in excel file in document library1 which resides in SharePoint online site updated data should be reflected automatically in excel file in other document library2 or ...
1
vote
1answer
703 views

Exporting calender from share point to Excel

When I export calendar from share point to excel, I could only see data for one month (current month) in the excel. But, I want to see the data for complete year in the calendar exported to the excel. ...
1
vote
0answers
247 views

How can I remove Excel menu in web apps in Share Point 2013?

I use SharePoint 2013 and I use Power Pivot Service. When I open an Excel Report, I see this report : How can I remove Excel menu(File/Open In Excel / Data/...) from this report?
2
votes
0answers
34 views

Unable to get all worksheets ranges with REST API

Maybe I am doing something wrong or I didn't get the way to get my data. I tried to call: curl -k --ntlm --user user:pwd https://sharepoint.server/dept/_vti_bin/ExcelRest.aspx/Department/mydoc/...
2
votes
2answers
2k views

How to populate sharepoint list with excel data?

I have a excel sheet whose columns and my sharepoint list columns are same. But when i try to export from excel this doesn't works. I have some specific column types which cant be altered because i ...
5
votes
4answers
24k 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
1answer
1k views
1
vote
0answers
109 views

Field to refresh PowerQuery from SharePoint

I created excel file with power query connections to SharePoint 365 list. then I upload that excel to SharePoint 356. The problem happens when I try open this excel file I get the message: "...
1
vote
1answer
107 views

Access columns/content of Excel document through SharePoint API for SharePoint Online.

We have a customer trying to access content of excel document that is in SharePoint online document library through API. Can anyone point out to proper documentation on how this can be done or any ...
1
vote
1answer
214 views

Unable to create or delete Excel service application due to timeout

On my server Excel Calculation Service is "started". I tried to create new Excel Service Application but after some time I get following error. And this is how it looks like after that. If ...