Computer Problems? Call Toll Free @ 1 877 316 9417
Troubleshoot all your computer problems with certified tech experts, Call Today!


How to fix the error: “Unable to read file”

When you try to open a workbook with PivotTable report in Microsoft Excel, you face this error when the system is unable to read a file. This issue can occur if the AutoSave feature is turned on, the workbook you are opening is unprotected, and you protect and then unprotect a worksheet.

The solution to the problem

Follow the instructions to fix the error: “Unable to read file”:

  1. 1

    If you have not already done so, start Excel.

  2. 2

    On the ‘Tools’ menu, click ‘Options’.

  3. 3

    In the ‘Options’ dialog box, click the ‘Save’ tab.

  4. 4

    Under ‘Settings’, click to clear the ‘Save AutoRecover info every’ check box.

  5. 5

    Click ‘OK’ to close the ‘Options’ dialog box.


Make sure that you have enabled AutoSave feature on your worksheet to avoid this error. You can also resolve this issue by contacting Microsoft Product Support Services to obtain a supported fix.

Leave a Reply