Do you have important Excel files that would create nothing short of chaos and disaster for you if you were to lose those files?
Now I’m sure that you regularly make copies of these files just in case – but wouldn’t it be nice if Excel could help us out a bit on this score?
I found in the options of Excel’s Save As window a little backup for our very important files.
To take a look you’ll need to go to the Save As window, Tools menu, General Options choice.
At the top of the Save Options window that opens you should see a checkbox for something labeled as “Always create backup“.
Should you choose to check this option and click OK what will happen is obvious. Every time you save, after the initial Save As, Excel will create a backup file too – automatically.