Excel Quick Backup Tool for You
March 31, 2020
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
If you're working on an important Excel file, it's a good idea to make backups of your workbook, as you go along. That gives you multiple versions of the file that you can revert to, if things go wrong.
To do that, get a copy of my free Excel backup tool. It's a simple xlam format file, so you don't need to register it, or do any fancy installations.
After you activate it, Backup Free appears on the Excel Ribbon's Review tab.
NOTE: If you need advanced backup features, check out the Backup Pro version.
Here's are a couple of new articles that I posted
Excel Error: Have you ever seen this Excel pivot table refresh error, with Data Model data? Thanks to UniMord, who told me about this strange error, and how he fixed the problem.
Pivot Items: Use this Excel macro to keep one pivot item collapsed, but allow other items to expand. This won't protect the hidden items (people could find other ways to see them), but you might have other reasons to keep them hidden in the pivot table layout.
Here are a few Excel-related articles that you might find useful or interesting.
Power BI: If you're working in Power BI, Eugene Meidinger explains when to use its languages, DAX and M, in this short and clear article. (Level-Int/Adv)
Formula Challenge: Keep your Excel skills sharp with this formula challenge from Chandoo. You'll check a column of codes, to see if your secret agent number (007 of course) is hidden in the cells. (Level-Int)
Excel Humour: See what people said about Excel recently. If you're working from home now, are the kids helping with your Excel projects?
Are you working from home now? Is it something you're used to, or is it a new experience? I've enjoyed working at home for many years, but even so, it's strange to stay home all the time. Fortunately, the weather is getting better, here in Canada, and there are a few brave plants sprouting in the garden, like these day lilies. If you're looking for me, I might be outside, chatting with the plants!
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2020/20200331ctx.html
I'll also post any article updates or corrections there.
That's it for this week! If you have any comments or questions, send me an email.
Last updated: March 28, 2020 3:29 PM