The Stack Overflow podcast is back! Listen to an interview with our new CEO.

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
1
vote
3answers
207 views

Upload failed, this file was not uploaded because the specified path was not found on server

What could be the cause of the file being unable to upload. I have searched the internet but nothing worked, and the information was posted around 6+ years ago. Just want to know if anybody has ...
1
vote
1answer
35 views

sharepoint on premise losing excel changes

SharePoint 2013 on premise is not always saving changes in Excel to the point that some colleagues are losing hours of work. Why does this keep happening? May I add, that the drafts can be see in ...
0
votes
0answers
22 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
55 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. ...
1
vote
1answer
767 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 ...
0
votes
1answer
64 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
26 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
35 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
46 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 ...
3
votes
0answers
31 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
58 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 ...
1
vote
1answer
440 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
347 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\...
0
votes
0answers
53 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
69 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 ...
0
votes
4answers
679 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
207 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
317 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 (...
1
vote
0answers
610 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
134 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
596 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
100 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
31 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
23 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
145 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
900 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. ...
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 ...
1
vote
1answer
143 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
245 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 ...
1
vote
0answers
115 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
0answers
26 views

sharepoint Excel services poor Performanace

I have a excel dashboard in SharePoint 2013 environment that takes for ever ( > 2 min) to open . is there any way anyone can help me in terms of performance tuning this service ? Thanks
2
votes
1answer
254 views

Opening Excel sheets from the browser

I have an interesting issue that I'm more or less looking to find out if it's possible to fix or not. We have a 2013 site that uses Excel Services and a custom webpart to expose these Excel reports ...
1
vote
1answer
29 views

Excel and Visio Unattended Accounts

What are the purposes of the Excel and Visio Unattended Accounts? Both services are used in the farm. I am just interested in knowing why are there dedicated for these? Do they set the application up ...
1
vote
1answer
146 views

Exporting data out of SharePoint into Excel

This is almost more of an Excel question than a SharePoint one, but I want to be able to pull specific data out of a SharePoint list into excel dynamically. Specifically, I don't want to export a ...
1
vote
0answers
205 views

Display Excel Sheet Data without configuring Excel Services in Sharepoint

We have configured Office web apps in our SharePoint 2013 environment so now we don't want to configure Excel Services in this environment. Office web apps are working fine we are able to perform the ...
1
vote
2answers
305 views

Access Excel services in Sharepoint Online gives 401

I'm trying to access the rest API of Excel services in SharePoint online from a webjob in C#. I have a client secret and ClientId of an registered add-in and can make Rest request to normal lists and ...
2
votes
0answers
72 views

excel document not open in browser and application pool is stooped

I created an excel service application and added in service connections proxy to the web application, but in app server where I enabled excel service application pool is stopped every time. when I ...
3
votes
1answer
470 views

Date Format On SharePoint 2013 Reports

I have Reporting Services reports and Excel Services files published in Sharepoint 2013. The date format of the regional configuration has been changed to Colombia by Date format DD / MM / YYYY. ...
2
votes
1answer
3k views

How to Edit a Excel Documents on Browser in Sharepoint 2013

I must Enable editing in browser Sharepoint 2013 Excel Document. And i Cant do it. How could I enable this to editing any Excel document in browser at Sharepoint 2013 ?
0
votes
1answer
554 views

How do I fix “this range cannot be published due to an internal error” when trying to create a list from an excel file?

I have tried making sure there are no formulas in the file. I have started with a fresh file. I have checked the trusted sites in internet explorer. I am trying to upload from my users download folder....
1
vote
0answers
97 views

Copy paste the value from one cell to another based on condition using VBA [closed]

Below are my steps that I need to perform in excel. and I wanted to automate this as & when I run Macro :) Background : I have already imported one sheet from another workbook and recorded the ...
1
vote
1answer
164 views

What is best option for BI capabilities with SharePoint

In SP2010 there are silver light dashboards used to be there in our project. Now we planned to convert them into BI reports in SP2013. All these report data is coming from list and libraries. Some ...
0
votes
1answer
78 views

Excel Web Access web part get selected text in SharePoint Online

Anyone has idea on retrieving the selected text from excel access web part in SharePoint using javascript API? Requirement: I have an Excel sheet which has a big matrix (multiple rows and columns). ...
2
votes
0answers
89 views

Why does the Manage PowerPivot Data Refresh page show a data source that is not in the workbook being configured?

I have several Excel workbooks hosted on an on-premises SharePoint installation that are refreshed each day. Each workbook accesses one of our Analysis Services cubes via Excel Services. When I went ...
3
votes
0answers
509 views

Excel Services: Configuring Data Refresh for an External Workbook Data Source

Honestly, configuring this has been such a hard experience. I encountered many errors already, one after another but am stuck now. To illustrate what I've come across so far, I've had problems with ...
0
votes
1answer
47 views

Does Excel Services support connecting / refreshing external data that comes from another workbook?

I'm testing Excel Service via the Excel Web Access Web Part. I managed to make a working sample of a chart that retrieves its data from a SharePoint List. However, for some reason, I can't make a ...
1
vote
0answers
4k 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 ...
2
votes
0answers
343 views

SharePoint 2010: Excel Services Cache sub-directories randomly missing

Our client is receiving an intermittent issue (every month or so) whereby the Excel Services cache inside C:\Windows\Temp\Excel Server\FileCache\GUID\ will having missing sub directories. When ...
1
vote
1answer
118 views

Unable to open the Excel workbook on SharePoint 2010

I am unable to open the Excel workbooks from our production site in SharePoint 2010. The same Excel file was uploaded to UAT and it is working fine. Please find the fig below for the exact error am ...