What happens if you unintentionally delete a tab in Excel? There is no “undo” for recovering a deleted tab.
The general solution is to get the last saved version of the file to recover the tab. This works for anything that you cannot “undo” in Excel. For example, actions from a VBA script.
If your last save of the Excel file is very recent, and you did not change much since the last save:
- Close Excel, do not save changes
- Open file again
If your last save was a while ago, or you are not sure if a lot of updates were changed:
- Save the a new Excel file using “Save As”.
- Open the original file
- Copy the deleted tab in to the new Excel file
- Close the original file
- Delete the original file (you no longer need it, but if you want to keep it, shelve it in a backup folder just in case)
- Rename the new file to the original file’s name
Alternatively, you can keep the original file instead:
- Save the a new Excel file using “Save As”.
- Open the original file
- Find and restore changes from the new file to the original file
Beware:
- If you have a lot of referencing the deleted tab, you may want to consider keeping the original file, and restoring new changes from the new file instead. This is because the cells referencing the deleted tab will all turn into #REF.
- If you have a lot of other Excel files open that link to the file with the accidentally deleted tab, you MUST close the other files prior to saving the files separately. Otherwise the other files will all change their links to the new file’s name, but will not change back after the new file is renamed. For example, if Recovery.xlsx is the original file, the new file is Recovery2.xlsx, the other files will keep its references as Recovery2.xlsx if they are not closed during the Save As step.
- Any changes made to the deleted tab after the last save cannot be recovered.
Your brilliantly clear instructions led me straight to my ‘lost’ excel file.