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
25 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
268 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
1answer
680 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
296 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
295 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
679 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
215 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
836 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
2k views

Unable to refresh data for a data connection in the workbook.

I am trying to use an Excel Web Part that connects to a list in Sharepoint 2010. On my local drive the spreadsheet updates when I open it and all is well but when I uploaded to sharepoint the data ...
1
vote
1answer
282 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
50 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
60 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
58 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
418 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
468 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
254 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
478 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
43 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
62 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
216 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
821 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
294 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
621 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
502 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
64 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 ...
0
votes
1answer
92 views

Is it possible to specify content database name while creating the Excel Service Application using powershell script?

I want to create the Excel Service Application as it is required to use the Excel Web Access Web Part. Firs I tried to create the application using sharepoint but GUI not providing facility to specify ...
0
votes
1answer
93 views

Versioning in Excel web app

Does anyone know how it's possible to create major and minor versions in the excel web app? When a document is saved, I see that it changes the minor version, but what do I need to do to create a new ...
0
votes
2answers
3k views

SharePoint 2010 TfsOlapReport Excel Services throw OLEDBConnection error

I'm trying to fix the "failed to refresh: TfsOlapReport" error on the TFS project portal dashboards in SharePoint 2010. I've followed the instructions here to make sure the Secure Store Service and ...
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?
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 ...
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
2answers
1k 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
731 views

Reading excel cell value in Excel Web Access Webpart

I need to read excel cell value.Excel web access webpart is used to display excel file stored in a SharePoint 2013 document library.I need to use Jquery to read the data of excel file currently ...
0
votes
2answers
1k views

Excel web services cannot open in browser

I have an odd issue where as some Excel files once clicked give me the option to open or edit and then some others when clicked launch directly into Excel Services within my browser. There appears to ...
0
votes
1answer
2k views

SharePoint 2013 - Excel Web Access - Can't Contact the server

I have a BI site configured with Excel and Reporting services and all the other required services. I have extended this site and all is fine when I use farm account accessing the site through ...
0
votes
1answer
71 views

Setting to enforce use of Excel Services rather than Excel Web App

Our site and sub-sites are defaulting to Excel Web App rather than Excel Services. We require Excel Services. I think maybe I hit a setting somewhere at the root which has caused this change. Where ...
0
votes
1answer
62 views

What is the purpose of Allow External Data Under Excel Service Application --> External Data?

We have a excel book that we can open via excel web part on sharepoint page. The excel book has external data connection to SQL Analysis server. Presently the setting for Allow External Data is set ...
0
votes
1answer
168 views

How to programatically modify contents of an excel sheet via excel web services in SharePoint 2013?

I have read that, While users can interact with Excel workbooks in a browser through Excel Services, the workbooks cannot be edited in the browser by using Excel Services. Programmatic options are ...
0
votes
2answers
2k views

Import File from SharePoint and Link this file with SharePoint (File- Excel File)

I am using SharePoint 2013 and Microsoft Office 2007 or above. Scenario: I upload a Excel file to a SharePoint 2013 list. Now, I want to import this Excel file from this SharePoint list back to ...
0
votes
1answer
318 views

Power View Report in Excel dont work in Share Point 2013 web site

I use Share Point 2013 and SQL Server 2008 R2 and Performance Point Service and I use Excel Service for show Excel Report in SharePoint 2013 web site. My SharePoint web site work and I can view Excel ...
0
votes
1answer
2k views

Access was denied by the external data source. The following connections failed to refresh: “data connection name”

I created a 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 ...
0
votes
1answer
447 views

Excel Services - Disable Refresh warning

I'm trying to figure out how to disable the refresh warning used within Excel Services. Everytime I load my page I get the following: My first port of call was to check the trusted file location ...
0
votes
1answer
3k views

Excel services and PowerPivot error: “Unable to refresh data for a data connection in the Workbook. ”

My environment is a 3-tier SharePoint 2010 Architecture: Running on SQL Server 2012 Enterprise Edition WF1 WF2 Both Web Fronts are NLB, and we have they following Application Servers APP1 - ...
0
votes
1answer
202 views

Implementation of power view in sp 2013 - Pain Points and Ideas

Can anybody please give me some painpoints of using PowerView in sharepoint 2013. Recently in our project we are planning to upgrade our site from SP2010 to 2013. In SP2010 site we have lots of ...
0
votes
1answer
39 views

Regarding excel service in sharepoint 2010

We planning to purchase Sharepoint 2010 standard version. I notice SharePoint 2010 standard version does not support Excel service. My question is, am still able to load the excel document in ...
0
votes
1answer
234 views

Are Sparklines Viewable via excel services and Business Intelligence?

I have an excel report with SparkLines in it. When I view the file through excel services (aka in the browser), all looks fine and dandy. But when I try to browse the file via REST services, the ...
0
votes
1answer
149 views

Excel Calculation Services - Excel Web Apps

We're trying to co-author excel workbooks but only have Standard CAL/Sharepoint 2010 Standard Server license. Its my research so far that to have co-authoring for Excel, we would need to use Excel ...
0
votes
1answer
265 views

Create new Worbook with Excel Services

I want to generate an Excel File with SharePoint. I can make a refernce to ExcelServices an want to use the funtion NewWorkbook. But i get the error : Soap Exception: You do not have appropriate ...
0
votes
1answer
1k views

Tracking Changes to Individual Cell in Excel Spreadsheet on SharePoint?

I've gotten a weird request today, someone I work with asked if there is any way to track changes to a specific cell in an Excel Spreadsheet. The spreadsheet is hosted on SharePoint and they want to ...