Contextures

Contextures News 20200331

Excel Quick Backup Tool for You

March 31, 2020

Formula challenge, quick free backup tool, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Quick Backup Tool

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.

  • Click the top part of the button, to save a backup copy into the current folder.
  • Click the lower part of the button to see other commands

NOTE: If you need advanced backup features, check out the Backup Pro version.

make a quick backup

On Contextures

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.

Excel Articles

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?

Also see: My Excel Products || Previous Issues

In the Garden

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!

weekly photo

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.

Debra Dalgleish
dsd@ contextures.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

contextures newsletter info

 

Related Links

Backup Pro

Free Excel Backup Tool

 

 

 

 

 

Get weekly Excel tips from Debra

 

pivot power free

 

 

 

 

 

Last updated: March 28, 2020 3:29 PM