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

0
votes
0answers
18 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
3k 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
15 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
20 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 ...
0
votes
1answer
26 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
7 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 ...
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 ...
1
vote
1answer
963 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
0answers
25 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 - ...
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 ...
0
votes
0answers
265 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
26 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
52 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
28 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
17 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
16 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
707 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
7k 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
1
vote
1answer
1k 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
22 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
27 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
223 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
2k 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
44 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 ...
3
votes
0answers
17 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
66 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
98 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
40 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
10 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
102 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
9 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
16 views

What is Powerpivot configuration Tool?

I am working on sharepoint 2013 powerpivot. When I ran, "Add-SPSolution –LiteralPath 'C:\Program Files\Microsoft SQL ...
1
vote
1answer
46 views

Can I access office.js from SharePoint 2013 content-editor web-part like I can Ewa?

I have HTML and JavaScript that run just fine in a SharePoint 2013 content-editor web-part, from which I can access the Ewa.EwaControl object ...
1
vote
0answers
20 views

How to get an Excel table's Summary property from JavaScript on the client side using the Ewa namespace

Background: The value of the Summary property corresponds to the setting of the Description box in the Alternative Text dialog box, which is displayed by right-clicking on an Excel table and then ...
1
vote
0answers
23 views

How can I have end-users visualizing different dimensions from the same Powerpivot on same excel file?

I need help to understand if it is possible to have end-users visualizing different dimensions from the same excel file published in Sharepoint 2013. I have a data warehouse in SQL Server 2012 and ...
0
votes
2answers
3k views

Excel Services data refresh does not return updated data from data source

I have an Excel include some data which from a SharePoint list. This excel is created by using "Export to Excel" button of the SharePoint list form. I created a pivot table in the excel based on the ...
7
votes
1answer
251 views

SharePoint Online List limitations

Is it just me or is it really strange that SSRS 2012 still does not support Claims based authentication or OData connections? Anybody know of plans? Reasons for such a hole in the strategy? Part of a ...
1
vote
0answers
53 views

Excel Ewa JavaScript - Embed Workbook Stored in Document Library

I am trying to dynamically embed a workbook into a publishing page on my SharePoint 2013 on-prem site using Excel Services ECMA Script. I am trying to use the Ewa.EwaControl.loadEwaAsync method, but ...
1
vote
1answer
20 views

Doing calculations in Excel Online with user permission “View Only”

I want to share Excel files in a SharePoint library. The users shall only be able to open the files in "Excel Online", but not to download them or the open them offline. Also the original file ...
0
votes
2answers
325 views

Create new Workbook using Excel Services

I want to generate an Excel File using SharePoint. I can make a reference to ExcelServices and want to use the function NewWorkbook. But I am getting the error which say Soap Exception: You do not ...
0
votes
0answers
17 views

SharePoint With PowerPivot Filters Missing

I upgraded existing Excel2010 spread sheet to excel2013 as part of SharePoint upgrade from sp2010 to sp2013. Everthing works fine but i dont see any filters being populated on sharepoint excel ...
1
vote
1answer
70 views

Can download a copy even with View Only permissions

We have a weird bug in which Excel Services allows users with View Only permissions to download files even without permissions to do so: At first, you might think that this is a problem with ...
1
vote
5answers
24k 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
0answers
70 views

Excel Mobile Viewer Feature removal troubles in 2013 upgrade

I am in the process of upgrading from SharePoint Server 2007 to Server 2013, and Excel Web Services is throwing a spanner in the gears. I have 3 environments: SharePoint 2007 (SQL 2005) in ...
0
votes
0answers
23 views

Scroll bar not appearing in Excel webpart

I created one excel view with named item and inserted one custom scroll bar. but when i add the same excel report in excel webpart, scroll bar doesn't appear. any idea on this?
0
votes
1answer
41 views

Error viewing Excel sheets on mobile

I'm using SharePoint 2013, whenever I try to view an Excel file embedded in a SharePoint page through my mobile it gives me this message We can't start Excel mobile viewer because it may be ...