Selected Workbook Cannot be Opened

Selected Workbook Cannot be Opened

Selected Workbook Cannot be Opened

Microsoft Excel is a spreadsheet application with advanced functionalities and features. You can include graphs, pivot tables, charts, formulas etc. Excel is used in different fields like accounting, report generation and more. From Excel 97 to Excel 2003, the spreadsheets are saved in the .xls format. Microsoft Excel 2007 uses another XML (eXtensible Markup Language) based format which is named as .xlsx. At times, you may face issues related to file corruption while opening these spreadsheets. Excel provides automatic recovery mode to solve minor corruption problems with Excel files. If you reopen the affected file, it will try to repair and restore it. But, in case of potential spreadsheet damage, you may need to scan your file with efficient Excel Repair tools.

Consider a scenario, you try to publish a workbook to a Microsoft SharePoint Web Part report page and it gives the following error:

"The workbook that you selected cannot be opened. The workbook may be in an unsupported file format, or it may be corrupt. Would you like to try and open this file in Excel?"

The error is specific to Excel 2007. As an additional symptom, when you try to open this workbook, you get unreadable content error.

Cause
The above error occurs when one of the following situations is true:

. The file contains PivotTable that uses KPI (Key Performance Indicators) and one or more of them have an expression in Current Time Member property.
. Excel workbook is damaged or corrupt


Solution
To solve the issue, you need to follow these steps:

. Try removing expressions from Current Time Member properties
. Repair damaged Excel file:

. Open the file with Open and Repair feature
. Try to link the file from a new workbook
. Open the file in MS Word, WordPad or Microsoft Excel Viewer
. If a chart is linked to the file, use a macro that can extract data
. Use commercial excel recovery solutions to scan and repair your damaged Excel file.

XLS repair software are special tools to scan and repair your damaged Excel files. These applications feature read-only design, rich graphical interface, advanced options and precise documentation. You can use these software in almost all cases of Excel spreadsheet corruption.

Stellar Phoenix Excel Recovery is the finest Excel Repair tool to revamp and restore damaged Excel files. This read-only tool can restore all file objects like pivot tables, charts, images, hyperlinks, graphs etc. It supports Excel 2007, 2003, 2002 (XP) and 2000. The software is compatible with Windows Vista, XP, 2003, 2000 and NT.