Tips on how to fix 'Workbook which you selected cannot be opened' error [article from Articleranks]

Tips on how to fix 'Workbook which you selected cannot be opened' error

Excel services work with Excel 2007 and allows you to share, load, calculate Excel workbooks on Microsoft SharePoint Server 2007 portals and dashboards. You can share an entire ccie Workbook or just few parts of it like charts, tables etc. By working with a Web browser, end users can view and interact using the workbooks. Even so, at times, after you publish a ccie lab workbook to Excel Services and attempt to load it in a browser, you might run into an error message. Such situations erupt after you attempt to load a corrupt ccie exam workbook. You can use a healthy backup copy of the Excel file and upload it once more to the server. Even so, in case you can not access a backup copy or if it really is not an updated one, then you have to think about working with an Excel repair software.

Take into consideration a scenario, wherein, you've got created an Excel 2007 spreadsheet containing information about the sales revenue of your firm. You've an on-line meeting along with your colleagues where you need to discuss the figures and stats given in the Excel sheet. You save the file in.xlsx format and publish it to Excel Services. When you use a Web browser to load the particular Excel workbook, Excel Services does not load it. Furthermore, you obtain the following error message:

"Unable to Load Workbook
The workbook that you simply selected can not be opened.
The workbook may perhaps be in an unsupported file format, or it may perhaps be corrupt.
Would you like to attempt and open this file in Excel?"

Trigger

The error message is often received in the following situations:

* If the workbook contains a formula which has a space character in front of the (^) caret operator.
* Or if the workbook in question is corrupt or damaged

Resolution

The following Repair excel file steps have to be regarded as to resolve the difficulty:

* You must do away using the space character which is placed in front of the caret operator in the formula
* You can also save the affected workbook in non-XML binary format (.xlsb) after which attempt to republish it to Excel Services
* If the difficulty does not get resolved, then it really is for positive that the workbook is corrupt. You must employ a third-party Excel repair application and fix the errors in an uncomplicated way.

tags:ccie workbook,ccie lab workbook,ccie exam workbook