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.