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.

learn more… | top users | synonyms

1
vote
0answers
199 views

How can I remove Excel menu in web apps in Share Point 2013?

I use SharePoint 2013 and I use Power Pivot Service. When I open an Excel Report, I see this report : How can I remove Excel menu(File/Open In Excel / Data/...) from this report?
1
vote
0answers
17 views

requesting excel services rest from console application but the server returns error code 403 forbidden

I just want to access an excel document in SharePoint, which is possible through excel services. I've written the following code for that but still it is giving me error of 403 forbidden. My code: ...
0
votes
1answer
19 views

Warning when open hyperlinks from SharePoint Excel documents

I uploaded excel spreadsheets that contain hyperlinks to other Excel files to a SharePoint document library. When I opened the hyperlinks in the external storage, everything is working fine. However, ...
10
votes
7answers
51k 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
30 views

Is Authorization needed while requesting Excel online Rest API from Sharepoint Add-in JSOM?

We are trying to access an Excel spreadsheet from a sharepoint add-in. We are using JSOM in this add-in. Intention is to populate the excel spreadsheet with some flags before user can download it. So ...
1
vote
1answer
2k views

Not able to refresh External data in Excel Sharepoint 2010

I am not able to refresh the data in Excel when see the excel report in browser. When i press Refresh All options the page get refresh but no updation in data is reflected. Actually i have two ...
1
vote
1answer
45 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 ...
1
vote
1answer
994 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 ...
0
votes
1answer
25 views

I am requesting the xlsb file from my sharepoint development site using rest API

the code is as follows., function getResponse() { var request = new SP.WebRequestInfo(); console.log(hostweburl); request.set_url(hostweburl + "/sites/techvision/ _vti_bin/...
3
votes
2answers
3k 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
608 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....
3
votes
4answers
54k views

Excel document opening in browser (unsupported features)

I am using Sharepoint 2010 and when users click on an .xlsx document in a document library it says the following: "The workbook cannot be opened because it contains the following features that ...
0
votes
0answers
28 views

SharePoint App - How to Create/Populate Excel Spreadsheet Using JavaScript and List Data

I'm trying to create a Excel spreadsheet on a SharePoint app/add-in. The data that will populate it have been gathered from several SharePoint lists on the host web. Right now, I'm able to interact ...
0
votes
0answers
17 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 ...
0
votes
0answers
41 views

Can Excel Services be called in REST in INFOPATH on Sharepoint online?

A call such as this: https://SERVER.sharepoint.com/_vti_bin/ExcelREST.aspx/Forms/helpers/NetWorkDaysFunction.xlsx/model/Ranges('DateDiffCalculation!A3')?$format=atom Returns data in the browser, and ...
0
votes
2answers
25 views

Excel->SharePoint

So I have a huge excel spreadsheet, with multiple lists and columns, how would I incorporate this into my SharePoint website as a new link? I know how to add an app, etc...but how do I add the ...
0
votes
1answer
21 views

excel upload with only specific columns

I'm trying to upload an Excel file to SharePoint, but i would like to only upload columns AL, B, and AU, and wondering if SharePoint has a way to do this, or if Excel has a way i can upload it to a ...
0
votes
0answers
24 views

Excel export to SharePoint including Relationship & Tables

I have an excel worksheet with 3 table & has a relationship among them, I will be exporting the data bidirectional (Excel to SharePoint list & Vice Versa) to SharePoint list using 'Excel Add ...
3
votes
1answer
4k 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
19 views

Import and Sync or update Bi Directional

I have an Excel file with data tables. I want to export this to SharePoint and whenever I add a record in Excel or delete a record in Excel, I want the same to be updated in SharePoint as well. It ...
0
votes
0answers
38 views

Login prompt for opening a office document from SharePoint library in IE.

There are few excel files in my SharePoint 2010 library which is a public facing site. Now when I click on the files from Chrome browser, the files get downloaded in my machine but when I try from IE(...
0
votes
1answer
39 views

SharePoint 2010 Services on Server not showing some services on some servers

SharePoint 2010 Services on Server not showing some services on some servers One server I can see all services, but when I change to a different server it only shows some services. This is a 3 WFE ...
0
votes
0answers
8 views

Excel Data Tab does not work for Excel Services when importing a worksheet from SharePoint

When I go into Excel and select the Data tab/From Web/Withing the address bar I type in the Excel Worksheet found within our SharePoint site/Click on the Go button/Click on the Import button Once I ...
0
votes
0answers
31 views

SP2010 - Cannot Open (Certain) Excel Files in Browser

I have an odd problem. I have two reported issues from users on two separate site collections (same webapp). In both cases, CERTAIN excel files that previously opened in the browser, no longer will - ...
0
votes
0answers
301 views

Excel cannot connect to the SharePoint list

I'm getting this error while exporting a custom list to excel. Any ideas why I'm getting this error? Here is the same question. Still couldn't solve this error. P.S.: "Check for server certificate ...
1
vote
1answer
15 views

Cannot add parameter to Excel Services

In the Browser View Options Parameters in Excel, why can't we select a desired named field when we click Add?
0
votes
1answer
31 views

Excel file not opening in sharepoint 2013

I am using SP2013 & created a site. I have used document library to store the documents in my site but the excel documents doesn't open it shows this error:- "We're sorry. We run into a problem ...
0
votes
1answer
114 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 ...
0
votes
0answers
58 views

Two way sync with excel and sharepoint list

This is not a duplicate question for this. Requirement is different. I followed few articles and videos to enable two way sync between excel and sharepoint by using excel wss add-in. In this way we ...
0
votes
2answers
22 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
1answer
24 views

Excel Online (many users but only one user is allowed to edit)

i have given many users have access to a excel sheet in Onedrive (excel online). Thats ok. Is it possible to give only one user access to sheet to edit. (the other users have to wait!) I want that ...
1
vote
2answers
734 views

Excel web access webpart throwing javascript error ( in ewamoss.js) in IE10

I am using Excel web access web part to display Excel reports in Sharepoint 2010. It's working fine with IE9. When I am loading the report in IE 10, it's throwing the error "Unable to get property '...
0
votes
1answer
3k views

Access was denied by the external data source. The following connections failed to refresh: “data connection name”

I created an Excel report in Excel 2013 with a data-source as SQL stored procedure. I deployed this Excel report to Trusted Excel Library. I have done all configurations correctly in Excel Service ...
4
votes
2answers
8k views

Excel VBA code to upload document into SharePoint online 2013

I'm looking for a snippet in VBA to upload a document (PDF file) into SharePoint online
2
votes
1answer
2k views

Cant open excel workbooks in browser sharepoint 2010

Okai I am currently facing an error when i try to open excel files in browser . it gives the prompt "The workbook can not be opened". Upon checking the logs I found the following entries in the log ...
1
vote
0answers
26 views

Excel Web Access print button is disabled

The print button in the excel sheet that I have uploaded to a powerpivot gallery is not enabled. How do I enable it? File > Print show a print friendly view According to this msdn article ...
0
votes
0answers
32 views

Enable Hyperlinks from Sharepoint in Excel

I have exported a SharePoint list to Excel using OData Feed connection, then uploaded the sheet to a SharePoint PowerPivot gallery. The SharePoint list have hyperlink fields, I want to enable them ...
1
vote
1answer
414 views

Error in the data model when refreshing external data in Excel

I have a BI Center site, I'm trying to open an Excel sheet in the PivotView gallery but it gives me this error: Workbook cannot be opened I have uploaded the Excel sheet in another library but ...
1
vote
1answer
3k 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 ...
1
vote
0answers
62 views

Read the entire Excel file in atom format using Excel Services

I am trying to read Excel file stored in Document Library using Excel Services. I need to fetch the entire workbook content in a single request call. I have tried using Ranges using it like http://&...
3
votes
0answers
22 views

Excel webpart showing “Loading” but not showing the excel file

I am using an excel file which uses a dataconnection stored in dataconnection library. The dataconnection gets the data from sql server using Secure store and excel services. I am trying to use the ...
2
votes
1answer
81 views

Is it possible to get data from excel file and create a pie chart and display on a sharepoint site?

Can we create a pie chart using excel reporting service. I have a excel file (.xlsx) on my SharePoint document library. I want to use excel data and create a pie chart but don't want to create this ...
0
votes
1answer
115 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 ...
0
votes
0answers
14 views

Excel Service Application Error 5244 in Sharepoint 2010 Standard

We are seeing a lot of Excel Service Application errors in the Event logs, even though there is no Excel Service available in sharepoint 2010 standard that we are using. How can I find out where ...
0
votes
0answers
48 views

Error in Excel, You do not have permissions to access the data connection file that is used in the workbook or the file does not exist

I am using Excel in SharePoint 2010 with the data connection. When I do Ctrl+Refresh on the page, the excel sheet shows up with data. When I do just refresh, it gives me the error: You do not ...
1
vote
1answer
3k views

Convert the Infopath Form into PDF or Excel in SharePoint 2010?

We have designed an Infopath Form and published as a document template on a library. Now, we would like to add a feature to export the InfoPath Form details to Excel or publish the InfoPath Form as ...
0
votes
0answers
12 views

Limit the Excel Service

I've two question about Excel Service on SharePoint: I would like to disable the field list panel for Pivot Table in the Excel I'd like to disable the Download option except for the Download as a ...
1
vote
1answer
147 views

Can not refresh external data in Excel file which connected to Postgres via PowerQuery in Excel Web App

We have an Excel file which is connected to a postgres database via PowerQuery. PowerQuery needs npgsql provider for it. When I open file locally on my computer and try to update data - everything is ...
0
votes
0answers
14 views

Error “Reload to get the latest version of the workbook” while filtering Excel Web Access WebParts using SharePoint List WebPart

I have a Dashboard designed from Excel Charts. Excel has slicers for filtering the charts. Steps I used to create Dashboard- Using Excel Web Access Web Part I have added a Named Item(Chart). Added ...
0
votes
0answers
19 views

What is Powerpivot configuration Tool?

I am working on sharepoint 2013 powerpivot. When I ran, "Add-SPSolution –LiteralPath 'C:\Program Files\Microsoft SQL Server\110\Tools\PowerPivotTools\ConfigurationTool\Resources\PowerPivotFarm.wsp'"....