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.
298 questions
0 votes
0 answers
33 views
How to update excel in SharePoint using Excel Services REST API
I could read content for the excel cells or ranges via the Excel Service REST api using GET method. Is there any way to set the content? I tried with following url, but it only returns the updated ...
- 1
0 votes
0 answers
34 views
How to read excel file in SharePoint and write data in to new file on same sharepoint
I'm now creating a microsoft form which will accept excel file upload. All files will be uploaded to SharePoint site folder, that all successful. and now I want to read all rows from each file (there ...
- 1
0 votes
1 answer
941 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
212 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
132 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
693 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
1k 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
2k 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
134 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
290 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/...
- 29
0 votes
1 answer
411 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
3k 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
6k 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
465 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