OMG – I forgot SAVE…

“I started a new workbook.  Worked so hard to create a report from scratch.  Meanwhile I opened many other workbooks to get the data I needed.  Then I realized that too many workbooks were opened.  I closed some of them and clicked “Don’t Save” when prompted…… OMG, did I just close the workbook that I am working on… without SAVE???  Would someone save me???” Image Does it sound familiar to you? Don’t cry!!  As long as you have not turned Autosave off.  You don’t lose everything but the work in the past 10 minutes (more or less depending on the time interval you set for Autosave). First let’s identify where the Autosaved files are? Go to File –> Option –> Save

Excel Tips - Recover file not saved 3

Make sure the two highlighted checkboxes are checked.  Although you may change the default AutoRecover file location, I don’t see a strong reason for doing that. To quickly get your unsaved workbook back: Open a new workbook –> File –> Info –> Manage Versions

Excel Tips - Recover file not saved 2

You will see your unsaved workbook sitting there, waiting for you to save it!  Simply open it and save it! Cool!!!! Wait… what if I closed my workbook without save before the 1st autosave happened??? Well, take the lesson and don’t make the mistake again in the future.  🙂

Note: Don’t rely on AutoRecovery.  You should build a good habit to save your workbooks from time to time.


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Basic and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.