The Always create backup setting
You can instruct Excel for Windows to create an automatic fallback position for critical workbooks. There are a few caveats:
- You must enable this setting on a workbook-by-workbook basis.
- Your backup copy is the most previously saved copy of your workbook.
- Excel creates a file that has a
.XLK
extension that it will not recognize when you open your backup file, which we'll discuss. - The backup file must reside in the same folder as the original document, as there is no provision for saving backup files elsewhere.
- This feature is not available in Excel for macOS.
Let’s see how to establish an automatic backup for key workbooks: