Everyone has a lost-file story: the budget closed without saving, the laptop that died the night before a deadline or the file someone overwrote with an old version. In most cases, a few minutes of setup would have prevented the problem. In this article you will see how to protect your Excel files with several layers of safety, from the program’s own options to a complete backup strategy.
Layer 1: AutoSave and AutoRecover
Excel has two features that are often confused:
- AutoSave: saves changes continuously while you work. It only works with files stored in OneDrive or SharePoint.
- AutoRecover: saves a temporary copy every few minutes so you can recover your work if Excel closes unexpectedly. It works with local files.
Set up AutoRecover
- Go to File > Options > Save.
- Turn on “Save AutoRecover information every” and set it to 5 minutes (or less).
- Turn on “Keep the last AutoRecovered version if I close without saving”.
- Note the AutoRecover folder path in case you need to look for files manually.
Important: AutoRecover does not replace saving. It is a safety net for unexpected shutdowns, not a backup.
Layer 2: version history in the cloud
If you store your files in OneDrive, Google Drive, Dropbox or SharePoint, the service keeps earlier versions automatically. This protects you against:
- Overwriting a file by mistake.
- Unwanted changes by other users.
- File corruption.
- Some kinds of ransomware, since you can restore versions from before the encryption.
Check how long your service keeps versions and whether that is enough for your needs.
Layer 3: numbered versions at key milestones
Besides automatic history, manually save a named version at key moments: before sending a file to a client, before a major change or at the end of each month. Use dated names such as sales_2026-09-30_v05.xlsx. That way you can compare them at any time with the Excel comparison tool on our Excel tools page and know exactly what changed.
Layer 4: the 3-2-1 rule
For truly important files, apply the classic backup rule:
- 3 copies of your data: the original and two copies.
- 2 different media: for example, your computer’s disk and an external drive or a cloud service.
- 1 copy off-site: if there is a fire, theft or flood, the off-site copy survives.
A practical example: you work on your computer, sync with OneDrive and once a week copy the folder to an external drive kept somewhere else.
Layer 5: check that backups work
A backup that cannot be restored is useless. Every so often:
- Pick a random file from the backup.
- Restore it to a different folder.
- Open it and check it is complete.
If the restored file does not open, try fixing it with the repair tool on our tools page and find out why the backup failed.
What to do if you lose a file
Follow this order:
- Do not save anything new to the same disk, so you do not overwrite recoverable data.
- Check the recycle bin on Windows or macOS and in your cloud service.
- Look in AutoRecover: File > Info > Manage Workbook > Recover Unsaved Workbooks.
- Check the cloud service’s version history.
- Look for previous versions on Windows with right-click > Properties > Previous Versions.
- Restore from your backup.
Files that deserve special attention
- Accounting and invoicing.
- Payroll and employee data.
- Customer databases.
- Inventories.
- Templates with complex formulas that took a lot of effort to build.
For those containing confidential data, encrypt the backups with a password too. An unprotected backup on an external drive is a risk if the drive is lost.
Frequently asked questions
Is syncing to the cloud the same as backing up?
Not exactly. If you delete a file on your computer, syncing also deletes it in the cloud (although it usually stays in the bin for a while). That is why it is worth having an independent copy as well.
How often should I back up?
It depends on how much work you are willing to lose. If a day’s work is too much, you need daily backups or continuous sync. For files that rarely change, a weekly copy may be enough.
Where does Excel store AutoRecover files?
The path is shown under File > Options > Save, in the “AutoRecover file location” field. On Windows it is usually inside the user’s AppData folder. It is worth noting it down in case you ever need to look for a file manually.
Is an external drive enough as a backup?
It is a good start, but if the drive is always plugged into the computer, a power surge or ransomware can affect both. Unplug it after each backup and combine it with a cloud copy to follow the 3-2-1 rule.
Should I back up temporary files?
No. Files starting with “~$” are temporary files Excel creates while a workbook is open. They do not contain your work and you can exclude them from backups.
Conclusion
Never losing your Excel work is a matter of layers: AutoRecover every few minutes, cloud version history, numbered versions at milestones, the 3-2-1 rule for what matters and regular checks that your backups work. Setting it up takes less than an hour and can save you days of work. And if a file ever fails, remember our Excel tools page has free utilities to repair it and compare it with earlier versions.
Try our free tools
Compare, convert, merge and clean your spreadsheets right in your browser, with nothing to install.
