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
1answer
13 views

Data Connection does not refresh in Excel

I have a SharePoint list; Exported into Excel file and set the property to refresh Data Connection every time the file is opened. It worked very well in Excel installed on my system but when I ...
0
votes
1answer
33 views

the table contains a string that is too long for excel to display. if you edit the long value some data might be lost

I have a SharePoint document library. On exporting to excel I get an error message the table contains a string that is too long for excel to display. if you edit the long value some data might ...
1
vote
0answers
20 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
20 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 ...
0
votes
1answer
25 views

Pivot Table Source Data in Separate Excel Workbook stored on sharepoint

I have an excel spreadsheet on the sharepoint server with my Main Data that I want to analyze. I want to make a pivot table from this sheet that will update when the Main Data is updated, but I need ...
0
votes
1answer
42 views

Extract infopath xml data into excel

I have around 2000 InfoPath forms in SharePoint 2010 document library. I want to extract all forms in excel using macro. Any help?
1
vote
0answers
64 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
87 views

PowerPivot Data Refresh not Working After Adding Pivot Table

I have a spreadsheet with a powerpivot data model in sharepoint 2013 sp1 with sql 2012 sp2 for the power pivot instance. The power pivot data refresh works fine when scheduled, when the spreadsheet ...
1
vote
0answers
52 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
112 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 ...
0
votes
1answer
51 views

The documents on sharepoint will open in 'Read Only' mode even though i try to open in 'Edit' mode

The documents on share point will open in 'Read Only' mode even though i try to open in 'Edit' mode.
1
vote
2answers
100 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 ...
1
vote
1answer
62 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 ...
0
votes
1answer
100 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.
0
votes
1answer
13 views

SPO missing EWA in Business Data

Where trying to implement a EWA webpart to a teamsite, but we're missing EWA among other webparts available in the Business Data folder (see pic below)? E3 license - check! SharePoint Server ...
0
votes
0answers
20 views

Prevent “We're opening your workbook in Microsof Excel” message from being displayed

I have multiple environments with SharePoint solutions installed on them. Almost all of them are working fine except one that has an issue and don't know how to solve it. Each time I open an Excel ...
0
votes
0answers
25 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 ...
0
votes
1answer
32 views

Sharepoint Excel files Capacity Planning

I have requirement to upload 30K records every year in document library and further attach workflow and do some stuff based on business criteria. I need to plan for capacity in SharePoint, so I need ...
-1
votes
1answer
784 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
0
votes
0answers
39 views

Can we get Excel Pivot chart as an image in SharePoint 2013

I have a workbook which has a pivot chart and we are showing it in Excel services web part. Now my question is: Is it possible to access that chart (as an image) element? I know we can use REST api ...
0
votes
1answer
113 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
35 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
35 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 ...
0
votes
0answers
30 views

Excel Web Access Content Visible to User Which are not exist in Excel Slicer (Used Current User Filter)

I have used Current User Filter in Excel Web Access Sharepoint 2013. I have used Excel 2013 Data imported from Database. If Current Login User not found in Slicer then Excel Web Access shows Error ...
0
votes
1answer
13 views

Offline doc linking to sharepoint doc (specifically excel)?

I searched for an answer to this and the various answers left me confused, so I figured I'd come here now since I always get a reliable answer from this forum. I have Office365 and I use Excel Online ...
0
votes
1answer
100 views

Excel Online/Sharepoint survey won't load

At work we use a survey created through Excel Online/Office 365 to track issues our employees have with software. It's worked splendidly until a day or two ago when the survey just takes you to the ...
0
votes
2answers
80 views

Customize xlviewer.aspx in SharePoint 2010?

We're using SharePoint 2010 and I have a requirement to hide the breadcrumb links at the top of the xlviewer.aspx page for Excel Services. I've found quite a bit of documentation on how to customize ...
0
votes
0answers
38 views

SharePoint 2010 & Excel Services & Errors

Good Evening All, I've been trying to configure automatic data refresh on excel spreadsheet that's hosted within an Excel web part. My spreadsheet pulls data from a SharePoint list into a pivot table ...
0
votes
0answers
22 views

Create Excel from SPListItemCollection and upload to a Document Library

Here is the scenario, I have a Timer Job. It sends Monthly summary of a list based on certain filters. I am able to generate Datatable from SPListItemCollection that I get using CAML. I would like to ...
2
votes
1answer
53 views

Excel Web App dropdown control issues

Happy New Year everyone, I am having some strange issues with our on-prem SharePoint 2013 environment. When a user opens an excel document in Excel Web App in IE, the dropdown controls (edit ...
1
vote
0answers
97 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
39 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 ...
0
votes
0answers
74 views

SharePoint 2013 Excel WebPart

I created new excel webpart. I got this error : The trial period for SharePoint Server has expired. I researched on net and i found this solve : Run--> inetmgr-->Application Pools--> ...
1
vote
0answers
366 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 browser I got error We don't know what happened, but something went wrong. When I try to edit file is ok? In event log I get: There was an error in communicating with ...
1
vote
1answer
420 views

How to connect an Excel file to a Data Connection Library?

In the article here, it states that an excel file can connect to a .odc file inside a DCL. I've researched for a bit and finally stumbled upon a solution that involves having to modify registry ...
0
votes
0answers
20 views

Data Provider for SQL Server Analysis 2014 - SharePoint 2013

Which data provider or requriments are needed to connect Excel Services workbook to external data SQL Server Analysis 2014? I'm not able to refersh data?
0
votes
0answers
175 views

Restore Errors on Sharepoint

I got up backup a server. And I want to restore the backup to nother server. But I got this error and my restore job is failed. Object Excel Service Application failed in event OnRestore. For ...
2
votes
1answer
714 views

External Data Refresh failed - Unable to refresh list data in Excel Web Access WebPart

I have created a PivotChart in Excel workbook that fetches data from a SharePoint list using "OData Data Feed". When refreshing the connection in Excel 2013, the updated data is displayed in ...
2
votes
1answer
715 views

“Open in Visio ” & “Open in Excel” is not working, and I will get an error message

I have the following inside my SharePoint server 2013 :- EnterPrise Wiki site collection. i have both "Excel services Application "& "Visio Graphics Service" running correctly. The problem i ...
0
votes
0answers
14 views

Cannot Refresh Excel in one Web Application with Kerberos and without

After moved web application from test farm to production, excel file with connection to OLAP db cannot refresh. The excel servcie account has permissions in db. In the same web app is performancepoint ...
0
votes
0answers
84 views

Licence error after installing Office Web Apps and suppressing XLXS and XLSM

I get the following error: In german: 'Application error when access /_layouts/15/xlviewer.aspx, Error=Leider wurde Ihre Lizenz zum Verwenden dieses Features nicht gefunden. Wenn Sie wissen, wer die ...
0
votes
1answer
36 views

I need help - some excel docs not opening in sharepoint

Many excel files in our libraries are no longer able to be opened. They can be downloaded via the drop down menu, but will not open with a click as they should be. The pop-up message we get is; ...
1
vote
1answer
123 views

Toolbar and Title Bar not present in Excel access webpart

I have added Excel access webpart to a page in SharePoint. When I click on edit webpart properties, I can't see all the properties which I should see by default. Any idea why? I can just see ...
0
votes
1answer
30 views

Overlay in Excel Services Chart

I have a chart in an Excel document that I am displaying on a Web Part page. In Excel, I was able to draw a text box and overlay a percentage. However, these types of objects are not supported by ...
0
votes
0answers
92 views

In an Excel file. The data connection uses Windows Authentication and user credentials could not be delegated

I have an Excel Spreadsheet with a connection to a Sql Server table. The connection uses my domain account. If I try to update the connection I get this message: The data connection uses Windows ...
2
votes
2answers
291 views

Cross domain issues accessing Excel Services in a Sharepoint App

I have an Sharepoint app hosted at: https://app-xxxxxxxx.sharepoint.com/sites/my-site/ And I want to retrieve the json representation of an excel document using the Excel Service Rest API hosted ...
1
vote
2answers
114 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
29 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 ...
1
vote
1answer
370 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 ...
4
votes
0answers
121 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 ...