Have you ever started a new Microsoft Office Excel, Word, or PowerPoint file and been getting pretty far along when you accidentally close the document before saving it (or lose power and the computer shuts down, etc.)? Here’s a helpful little tip for any of you out there that happen to find yourself in the situation I did this morning. In my case, I was building a large Excel spreadsheet and went to go delete a tab (while multi-tasking) and just after I clicked the “confirm” box, realized I just confirmed to close my whole Excel sheet without saving it, not just to delete my single tab. Ouch!!
Of course the Excel guru who normally sits relatively close to me was off in a meeting somewhere and I certainly didn’t want to start this whole project over, especially since this is for a 1:00 meeting today. I know, I know… Save, save, save as you go. Usually I do but today I didn’t. So now what?!!? Here is where Microsoft Office 2010 saved the day (and several hours of work!)
Microsoft Office has a fantastic feature built in where it can recover unsaved new documents (just in case you do what I did)! Now in order to use this feature, you will need to have Save AutoRecover information... and Keep the last autosaved version if I close without saving enabled inside Microsoft Office. (If you’re not sure if you do, I have included the steps to enable this at the bottom of this post).
Here are the steps to take to recover your unsaved new document in Microsoft Office Excel, Work, or PowerPoint 2010 if you inadvertently close it before saving it:
You can also access these files by using these steps:
You can also browse to one of the following file locations to open the file, depending on your operating system:
Important These file locations cannot be changed.
I followed the steps above and sure enough, my unsaved Excel sheet was right there and ready to go!
Now, as promised in the beginning of this post, here is how to enable AutoRecover and AutoSave to protect your files in Microsoft Office:
Important The Save button is still your best friend. To be sure you don’t lose your latest work, click Save (or press CTRL+S) often.
Hopefully you never find yourself in the position to need these auto-recovery tools with your documents, but if you do, hopefully the steps above will come in handy for you and save your day like it did for me today. Thank you, Microsoft Office!!
Did you find this information helpful? If so, you may want to make sure you are utilizing all of the areas I share information online, such as:
Thanks again for being a reader of my blog!
Thank you and have a wonderful day,
Eric Ligman – Follow me on TWITTER, LinkedIn, and RSS and see “What I’m thinking” Director, Worldwide Partner Experience Microsoft Corporation This posting is provided "AS IS" with no warranties, and confers no rights
Thanks for the valuable and informative post!!
I really liked this.
my god, many times i lost my data due to power failure, thanks.
Thanks for sharing the info!