.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Excel Services XLSX shows different results when accessed via Sharepoint UX vs REST

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :SharePoint
I have an Excel services report that connects to Project Server 2010 data via an ODC.  Looks great when I view the XLSX through the browser via the Sharepoint doc library; everything refreshes, no warnings, all is good.    But when I access this same file via the Excel Services REST call: https://myserver/_vti_bin/ExcelRest.aspx/ProjectBICenter/My%20Reports/Initiative%20Status%20Report.xlsx/model/PivotTables('InitiativeStatusSummary')?$format=html I get an older version of the report -- not refreshed with the latest data.   I have the file set to "refresh data when opening the file" in the data connectioon properties.     What am I missing?

View Complete Post

More Related Resource Links

Using the Excel Services REST API to Access Excel Data in SharePoint Server 2010 (Visual How To)

Learn how to use the REST API to retrieve resources such as ranges, charts, tables, and PivotTables from workbooks stored on SharePoint Server 2010.

Video: Using the Excel Services REST API to Access Excel Data in SharePoint Server 2010 (Visual How

Watch a short video that shows how to programatically retrieve data from an Excel workbook.

SharePoint 2010: Excel Services Resource Center

Are you looking to learn about Excel Services programmability capabilities? Learn about Excel Web Services, UDFs, the Excel Web Access Web Part, REST, and ECMAScript support.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Developing Applications in SharePoint 2010 Using Word Automation Services and Excel Services

Learn about the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Sample: Developing Applications in SharePoint 2010 Using Word Automation Services and Excel Services

Download sample code that demonstrates the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Interacting with the Excel Web Services API for SharePoint Server 2007

Get a quick start with the Excel Web Services API, which enables interaction with published Excel 2007 workbooks in SharePoint Server 2007 from a remote application. Learn considerations around session state, security, and performance.

Video: Excel Services and SharePoint 2010 Business Intelligence

In this video you will learn how to create BI applications using Excel Services. (Length: 10:26)

sharepoint rest services

Hi, As per my knowledge , REST services are similar to SOAP services/protocol  but less head-ache. But why to use REST instead of SOAP in SharePoint 2010? Also I want what is a Mshup page in internet environment.   Thanks

SharePoint Excel Web Services - How do I adjust the Zoom Level

Hello, My Organization is using SharePoint 2010 and the Excel Web services module is installed.  The spreadsheet I am using loads perfectly on the page exept for one problem, the zoom level is at about 150% and I can't figure out how to zoom out.  Is there somebody out there that can please help me with this.  Thank you  

SharePoint Server 2010 - no Excel Services?

hello   I've installed sharepoint server and wanted to configure Excel Services ...   and I cannot find any Excel Services in Central Administration portal there is information that services are installed but there is no such option in Administration portal   what went wrong ?   regards  

Quick Note (Scenario): Using the Excel Services 2010 REST API

Learn to use the Excel Services REST API to access data and objects within a spreadsheet.

Creating a new library using SharePoint Data Services (REST)


How can I create a new library/list using sharepoint data services (SDS)? I'd also like to add items in the newly created library programmatically using SDS? Is this possible at all?

Excel Services Application - Trusted locations problem in SharePoint Office Excel Web App


Just deployed Office Web Apps to our SharePoint 2010 environment. This environment was upgraded from a fresh deployment of SharePoint 2007 SP2. Configured all of the Application Services per http://technet.microsoft.com/en-us/library/ff431687.aspx, but I cannot open an Excel workbook, receiving the error: "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location. To create an Excel Services Application trusted location, contact your system administrator."

Our farm has a single front end server and a single database server. The shared application pool is called SSP1_v14 (renamed during the upgrade from SSP1?). Our existing site had its visual style upgraded during the conversion. An in-place upgrade had been performed.

I went to Central Administration > Excel Services Application > Trusted File Locations and the default entry for address http://, Location Type: Microsoft SharePoint Foundation, Trust Children had already been created. Various blog posts on the internet indicate that this entry is all that's needed to setup a trusted location for all SharePoint sites, but it's not working here. I've tested Word document viewing with the Word Web App and that works fine.

Any ideas?

Sharepoint 2010 Excel Services Extranet Access


Hi to all,
I've an environment that includes 3 machines: the sp2010 frontend (W2K8 R2), the sp2010 backend (SQL2008 R2), the analysis services backend (SQL2008 R2).

I've successfully setup my environment with Kerberos constrained delegation and the entire thing works fine with both performancepoint and excel services (the requirement was to pass the user's domain identity to the analysis backend): thanks to the excellent SP2010 Kerberos Guide.

Now I've extended this portal to the Extranet zone, assigned it a new host header and upgraded my SPNs to include the new fqdn and also added it to the necessary accounts in Active Directory.

In the intranet environment everything is fine. I've published the Sharepoint site to the external network onto the ISA 2006 and setup the Kerberos constrained delegation from the isa computer account to the Sharepoint SPN.

So here is the point: I can correctly access the Sharepoint site from external with Kerberos authentication, performancepoint is fine but I cannot open excel workbooks from this zone, I already trusted both the file and the data connection locations with the external fqdn but still no luck. Even the sample workbook does not open. The error is "error while trying to execute the requested action. Retry".

Anyone has any hint on the possible causes?

Thanks in

Consume SharePoint List in Excel Services


I found some older questions regarding this but they are all listed in the Pre-SharePoint 2010 forums. I wanted to know if there is anything I can do to more easily pull data from a SharePoint List (more specifically a set of related lists) into Excel Services such that data refresh is handled as well.


I found a couple topics that used UDF as solutions to this problem, but I am not sure if they will handle data refresh. These solutions are discussed in: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/79f5c968-b68f-4d53-bfe0-d57258cfed6c and http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/16f9255d-cd06-4687-ab8e-68bd6210d0f8


I am hoping the 2010 version of Excel Services can handle this more simply, thanks!

Excel Services installation in Sharepoint 2010



I am using SharePoint 2010 Enterprise farm installation and want to publish an excel workbook to a sharepoint document library. On my SharePoint server, I currently do not have Excel Services installed as I am unable to create a new Excel Services service application (it does not show up in the New menu in Manage Service Applications inside Central Admin). Kindly let me know the procedure to correctly install Excel Services on my SharePoint Server.

Can anybody help me out ?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend