.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 2010 Error - "The workbook cannot be opened."

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :SharePoint
I enabled Excel Services and added a Excel Web Access viewer to my page. It's just a simple spreadsheet (which incidentally works fine on my standalone development server) that displays the error "The workbook cannot be opened." when the page loads. The trusted file locations are set up appropriately. We are using Kerberos authentication. My event viewer showed this "Critical" event (ID: 3760): SQL Database 'Prod_WSS_Content' on SQL Server instance 'servername' not found. Additional error information from SQL Server is included below. Cannot open database "Prod_WSS_Content" requested by the login. The login failed. Login failed for user 'domain\user'. In other words, the service account that ECS was running under did not have permission to the content database. So I granted the user read permission on the database. Then I got the same error and this "Error" level event in the event viewer (ID: 5617): There is a compatibility range mismatch between the Web server and database "Prod_WSS_Content", and connections to the data have been blocked to due to this incompatibility. This can happen when a content database has not been upgraded to be within the compatibility range of the Web server, or if the database has been upgraded to a higher level than the web server. The Web server and the database must be upgraded to

View Complete Post

More Related Resource Links

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.

Sample: Business Connectivity Services Excel 2010 Add-In

Download a sample add-in that shows 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.

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)

Excel Services no refresh data & no error logs

Hi! I'm trying to publish an Excel workbook which loads data from SQL Server. The result is: no data loaded in the workbook and no error logged on Sharepoint logs. Notice that if I try to refresh the workbook in Office Excel all works fine! I try to set up Windows Authentication, None (to use unattended account) and with .odc file but with no result! The procedure I follow is: 1) create a new Excel file and create new data connection to the database (SQL Server 2008) 2) upload the file in the trusted file location 3) open the file in a web part and click on the "refresh all" button I used the same unattended account which I setup for this purpose with BCS and it works fine! I also try to set with PowerShell the Application ID created ("ES"): "set-spexcelserviceapplication -identity 6d871d92-19dd-4421-b33b-0012f9a5ea18 -unattendedaccountapplicationid ES" with no result. I noticed that the identity of the Excel Service application shown in the Central Administration isn't in the IIS Application Pool list: could it be the problem? I also tried to delete / re-create the application but the two IDs remains disequal! Have someone of you already worked with Excel Services and could give me any help? Thanx in advance, Elena

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  

SharePoint 2010 Reporting Services Integrated-mode Error

I am running SharePoint 2010 and Reporting Services 2008 R2 SharePoint integrated-mode. I am able to browse to the reportserver site : http://DBserver/reportserver which lists my site collections and I am able to get to the document library which holds my reports. However, when I try opening a report I get the following error: Report Server has encountered a SharePoint error. (rsSharePointError) The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again. For more information about this error navigate to the report server on the local server machine, or enable remote errors I am able to resolve that issue by going to Central Admin, Application Management, General Settings and turning Web Page Security Validation Off. But if I do that I get an error when using silverlight features like site, or list creation. Any ideas?

XML for Analysis Parser; The restriction value - sql server 2005 with Excel 2010 error


Trying to refresh an existing pivot table that is connected to Analysis Services Sql Server 2005 database.  My excel 2010  gets the eroor:\

XML for Analysis parser:  The restriction value provided by the consumer either does not match other restrictions or refers to an unknown object.

I already tried the pivot table patch and I am still experiencing the error.  I also tried starting a new excel spreadshsst and connecting to two other sql servers of newer verions and was succesful.

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.

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

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 ?

Cannot refresh OLAP-based data in Excel Services workbook in browser (SP 2010 / Project Server 2010)



In SharePoint 2010, Project Server 2010, Business Intelligence Center, upon attempting to refresh OLAP data in an Excel chart in the browser, the following error appears:

An error occurred during an attempt to establish a connection to the external data source.  The following connections failed to refresh:

My ODC Connection Name

We have loaded and configured Project Server 2010 according to spec (http://technet.microsoft.com/en-us/library/ee662109.aspx).  Excel Services is configured according to spec (global settings, trusted file locations, trusted data providers and trusted data connection libraries).  The Secure Store Service is configured with the ProjectServerApplication target application. 

Non-OLAP data refreshes of spreadsheet data work fine in the browser.  OLAP data refreshes in the Excel client itself work fine.  Only the OLAP refreshes in the browser fail.  The problem occurs whether using a Microsoft ODC or one that we created (saved in a trusted location).

The ULS log has only one error, which is:

06/21/2010 13:47:17.86  w3wp.exe (0x1238)               &

Cannot open file with Excel Services 2010


When opening any of the Excel files in document library (new or old)  in the browser, following error is displayed:

The file that you selected could not be found. Check the spelling of the file name and verify that the location is correct. 
Make sure that the file has not been renamed, moved, or deleted.

In the ULS log I think this is the relevant error:

GetSPFile: Sharepoint threw a handled exception - turning it into a FileOpen exception. Exception is: System.IO.FileNotFoundException: cannot construct SPUserToken associated with contextLocationUri location ---> System.ArgumentException: Value does not fall within the expected range.



SharePoint2010 64 bit
Sql Server2008 64 bit enterprise
Office 2010 RTM

All clients and server are running Windows Server 2008 R2 64 bit.


- opening the file with Excel works fine
- tested from all machines within domain
- below is a relevant part of the ULS logging of Excel services
- looked in the event log of SharePoint machine

Resources I have been reading:


Sharepoint 2010 w/ Webapps, Excel Services Webpart display issue.


I have Sharepoint 2010 installed with WebApps 2010, and can use it to edit documents in IE without any problems at all.  Word and Excel work just fine.

But on MOSS 2007, I could have it display the Excel page as a webpart, that you can click on, and open it anyways.   But no matter what I try in 2010, all I get is the Webpart heading has a link to the file that works, but the contents always reads:

To display a workbook in this Web Part, you must first select the workbook.

To select a workbook, open the tool pane, and then edit the Workbook property.
Click here to open the tool pane.


How can I fix the preview in the webpart?




Creating an Excel Services and Bing Maps Mashup for SharePoint 2010 (Visual How To)

Learn how to use a Bing Maps AJAX control to interact with an Excel Web Access Web Part using the Excel ServicesECMAScript object model.
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