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.
296
questions
0
votes
1
answer
388
views
Import data from multiple excel file to SharePoint list using power automate
I have more than 150 excel files which all have same information table to update their production from different location. my question is can I use Power Automate to import and consolidate all data in ...
0
votes
1
answer
55
views
How to use Excel Service (/Model) with Document ID enabled
I'm currently running SharePoint 2016 and have Document ID service enabled.
Knew that once I enable the Document ID service, documents' URL will change from ~/DOCLIB/filename.xlsx to ~/_layouts/15/...
0
votes
1
answer
74
views
Migrating from Sharepoint 2013/excel services to Office 365
Does anyone know of a migration path from Sharepoint 2013/Excel Services to Office 365? We have a bunch of Excel workbooks stored in SP 2013, which we calculate using Excel Services via the Excel ...
- 101
0
votes
1
answer
495
views
How to suppress Excel Services query warning in Sharepoint online?
I am using Excel Services to display items from an Excel workbook that has a query connection for its data. Each time I load the Sharepoint page, the Excel Services web parts ask if I want to run the ...
- 1
0
votes
0
answers
663
views
Error: The data connection uses Windows Authentication and user credentials could not be delegated
Environment: SharePoint 2016 (On-prem) with on-prem Office Online
When users attempt to navigate to an Excel file with an embedded datasource, they receive the following error:
The data connection ...
- 111
0
votes
1
answer
1k
views
Connect excel file in Excel Web in Sharepoint to external SQL server
It is the first time that I am using the web version of excel with external data sources on Sharepoint so I hope that you can help my with that.
I do have an Excel list that grabs data from an on-...
0
votes
0
answers
81
views
Excel file saved as htm to render properly when uploaded in SharePoint library
I use DriveToWeb to host a webpage (and supporting files) with OneDrive. My website is basically an Excel file saved to .htm file so it has supporting files.
Why do I save Excel files to .htm files ...
- 33
0
votes
1
answer
169
views
SP 2010: Excel Calculation Services is not restarting
Excel Calculation Services is not restarting, and when researched, i found an error
There was an error in communicating with Excel Calculation Services http://server:32843/...
- 19
0
votes
1
answer
245
views
How can i find the Excel services URL for my file?
I'm trying to access through the Excel Rest API an excel file "My Excel File.xlsx", but regardless how I what excel services URL I use, I either get 404 or file does not exist or is deleted.
This is ...
- 1
0
votes
2
answers
2k
views
Copy and Pasting in SharePoint Excel - Without overwriting data?
This seems like such an easy, basic thing--but I can't for the life of me figure out how to do it. I just want to copy and paste cells from an Excel sheet into a SharePoint Excel WITHOUT overwriting ...
- 1
0
votes
1
answer
1k
views
How do I use the Get Data function / From File / From Sharepoint folder within Excel?
What I am wanting to do is link up to 4 different workbooks together that we have on our company sharepoint. The problem is I have not been able to find a way to link workbooks together in sharepoint ...
- 1
1
vote
3
answers
5k
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 ...
- 23
1
vote
1
answer
329
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 ...
- 301
1
vote
1
answer
2k
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 ...
- 71
0
votes
1
answer
227
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
1
answer
33
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 ...
- 177
0
votes
2
answers
58
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 ...
- 65
1
vote
1
answer
577
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 ...
- 90
3
votes
0
answers
53
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 ...
- 12.5k
1
vote
2
answers
273
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 ...
- 211
1
vote
1
answer
1k
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
2
answers
1k
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\...
- 43.3k
0
votes
0
answers
159
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 ...
- 183
1
vote
1
answer
104
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 ...
- 2,146
0
votes
4
answers
4k
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 ...
- 101
0
votes
1
answer
307
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 ...
- 125
0
votes
1
answer
381
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 (...
- 131
1
vote
0
answers
2k
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 ...
- 528
0
votes
1
answer
173
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
1
answer
947
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 ...
- 521
1
vote
1
answer
117
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 ...
- 11
1
vote
0
answers
33
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
0
answers
26
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. ...
- 199
2
votes
0
answers
257
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 ...
- 153
1
vote
1
answer
2k
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
0
answers
43
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/...
- 121
2
votes
2
answers
4k
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 ...
- 659
1
vote
1
answer
208
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 ...
- 489
1
vote
1
answer
424
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 ...
- 3,636
1
vote
0
answers
145
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:
"...
- 11
1
vote
0
answers
27
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
- 51
2
votes
1
answer
375
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
1
answer
39
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 ...
- 253
1
vote
1
answer
194
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
0
answers
213
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
2
answers
601
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 ...
- 13
2
votes
0
answers
82
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 ...
- 2,925
3
votes
1
answer
562
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.
...
- 31
2
votes
1
answer
4k
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 ?
- 1,709
0
votes
1
answer
717
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....
- 11