subject: Rectifying "unable To Read File Error Message In Ms Excel [print this page] MS Excel is a spreadsheet application that features graphic tools, calculations, pivot tables and a Macro programming language known as VBA ( Visual Basic for Applications). At times, you might face some
issues while trying to open a particular file in Excel. This happens due to some errors in the Excel file. Virus infection, improper system shutdown, power surge are few of the reasons for corruption of the Excel file,
which causes the inaccessibility of data. In such situations, you require a valid data backup to restore the data. In case of unavailability of backup, you will need to use a powerful Excel Repair software to retrieve your
data.
For instance - As a regular user of MS Excel, if you apply pivot tables reports to your spreadsheets, then you may encounter the below error message:
"Unable to read file
When you further click OK, it gives you another error message similar to the following:
Errors were detected in 'filename.xls', but Microsoft Excel was able to open the file by making the repairs listed below. Save the file to make these repairs permanent
"PivotTable report 'report_name' on
'[filename.xls]worksheet_name' was discarded due to integrity problems
When you close the dialogue box, the Pivot table drop-down fields do not appear.
Cause:
Following can be the possible reasons for the above issue:
The worksheet is corrupted.
You have opened an unprotected workbook containing a Pivot table report.
You have turned off the worksheet protection after making it on Any mail operation.
Resolution:
To resolve these issues, you need to obtain the latest Office XP Service pack 3. But, you may face some problems even after installing the Service pack. In these situations, you need to Repair Excel File by using an
efficient excel repair software. The repair application employs powerful scanning algorithms to retrieve the inaccessible data from the corrupted Excel file. The utility
provides highly interactive graphical user-interface that makes it easy to use without any prior technical understanding.
Stellar Phoenix Excel Repair is a flawless software that completely excel file repair comprehensively in almost all data loss scenarios. The read-only software is fully
competent to repair all objects of spreadsheet such as hyperlinks, tables, floating point numbers, formulas, etc. The software also gives you an additional feature to preview your repairable files. The repaired files can be
restored at any desired location. Supporting MS Excel 2000, 2002, 2003, and 2007, the software is compatible with Windows Vista, XP, 2003, and 2000 based operating systems.
