The AutoRecover feature
Both the Windows and macOS versions of Excel offer an AutoRecover feature that automatically creates backup copies of your workbooks while you work. Excel for Windows offers customization and additional functionality not offered in Excel for macOS, so I’ll discuss both versions separately.
Excel for Windows AutoRecover
In Excel for Windows, you can specify the interval you wish Excel to use for creating backup copies of your work. The default value is every 10 minutes, but in my experience, this means backups get made in between 20 to 25 minutes. I don’t know about you, but I can complete a lot in Excel tasks in that amount of time, so I like to shorten the interval:
- Choose File | Options | Save.
- Make sure that the Save AutoRecover information checkbox is turned on.
- Change the Save AutoRecover information setting from every 10 minutes to every 2 minutes instead, as shown in Figure 2.3:
Figure 2.3...
