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
261 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
179 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
321 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
123 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
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
0answers
45 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
70 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
157 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
68 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
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 ...
1
vote
2answers
162 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
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 ...
1
vote
1answer
2k views

Power Pivot and Power View do not work for Excel workbook with external connection

I have SharePoint 2013 with Power Pivot and Power View. It's based on SQL Server 2012. They seem to be configured properly as they work fine with Excel 2010 workbook that contains tabular model that ...
1
vote
1answer
131 views

SharePoint 2010 Multi Tenant - I need Excel Services

We are running SP in Multi-Tenant mode for a few small clients. I need Excel services enabled for two of the tenants. What options do I have and how do I do it? I have been looking at documentation ...
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
1answer
822 views

How to use excel services REST api in Sharepoint Hosted App

I need to call excel service rest api as follows on the 'Summary' library in hostweb ...
1
vote
1answer
352 views

Since last patch, unable to open excel documents and word documents can only be opened by dropdown

We performed updates to the SharePoint Portal, SharePoint Foundation, Office Sharepoint Server, Excel Services Component, and Word Server on 03/16/2014. Since then, we are unable to open Excel ...
1
vote
0answers
461 views

Issue with Office Web Apps - can't open Excel file, prompt for user name and password

I can't open by Office Web Apps Excel file, SharePoint always prompt for user name and password and after entering correct user name and password it happens again and get error: "An error has ...
1
vote
0answers
181 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
77 views

Excel Services permissions error

I have created a document library, and gotten that library added to the Excel Services Trusted Locations in central admin. I’m using an account which has full control on the document library to ...
1
vote
0answers
276 views

Hyperlink to force Excel to open in Excel Services

We have found that a link, like the following, pasted into an Outlook email will always open the target file in the users local copy of Excel: <http://ourspbi/myreports/Some Excel report ...
1
vote
0answers
722 views

Problem connecting Sharepoint 2010 to SSAS through a RSDS

As the title says, I'm trying to create a Report Data Source on Sharepoint 2010 where I have an SQL2012 instance with the PowerPivot, SSRS and the sharepoint add-in configured. I choose "Microsoft ...
1
vote
0answers
28 views

Make First Sheet Display in Excel of Sharepoint in Browser

I have a Excel Web part and make an excel appear in browser throught this web part. There is 4 sheets in excel but when I open the page , firstly the third sheet appears but not he first sheet. How ...
1
vote
1answer
327 views

Is it possible to read an excel file through code in a sandbox solution - SharePoint Online

On a SharePoint Online environment, I have an Infopath based list with Attachment enabled. When an excel file is attached during a new item creation on this list, I want to have an event receiver that ...
1
vote
0answers
2k views

Export Excel Table to Sharepoint List throwing publishing error?

I have a SP Foundation 2010 installation on windows 7. I created a OOTB Contacts list in SharePoint and tried exporting an excel (Office 365) table with various fields to this list. Note: The column ...
1
vote
1answer
961 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 ...
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
0answers
494 views

SP2103 Excel-Services Freeze Panes / Headers

Do anyone know a simple solution to freezing the headers in an Excel file that is published on a SharePoint 2013 portal.
1
vote
0answers
372 views

Enable Publishing Options button without SharePoint Designer

We use MS Office 2010 Standard, and some users will be publishing spreadsheets from Excel to SharePoint (2010). We have discovered, however, that the Publishing Options button only appears in the Send ...
1
vote
2answers
1k views

Excel Web Access Web Part won't display workbook

We've recently upgraded from SharePoint 2007 to 2010 and we are trying to get the Excel Web Access web part to work. Excel Services is running if that's required, the workbook location is configured ...
1
vote
0answers
271 views

Adding Excel Reports / TFS Web Part to My Site

I'm using Sharepoint 2013 and would like to add some Excel Reports to "My Site" but I don't know where to begin. Excel Services have been configured correctly since we also have the team foundation ...
1
vote
1answer
990 views

Powerpivot data refresh over kerberos delegation

I have a SQL 2008 R2 OLAP Cube and an Excel file that uses powerpivot and embedded datasource to the Cube. I want to upload the Excel file in SharePoint and allow users who are authenticated to the ...
1
vote
1answer
329 views

issue with Excel Services in SP2010

I have created a Excel and enabled the connection to external sQL database through Secure store service and created the odc file . When i open the excel in sharepoint it refreshes the data and it is ...
1
vote
1answer
53 views

Excel Services User Defined Function returns #NAME?

I've followed all the steps as described in numerous blog posts, including the MSDN Walkthrough, on setting up User Defined Functions in Excel Services. However, I'm still getting "#NAME?" in the ...
1
vote
0answers
61 views

Missing rows in PerformancePoint Dashboard chart compared to Excel Services

Excel which is published has more than 75 rows but in dashboard there are only 75 rows for the report.Are there any parameters are set for this in dashboard designer or any other changes are required. ...
1
vote
0answers
60 views

Fact tables indicators selectors/filters in an excel report with pivot tables

I'm working in a project where I need to publish some reports based on excel pivot tables against SSAS cube. Until here everything is OK. However, I want to know how I can set in my excel report a ...
1
vote
1answer
529 views

Unable to use filter or edit Excel Worksheet while opening from Excel web access?

I am able to view and filter data based off excel fileters via the Excel Web Access web part for Excel workbooks. However, when I "open in Excel" it does not allow me to filter or edit. Note: I ...
1
vote
1answer
545 views

Scaling Excel Service Application - SharePoint 2010

Today I was preparing a new production server farm for SharePoint 2010 when I encountered this fact that there are not many in depth articles/whitepapers on the net that deals explicitly with Excel ...
1
vote
0answers
273 views

Value error in UDF with Excel Services

I've written some C# User Defined Functions for Excel that I'm trying to run in Excel Services. One of these UDFs is working in my local environment, but failing in the QA environment. Instead of ...
1
vote
0answers
512 views

Customize toolbar in xlviewer.aspx

We would like to replace the "Open in Excel" button with the "Download a snapshot" command in the xlviewer.aspx file. Is this something you can configure when using this file to view documents? I ...
1
vote
0answers
45 views

How to add EWA parts with the non-enterprise version

Is it possible to add a Excel Web Access part to a dashboard in the non-enterprise version? If not, is there another way to simulate such a dashboard?
1
vote
0answers
64 views

Can Formulas Automatically Update in Excel Services 2007?

I currently have two spreadsheets housed in Excel Services in a Sharepoint Hub. These two spreadsheets are linked. However, the values on my main spreadsheet will only update 1. if the source ...
1
vote
1answer
219 views

Why am I getting a ServerContext.Current error using Excel Web Services? [closed]

We are trying to setup Excel Web Services in SharePoint 2007 and for some reason all accounts are getting an error. When I check the event logs, I see the following error: ...
1
vote
2answers
926 views

Excel Services, Save As does not show Publish Options

I have created a document library and configure it to have a Document Template Excel Spreadsheet. When I create a new Document and then save the new Excel worksheet, by selecting File -> Save&Send ...
0
votes
2answers
336 views

Hard limit to have number of Excel webparts on SharePoint 2010 page?

Is there any hard limit to have number of Excel webparts on the SharePoint 2010 page?
0
votes
6answers
662 views

Test drive of PerformancePoint and SSRS on SharePoint

I need to build advanced reports on SharePoint, where radars, pivots and cumulative values are involved. One obvious option is Excel Services, but I'd be interested to compare it with PerformancePoint ...
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 ...
0
votes
1answer
88 views

What is the purpose of User-Defined Functions under Excel Service Application?

I have done a lot of research and have concluded that we cannot use VBA present under Excel sheet code in SharePoint. Today I was reading on excel services in sharepoint. I came across User-defined ...