The workbook cannot be opened because it is not stored in excel services SharePoint 2010

InfoPath alternatives for form designing SharePoint

In this SharePoint 2010 tutorial, we will discuss an error message which usually comes after you upgrade my SharePoint a site to SharePoint 2010 site. The error message comes as “The workbook cannot be opened because it is not stored in excel services.”

Error Message:
The workbook cannot be opened because it is not stored in excel services.

Cause:
By default, the setting in the library is set to “open the file in browser”.

Resolution:
Change the Library settings to open files in the Client application.

Steps:

  • Open your Document Library
  • Click on “Library” under “Library tools” (See screenshot)




The workbook cannot be opened because it is not stored in excel services
The workbook cannot be opened because it is not stored in excel services
  • To the extreme right on the ribbon, please click on “Library settings”.
  • Click on Advanced settings under General settings.
  • In the settings for “Opening Documents in the Browser”
  • Change the radio button and select Open in the client application.
  • Click OK

You must change this setting in all the document libraries.


Read some SharePoint tutorials:

Applies to: SharePoint Foundation 2010/SharePoint Server 2010.


You May Also like the Following SharePoint Online Tutorials:

Leave a Reply