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.

104 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
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 ...
4
votes
0answers
910 views

Excel Web Access web part real time update

I have the following scenario and would very much appreciate any advice: I exported a list /System/Examples to Excel and then saved it as Testing.xlsx to a different document library: /System/...
3
votes
0answers
33 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 ...
3
votes
0answers
513 views

Excel Services: Configuring Data Refresh for an External Workbook Data Source

Honestly, configuring this has been such a hard experience. I encountered many errors already, one after another but am stuck now. To illustrate what I've come across so far, I've had problems with ...
3
votes
0answers
106 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 ...
3
votes
1answer
6k 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 ...
2
votes
0answers
151 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 ...
2
votes
0answers
35 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
0answers
72 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 ...
2
votes
0answers
90 views

Why does the Manage PowerPivot Data Refresh page show a data source that is not in the workbook being configured?

I have several Excel workbooks hosted on an on-premises SharePoint installation that are refreshed each day. Each workbook accesses one of our Analysis Services cubes via Excel Services. When I went ...
2
votes
0answers
380 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 ...
2
votes
0answers
173 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://&...
2
votes
2answers
5k 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 ...
2
votes
0answers
344 views

Excel and PowerPoint to talk via SharePoint Libraries

We are looking into a way for an Excel file and PowerPoint file to exchange data. I'm thinking Excel Web Services, OpenXML, SharePoint Office Apps and/or maybe CSOM. Requirement is coming up to: ...
2
votes
0answers
97 views

SharePoint Onine List as Datasource to Excel Services / Business Intelligence in SPO

Trying to join 2 SharePoint Custom Lists sources into an excel Services Graph. If so, any BI option for formating list data on an SPO page? Possible now under SPO 2013 A3 license? Confused about ...
2
votes
0answers
162 views

Can I access excel file from a remote sharepoint server in my Excel Web Access web part?

We are developing an organization level dashboard in which we are using Excel Web Access web part to display part of or entire excel workbooks containing charts. Problem is, the corresponding actual ...
1
vote
1answer
42 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
478 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
0answers
656 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 ...
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
23 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. ...
1
vote
0answers
120 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
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
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 ...
1
vote
1answer
788 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 ...
1
vote
0answers
154 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 If ...
1
vote
1answer
172 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 (https://msdn.microsoft.com/en-us/library/office/ee589018....
1
vote
0answers
52 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
42 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 I ...
1
vote
0answers
206 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 ...
1
vote
0answers
479 views

Power Query Data Refersh

I used power query in the MS Excel to import data from SharePoint online List, and create a dashboard by using the data of that list. Everything work perfectly when I used that excel on my desktop, ...
1
vote
0answers
17 views

How to identify spreadsheets created in Web Apps?

We've hit the snag of not being able to use PowerView with Excel Web Apps: http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2014/08/06/power-view-sheets-not-...
1
vote
0answers
78 views

Updating Excel Connection using SharePoint Excel Services

I am developing a SharePoint Webpart, which asks user for basic information and SQL Connection. As user fills information and click's Generate Report button an excel report is generated which has "...
1
vote
0answers
63 views

SQL Error 18456 state 8 on SharePoint Excel Services

I installed SQL Analysis Services. I want to test it via Excel Services on SharePoint. I created new account with which I can easily login to SQL Server Management Studio: the username and password ...
1
vote
0answers
98 views

Excel Services In External Website

I'd like to render an excel workbook (specifically a pivot table) using Excel Services on our department's internal website and I am not sure how to do it (and I guess I am not searching correctly on ...
1
vote
0answers
44 views

Is it necessary to configure Excel service application and secure store to view excel reports in SharePoint?

We are using SharePoint 2013. Now we need to add some excel sheets and excel reports onto the SharePoint page. So we have seen that there is a Excel viewer webpart. I was wondering whether it is ...
1
vote
0answers
890 views

Issue with opening files in Excel Web App SharePoint 2013

I am receiving the below message while trying to open an excel file in a document library in SharePoint 2013. "We're sorry. We can't open the workbook in the browser because it uses these unsupported ...
1
vote
0answers
734 views

Can't edit Excel documents in SharePoint 2010 using the webapp - but it is fine using the Excel Client Application

I have a SharePoint site where I can edit excel documents using both the SharePoint web app and the excel application installed on my PC. However, in a new site, I can edit the same excel files using ...
1
vote
0answers
714 views

Unable to filter Excel web access web part

I have an excel web app with a pivot table that's data comes from a powerpivot SQL data source. I am trying to filter this data via basic 'choice web part'. when applying the filter i get an error ...
1
vote
1answer
510 views

Sharepoint Excel Dynamic dashboard according to a list

I've a list which has something like this: List Title Status Title 1 Active Title 2 Pending Title 3 Active Title 4 Closed I need an Excel BI dashboard which should be dynamically ...
1
vote
0answers
152 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
2k 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, ...
1
vote
0answers
54 views

Open In Excel Issue

I have two sites on SharePoint2013. I used excel webpart. I worked these sites in IE 11. "Open In Excel" works a site, but doesn't work other site. What is the cause of this problem?
1
vote
0answers
149 views

Workflow Tasks data in Pivot Chart

Has anybody ever tried to create a pivot chart in Excel based upon the workflow tasks list in SharePoint? One of my users is requesting a chart showing all users associated with active or completed ...
1
vote
0answers
330 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 ...
1
vote
0answers
139 views

Sending parameter to excel web access charts

I have some pivot charts displayed using excel web access, all of the charts have some filters, I would like to create a common filters to interact with excel web access charts. Is there a way I can ...
1
vote
2answers
293 views

Excel web service web part in sharepoint 2013 app

Is it possible to add Excel service web part in SharePoint 2013 app? My intention is to create dashboard with graphs and charts (from excel which was published) in the app. Please help me with any ...
1
vote
0answers
45 views

Excel Workbook webpart filtering display issue

Has any one experienced an issue with Excel workbook WepPart not displaying the filtering box and items? What it does look like: What it should look like: This is not displayed until I select ...