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
320 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
494 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
59 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
33 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
224 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
182 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
278 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
1answer
1k 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
192 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
346 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
362 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
506 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
129 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
472 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
18 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 ...
1
vote
0answers
59 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
60 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 ...
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
0
votes
1answer
363 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
48 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
75 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
1answer
15 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
431 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
224 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 ...
2
votes
1answer
228 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 workbook,...
1
vote
0answers
171 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
74 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
138 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
1k 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 ...
3
votes
1answer
2k 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
371 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
1k 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
1k 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
1answer
41 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
315 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
36 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 ...
2
votes
2answers
482 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 at:...
1
vote
2answers
171 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
39 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
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 ...
7
votes
1answer
264 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 ...
0
votes
1answer
153 views

How to exctract filtered items from SharePoint List to Excel

I'm using Javascript and AngularJS to get all data from a SharePoint list in JSON and displayed it into a table. User can sort it, filtered it and etc. There is a really nice paggination. Everything ...
0
votes
2answers
3k views

SharePoint 2010 - Excel Web App error “An error has occurred. Please try again.”

On one of SharePoint sites on our server. While opening few .xlsx files users(including me) are getting the error "An error has occurred. Please try again.". When the user click's on any of these ...
0
votes
1answer
331 views

Move BI Center (Excel, PerformancePoint, PowerPivot) to other SQL server - SharePoint 2013

What way would be the best to move BI Center to other SQL server in SharePoint 2013? Thanks,
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
101 views

Excel data doesn't appear, in the Excel Web Access

I've added an Excel Web part into my page. I did check out this excel workbook. But, when I want to run my page , I'm getting as follows error. Also,when I want to open xslx file in my desktop, the ...
0
votes
1answer
45 views

How to add new service application with Central Adminstration

I want to excel document into my webpart in sharepoint 2013. First, I added a webpart in my page as follows. Then I clicked "Click here to open the tool pane." and I added workbook URL and OK. But ...
0
votes
2answers
1k views

Excel Services REST API returns 401 Unauthorized in Workflow

I am trying to make a call to the Excel Services REST API in a workflow to retrieve information on a workbook's charts. The URL format is siteurl/_vti_bin/ExcelRest.aspx/Workbooks/Chart%20Test.xlsx/...
0
votes
0answers
110 views

Update Excel document without checking in and checking out

Suppose we upload a shared Excel document in the SharePoint 2013. If we try to edit it allows to edit for a windows user and allows to save it. If then another windows user tries to edit the same ...
0
votes
0answers
57 views

Excel Web access webpart url

I am following an Article to solve a "The Workbook cannot be opened" that appears on my webpart when I load the document. It mentions getting the url of the webpart, in order to complete a powershell ...