Showing posts with label Error while opening excel files after upgrade your SharePoint site to 2010. Show all posts
Showing posts with label Error while opening excel files after upgrade your SharePoint site to 2010. Show all posts

21 April, 2013

Error while opening excel files after upgrade your SharePoint site to 2010

Error Message: The workbook cannot be opened because it is not stored in an 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 Client application.

Steps: 

-Open your document Library

-Click on "Library" under "Library tools" (See screenshot)
 

-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.
 

Applies to: SharePoint Foundation 2010/SharePoint Server 2010.