Excel Tip- How To Find Unsaved Versions Of Your Excel Workbooks


I bet you have closed the odd Excel workbook or two without saving the changes when really should have.  I know I have!.  Not so much of a worry with Excel 2010 onwards though as your workbook will be automatically kept for four yes FOUR days if you forget to save them.

That’s great but how do you get to these files???

  • File Tab
  • Info Section
  • Manage Versions
  • Recover Saved Documents

A list of unsaved documents will appear, just click on the one you want to save and click open.  You will then be able to edit and save in the usual way.

1773642

 

 

 

 

 

 

 

 

 

 

 

This of course will work for all of your Office Documents.  Give it a go!

 

More Excel Tips

 

 

 

 

Change Your Default Chart Type 

Create Dynamic Chart Titles

Add A Trend Line To Your Excel Chart

vlookup-book-cover

 

 

 

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts