Forum Discussion

sunjiayuan's avatar
sunjiayuan
Copper Contributor
Apr 06, 2025

The EXCEL worksheet disappears

MACBOOK .  Hi guys, when I was using excel today, because there were a lot of worksheets, I moved one of the worksheets out, thinking it was going to be a separate one, and the worksheet disappeared, and the back key didn't work. I was wondering how anyone could find the worksheet before it disappeared.

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    If you accidentally closed the window without saving…

     

        Look in ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery

    (you can use Finder > Go > Go to Folder) for autosave files.

     

    Access the AutoRecovery Folder on a Mac:

        In the top menu, click Go > Go to Folder...

        Paste this path:

    ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery

     

    You might see files like:

    AutoRecovery save of MyWorkbook

    AutoRecovery save of Workbook1

    These are Excel’s autosaved files. You can open them in Excel, and they might contain your missing worksheet.

     

    Hope this helps you.

Resources