Dear,


I am facing the below mentioned problem whenever i open a file with pivot tables.

When file is opened i am getting error message that "Unable to read file"

After pressing Ok.......another error message appears ...."We found a problem with some contents in 'filename.xls'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes"

after clicking yes below mentioned error is coming and pivot table vanishes and only values will be available.

PivotTable report 'PivotTable1' on '[May Wages 2015.xls]Direct Summary' was discarded due to integrity problems.
PivotTable report 'PivotTable1' on '[May Wages 2015.xls]Indirect Summary' was discarded due to integrity problems.

Please help me out.

Thanks and Regards,