November 3, 2016
Thank you for taking time out of your busy schedule to join me again and hopefully add to your 'awesome' Excel skills. Yes, my guess is that your Excel skills are AWESOME. If you are taking the initiative to regularly read (and practice) the tips in my newsletter and consistently add them to you Excel toolbox, then you're way ahead of 98% of all other Excel users who don't.
In today's 'Excel in Minutes' tip I'm going to show you how to 'Open the Last-Saved Version of an Open Workbook'. If you're anything like me, you will probably need to use this every once in a while.
If you missed my 'Excel in Seconds' newsletter on Tuesday, I showed you 'Printing Without Color'. You can read that tip here.
I hope you have a great week and keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
If you have a favourite quote, send it to me and I may post it in my newsletter.
Open the Last-Saved Version of an Open Workbook
Picture this. You have been working on a spreadsheet for some time when you realize that something has gone terribly wrong. Everything is messed up. Maybe you deleted something by mistake or messed up some formulas.
What do you do now?
If you're like many Excel users, you probably haven't saved any changes since you opened the workbook. So, do you spend a lot of time trying to figure out what's messed up? Or do you close the workbook without saving your changes and then start all over?
Hopefully, you would do neither of those.
Or, maybe you would use the 'Save As' option to save your spreadsheet using a different filename, then open the original workbook to compare data with the one you've been working on. That's not a bad option but I've got an even easier one!
Most people don't know that you can open the last-saved version of a workbook that you currently have open without having to close it first?
If you didn't know this, it's not surprising. The option is practically hidden away in Excel. So, let me show you how to find it.
The workbook you currently have open should be in your Recent Workbooks list.
1) From the File tab click Open. Your recent workbooks should be listed;
2) Right click on the workbook name and choose 'Open as copy'. A copy of the last-saved version of the workbook will open. The new filename will be the original workbook name followed by a number (e.g. Payroll1). If you are using an older version of Excel which doesn't let you right-click on the Recent Workbooks list see below**.
Now you can compare the data in the last-saved version of your workbook with the messed up one and see what's wrong. Then, if necessary, you can copy any correct data and formulas to your current version and get things back on track.
** If you are using an older version of Excel which doesn't let you right-click on the Recent Workbooks list, you can also open the last-saved version of a workbook from the Open dialog .
1) From the File tab (or the Office Button in Excel 2007) click Open;
2) Browse to and select the workbook you want to open;
3) Click the small down-arrow on the right side of the Open button and select 'Open As Copy'. A copy of the last-saved version of the workbook will open.
You will notice that by opening a copy of the workbook using this method, the new filename has 'Copy (1)' or 'Copy of' as a prefix on the filename..
Now as with the previous method, you can compare the data in the last-saved version of your workbook with the messed up one and see what's wrong. Then, if necessary, you can copy any correct data and formulas to your current version and get things back on track.
|"Spreadsheets Tips From An
Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630