May 24, 2016
Hi fellow Excel Addict,
Sorry I'm a little late with my newsletter this week. I'm just back from a weekend at the Halifax Bluenose Marathon. It was a awesome event and a fun weekend shared with a great group of friends.
I completed the 10K run and thankfully my knee didn't cause me any problems as in the past.
Here are a few photos...
Now I'm looking forward to the next race.
If you emailed me since last Thursday, sorry, I haven't had time to reply to any emails. I'm just now catching up on things so please bear with me and if you don't get a reply from me within the next week, please feel free to email me again.
Excel in Minutes
In last Thursday's 'Excel in Minutes' tutorial, I showed 'How to Generate Random Numbers and Lists'. If you missed it, you can find it here.
Last Minute Reminder:
Registration for Mynda's Online Excel Dashboard course closes today at 8pm PST (May 26). If you already watched Mynda's Dashboard Webinar, you've seen how easy it is to build interactive dashboard reports that can be updated in just a few seconds. If you missed it, you can watch a replay of the webinar here...but hurry because the course registration closes in just a few hours. You will be joining more than 1,000 other Excel Addict members who have taken Mynda's course. Go here to register>>
If you have a suggestion for a tip you would like me to include in a future newsletter or have a favourite tip that you'd like to share, please send it along to me.
Wishing you an AWESOME week,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
Open the Last-Saved Version of an Open Workbook
You have been working on your spreadsheet when you realize that something is wrong. You have deleted something by mistake or you have messed up some formulas.
If you're like me, you probably haven't saved your changes since you opened the workbook.
What do you do?
Do you try to figure out what you messed up and risk missing something? Or do you close the workbook without saving all those changes you've made and start all over?
Hopefully, you will do neither.
Maybe you would save your spreadsheet with a different name, then open the original workbook to compare data with the one you've been working on.
Not a bad plan. But here's an even better one!
You can easily open a copy of last-saved version of the workbook you currently have open. Here's how...
1) From the File tab (or the Office Button in Excel 2007) click Open. The Open dialog box will appear;
2) Browse to the folder and select the filename of the workbook you want to open a copy of;
3) Click on the small down-arrow on the right side of the Open button;
5) From the menu that appears, click 'Open As Copy'. Excel will open a copy of the last-saved version of the workbook.
You will notice that the filename is the same except Excel adds a prefix, such as "Copy (1)" or "Copy of" to the filename.
Now that you have both files open, you can much more easily compare them see what data you have changed.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630