The best way to fix ‘Workbook that you selected can not be opened’ error

Excel services function with Excel 2007 and permits 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 and so on. By making use of a Internet browser, end users can view and interact using the workbooks. Having said that, at times, when you publish a ccie lab workbook to Excel Services and attempt to load it in a browser, you may run into an error message. Such scenarios erupt when you attempt to load a corrupt ccie exam workbook. You can use a wholesome backup copy of the Excel file and upload it once again to the server. Having said that, for those who can not access a backup copy or if it is actually not an updated 1, then you have to take into consideration making use of an Excel repair software.

Contemplate a scenario, wherein, you might have designed an Excel 2007 spreadsheet containing information and facts about the sales revenue of your provider. You may have an on the internet meeting with your colleagues where you need to talk about the figures and stats given inside the Excel sheet. You save the file in.xlsx format and publish it to Excel Services. Whenever you use a Internet browser to load the certain Excel workbook, Excel Services doesn’t load it. Moreover, you obtain the following error message:

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

Cause

The error message can be received inside the following scenarios:

* 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 actions have to be deemed to resolve the difficulty:

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