2022 Developer Survey is open! Take survey.

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
0 votes
1 answer
11 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 ...
user avatar
0 votes
1 answer
33 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/...
user avatar
0 votes
1 answer
62 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 ...
user avatar
0 votes
1 answer
354 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 ...
user avatar
  • 1
0 votes
0 answers
400 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 ...
user avatar
  • 111
0 votes
1 answer
930 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-...
user avatar
0 votes
0 answers
58 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 ...
user avatar
0 votes
1 answer
115 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/...
user avatar
0 votes
1 answer
157 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 ...
user avatar
  • 1
0 votes
2 answers
1k 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 ...
user avatar
  • 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 ...
user avatar
1 vote
3 answers
4k 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 ...
user avatar
1 vote
1 answer
260 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 ...
user avatar
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 ...
user avatar
0 votes
1 answer
214 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?
user avatar
0 votes
1 answer
32 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 ...
user avatar
0 votes
2 answers
54 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 ...
user avatar
  • 65
1 vote
1 answer
463 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 ...
user avatar
  • 90
3 votes
0 answers
52 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 ...
user avatar
  • 12.1k
1 vote
2 answers
229 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 ...
user avatar
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 ...
user avatar
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\...
user avatar
0 votes
0 answers
152 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 ...
user avatar
1 vote
1 answer
102 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 ...
user avatar
0 votes
4 answers
3k 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 ...
user avatar
  • 101
0 votes
1 answer
303 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 ...
user avatar
  • 125
0 votes
1 answer
374 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 (...
user avatar
1 vote
0 answers
1k 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 ...
user avatar
  • 528
0 votes
1 answer
168 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 ...
user avatar
0 votes
1 answer
857 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 ...
user avatar
1 vote
1 answer
115 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 ...
user avatar
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, ...
user avatar
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. ...
user avatar
2 votes
0 answers
235 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 ...
user avatar
  • 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. ...
user avatar
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/...
user avatar
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 ...
user avatar
  • 659
1 vote
1 answer
206 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 ...
user avatar
  • 489
1 vote
1 answer
394 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 ...
user avatar
  • 3,614
1 vote
0 answers
142 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: "...
user avatar
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
user avatar
  • 51
2 votes
1 answer
373 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 ...
user avatar
1 vote
1 answer
37 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 ...
user avatar
  • 253
1 vote
1 answer
190 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 ...
user avatar
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 ...
user avatar
1 vote
2 answers
540 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 ...
user avatar
  • 13
2 votes
0 answers
80 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 ...
user avatar
  • 2,905
3 votes
1 answer
559 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. ...
user avatar
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 ?
user avatar
  • 1,709
0 votes
1 answer
707 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....
user avatar
  • 11

1
2 3 4 5 6