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
1answer
3k views

SharePoint List lookup from Excel file

I would like to know, whether we can look up for a value in an excel file within a SharePoint list. I know that we can setup look up within different lists within a site. But i would like to know, ...
0
votes
1answer
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 ...
4
votes
1answer
1k views

Why does SharePoint 2010 Excel WebPart not find Excel spreadsheet in Share Documents?

I have a SharePoint 2010 single instance. The Web site has an Excel worksheet in Shared Documents, which I can navigate to as a user. I have enabled Excel services. I have activated Excel services ...
2
votes
2answers
6k views

When I try to view Excel in browser I got error We don't know what happened, but something went wrong

When I try to view Excel in the browser I got error We don't know what happened, but something went wrong. When I try to edit file is ok? In the event log I get: There was an error in ...
0
votes
1answer
2k views

Unable to save workbook in SharePoint Online / Office 365

We have a team site with a document library with 4 excel documents in it. When we want to edit the document using the Excel online editor we get an error: "Unable to save workbook". The changes are ...
1
vote
1answer
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 ...
1
vote
1answer
938 views

Sharepoint 2013 Excel Services not able to pass parameters to spreadsheet

I'm new to Excel Services. My requirement is to use parameters in the Excel spreadsheet to refresh the data from External data sources. In an Excel spread sheet, I have created an ODBC connection ...
5
votes
2answers
5k views

An error occurred while loading the model for the item or data source 'EntityDataSource'

I use SQL Server 2012 SP1 U8 and SharePoint 2013. I configure Excel Service and Performance Point Service and PowerPivot Service. I create an Excel File`that fetch data from Data Warehouse in ...
0
votes
1answer
1k views

Change Excel web access dynamically using javascript

I have a page with a button and an Excel web part. When I click on the button I want to load another Excel file in that web part. Is it possible to do this? Please suggest some ideas on it.
1
vote
2answers
184 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 ...
0
votes
1answer
798 views

SharePoint 2010 List Excel Export Error

I have some problems about exporting a SharePoint List to excel. I'm getting "Excel cannot connect to the SharePoint list" error while exporting it to excel. There wasn't any error in the same list ...
5
votes
1answer
8k views

SharePoint Online & Excel Services -> unable to refresh data connections

I'm trying to create a few very simple reports based on my SharePoint Online data using Excel. I've got as far as getting the data into Excel and creating my report, and now I'm trying to upload the ...
0
votes
0answers
5 views

Excel Add-Ins deployment in Sharepoint Excel ( a work around for Sharepoint excel webview bug, where user can remove the filter on protected sheet

Please may I know step by step process of taking a excel add-ins stored as .XLAM and to be deployed in Sharepoint excel, to enable many users to have the functionality and at the same time hide the ...
0
votes
1answer
23 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/...
2
votes
0answers
530 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
2answers
5k views

Unable to refresh data for a data connection in the workbook.

I am trying to use an Excel Web Part that connects to a list in Sharepoint 2010. On my local drive the spreadsheet updates when I open it and all is well but when I uploaded to sharepoint the data ...
0
votes
1answer
717 views

Sharepoint Excel Logic

I have an Excel spreadsheet that I would like to import onto Sharepoint. The import/export function is easy enough to use, however the math logic that four of the cells conduct in the Excel ...
0
votes
4answers
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 ...
0
votes
1answer
50 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 ...
0
votes
1answer
202 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
vote
0answers
355 views

Excel Service Data Refresh Issue in SharePoint 2013 Online Office 365

I am using Excel Services in Office 365 SharePoint Online to show Workbook Pivot Reports data pulled from SQL Server 2008. I have used Secure Store for saving Database Credentials & Configure ...
0
votes
2answers
44 views

SharePoint 2010 PowerPivot DAX functions

Hi I have a PowerPivot with a calculated column that returns data via the RELATED function. The columns works perfectly except for a handful of rows that return an empty cell. After some ...
0
votes
0answers
236 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 ...
0
votes
1answer
711 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-...
7
votes
3answers
64k views
0
votes
0answers
41 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
78 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
103 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
725 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
votes
2answers
1k views

Excel Web Part error message in SP2013

I have a SharePoint 2013 Team site with Excel Services web parts. Lately, I see the Excel Web parts perfectly (in Israel) but in the same time my colleagues (in USA) seeing error messages instead of ...
2
votes
5answers
66k views

Excel 2013 workbook will not open in client application from SharePoint, only browser

I created a protected, macro enabled, .xlsm workbook on excel 2010 that is meant to be edited by many people. I uploaded it on my company's SharePoint site (Not sure if it is 2010 or 2013, I can't ...
1
vote
3answers
3k 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
210 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 ...
1
vote
1answer
1k views

How to delete a row from an Excel Table using the client-side Ewa object in a SharePoint Excel Web Part

The SharePoint Excel Web Part client side API ,Ewa (https://msdn.microsoft.com/en-us/library/office/ee589018.aspx) does not seem to have any methods to manipulate an Excel Table (i.e. a ListObject in ...
12
votes
8answers
275k views

Excel links open files as read-only mode. How to change this to edit mode?

Does anyone have any idea why using the link on excel opens the file as read-only mode? How can I change the behavior to open as Edit mode? I checked almost all of the Document Library settings, but ...
1
vote
1answer
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 ...
4
votes
4answers
7k views

Open Excel file in browser returns error

I have configured an excel document library to open in the browser. The file was published to the document library. The document library was set to open the file in the browser. When the file is ...
0
votes
1answer
203 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
31 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
47 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
347 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 ...
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 ...
3
votes
0answers
50 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 ...
2
votes
1answer
2k views

How to access Excel PROTECTED spreadsheet in SharePoint Web Access Web Part in SharePoint2013?

I have excel file which is protected by password. I need to access Sheet 1 on SharePoint Web Part Page on Dashboard. While I add protected I can not able to Excel Sheet is corrupted as per below image....
0
votes
2answers
942 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\...
11
votes
9answers
72k views

Unable to open office files in Office client

While trying to open an excel document stored in "Shared Documents" library, the excel application opens up with a login prompt, to which I passed the login credentials of the site. After which the ...
0
votes
0answers
143 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
99 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 ...
6
votes
1answer
70k views

Lock Cells to Certain People But Give Access to others in a Live Excel Online Worksheet

My company has switched from Google Docs to SharePoint and Office 365. One of the things that we need to be able to do is have a collaborative live/dynamic spreadsheet that give lock some cells to ...
0
votes
1answer
296 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 ...

1
2 3 4 5 6