If you’re using a Mac, try one of the other methods in this article.
If Open and Repair. . . is greyed out, make sure that your Excel file is selected and try again. If it’s still greyed out, you can’t repair this file.
If you don’t have this option, click Extract Data instead, then click either Convert to Values or Recover Formulas. This will recover any salvageable data.
If the file still won’t open, go back through this process and click Extract Data instead of Repair when prompted.
Be sure to select a different file name than the one which you used for the corrupted Excel file.
Be sure to select a different file name than the one which you used for the corrupted Excel file.
Be sure to select a different file name than the one which you used for the corrupted Excel file.
For example, if the document was named “Spreadsheet1. docx”, you would change it to “Spreadsheet1. xlsx”. If the file extension already is “xlsx”, try using “xls” or “html”.
If you chose the “html” extension, you can convert the webpage into an Excel document by dragging the html file onto the Excel icon and then saving the file that opens as a new “xlsx” file. If the file still won’t open, proceed to the next Windows method.
For example, if the document was named “Spreadsheet1. txt”, you would change it to “Spreadsheet1. xlsx”. If the file extension already is “xlsx”, try using “xls” or “html”.
If you chose the “html” extension, you can convert the webpage into an Excel document by dragging the html file onto the Excel icon and then saving the file that opens as a new “xlsx” file. If the file still won’t open, proceed to the next Mac method.
If you can’t find this folder, click the View tab, then check the “Hidden items” box in the “Show/hide” section to prompt the “AppData” folder to appear.
If you don’t see any files here, a recovery version of your Excel document was not saved.
Click View Check the “File name extensions” box. Click Home Click Rename Replace the . tmp section with . xlsx Press ↵ Enter. Click Yes when prompted.
Be sure to select a different file name than the one which you used for the corrupted Excel file.
Be sure to select a different file name than the one which you used for the corrupted Excel file.
Be sure to select a different file name than the one which you used for the corrupted Excel file.
If you don’t see the Go menu item, first open Finder or click the desktop to make it appear.
If you can’t find the temporary version of your Excel file, it wasn’t backed up.
The temporary version will probably not include some of your most recent changes to the original Excel document.
