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
0answers
17 views

Rest API Excel Services error forbidden

We have created a SPD workflow with below details: URL: **/_vti_bin/ExcelRest.aspx/Shared%20Documents/test.xlsx/odata/Table1 Headers: Accept: "application/json;odata=verbose" Result: d/result(0)/...
0
votes
0answers
19 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 ...
0
votes
1answer
14 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/...
0
votes
1answer
22 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 ...
0
votes
2answers
41 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 ...
0
votes
1answer
225 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
vote
3answers
1k 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
75 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
25 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
104 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
1k 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
124 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
27 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
36 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
71 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
37 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
63 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
588 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
550 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
99 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
78 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
1k 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
272 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
346 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
801 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
145 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
676 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
106 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
25 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
163 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
1k 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
38 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
183 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
268 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
126 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
302 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
31 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
155 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
206 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
365 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
73 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
505 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
617 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
100 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
167 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
85 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). ...

1
2 3 4 5 6