If you are a regular user of Microsoft Excel and frequently apply pivot table reports to your spreadsheets then may be someday you face this error when you are trying to open the saved spreadsheet:
“Unable to read file”
And when you will click ok another message will display that will announce:
“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”
If further you close the message dialog box, the PivotTable drop-down fields do not appear.
The reason for the same can be any of the few if your worksheet is corrupted or if you have enabled the Auto Recovery option or you have opened an unprotected workbook which contains a Pivot table report or you have turned off the works sheet protection after making it on. Any mail operation or shared editing can be other causes.
This could be a big problem to the users as pivot table is a powerful tool used by mainly accountants and managers in excel sheets as this helps them to summarize and visualize the data in their spreadsheets. This tool helps them to automatically sort, total and count the data in one table or spreadsheet and helps them to create another one also with this summarized data. So very useful data is stored using this tool and the loss of any of the table could be a big disaster to them.
Microsoft has recommended having latest Office XP Service Pack 3 to solve the problem. This solution surely works for the future cases but what about the data which is already corrupted in your spreadsheets and the problems of corruption may also arise after you install this service pack. So in order to come up with these data loss problems the solution comes in the name of Excel repair software. These software help you to repair your corrupted spreadsheets and finally restore them with the original content and view.
Stellar Phoenix Excel Recovery software is the most widely used and well working software among rest of all others. This software provides you the best feature to repair Excel files which contain pivot table reports and helps you to save your valuable information. All the file versions of Excel are supported with it including Excel 2000, 2002, 2003 and 2007. To operate it the user need not to possess any technical skills and can do easily with its user friendly interface.