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.

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum 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.