A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
First save a copy of the workbook under a different name, then check whether its workbook window, worksheet, rows, or columns were hidden before attempting recovery or repair.
1. Check for hidden content
- Open the workbook.
- Select View → Unhide.
- If the workbook appears in the list, select it and choose OK.
- At the bottom of Excel, right-click any visible sheet tab and select Unhide.
- Select the missing worksheet and choose OK. Hidden worksheets retain their data even though it is not visible.^1^
- If the correct sheet is visible but its cells appear empty:
- Select the entire sheet by clicking the triangle above row 1 and left of column A.
- Select Home → Format → Hide & Unhide → Unhide Rows.
- Repeat with Unhide Columns.
If View → Unhide is unavailable, there is no hidden workbook window. If a sheet was marked VeryHidden by VBA, it will not appear in the normal Unhide dialog; contact the workbook’s owner or developer.^1^
Do not use Document Inspector’s Remove All option while recovering data. Removed hidden content might not be recoverable with Undo.^2^
2. If the workbook is stored in OneDrive or SharePoint
Restore a version from before the sheet became empty:
- Open the workbook and select File → Info → Version History.
- Open an earlier version from the right-hand panel.
- Confirm that it contains the missing data.
- Select Restore.
Version History in Microsoft 365 applies to files stored in OneDrive or SharePoint.^3^
Alternatively, in OneDrive or File Explorer, right-click the OneDrive file, select Version history, choose the … beside an earlier version, and select Restore.^4^
3. If the workbook is stored only on the PC
Check for a Windows backup copy:
- Close Excel.
- In File Explorer, right-click the workbook and select Properties.
- Open the Previous Versions tab.
- If a version is listed, choose Open first and verify that it contains the data.
- Copy that version to a new filename, or select Restore.
This option works only if File History or another backup solution was enabled before the data disappeared.^5^
4. Check Excel AutoRecover
If Excel closed unexpectedly or the latest changes were never saved:
- Open Excel and select File → Info → Manage Workbook → Recover Unsaved Workbooks.
- Open any relevant recovery copy.
- Immediately use Save As and give it a new filename.
For a previously saved workbook, also look under Manage Workbook for a version labeled (when I closed without saving); open it and select Restore only after confirming it contains the missing information.^6^
5. Repair the workbook if it is damaged
Work from a copy so the original remains unchanged:
- In Excel, select File → Open → Browse.
- Select the copied workbook once—do not double-click it.
- Select the arrow beside Open, then Open and Repair.
- Choose Repair.
- If Repair fails, repeat and choose Extract Data to recover available values and formulas.^7^
If none of the hidden-content checks, Version History, Windows Previous Versions, AutoRecover copies, or repair options contains the data, Excel may not have a recoverable copy. Preserve the original file and any backup copies rather than repeatedly saving over them.
References
- Hide or Unhide worksheets
- [Excel](https://support.microsoft.com/office/collab-files/remove-hidden-data-and-personal-information-by-inspecting-documents-presentations-or-workbooks#what-the-document-inspector-finds-and-removes-in-excel-documents)
- View previous versions of Office files | Microsoft Support
- Restore a previous version of a file stored in OneDrive | Microsoft Support
- restore overwrite data - Microsoft Q&A
- Recover an earlier version of an Office file | Microsoft Support
- Repair a corrupted workbook | Microsoft Support