Here Is How You Can Easily Disable Auto Backup In Excel

Disabling auto backup in Excel is simple and can save you disk space, reduce clutter, and stop unnecessary file creation. Excel’s AutoRecover and backup features are helpful, but they can slow down your workflow and fill your storage with duplicate files. This guide walks you through every method to turn off these backup settings in just a few clicks.

Excel is one of the most powerful tools for managing data, building spreadsheets, and creating reports. But if you have ever opened your backup folder and found dozens of backup files eating up your storage, you know the frustration. Many users want to know how to disable auto backup in Excel and take back control of their files. This guide will show you exactly how to do it, step by step, without any confusing tech talk.

Whether you are using Excel on a Windows PC or a Mac, the process is straightforward once you know where to look. Excel has several built-in features designed to protect your work. These include AutoRecover, backup copies, and auto save. While these tools are great for preventing data loss, they can also create clutter and slow things down. We will cover every method to turn them off so your Excel experience feels cleaner and faster.

In this article, you will learn about the different backup features Excel uses, where your backup files are stored, and the exact steps to turn each one off. We will also share tips on managing your Excel files better and avoiding common pitfalls. By the end, you will have full control over your backup settings and know exactly how to disable auto backup in Excel on your system.

Key Takeaways

• AutoBackup is different from AutoRecover: Understanding the distinction helps you control exactly what gets saved and where.
• You can disable backup through File Options: The most common method works in Excel 2016, 2019, and Microsoft 365.
• Registry edits offer advanced control: For power users who want deeper backup settings removed.
• Turning off backups frees up storage: Duplicate backup files can take up significant hard drive space over time.
• You can still manually save versions: Disabling auto backup doesn’t mean losing all version control options.
• Common mistakes cause backup issues: Avoiding these pitfalls keeps your Excel experience smooth.

Understanding Excel Auto Backup and AutoRecover

Before you change any settings, it helps to understand what Excel is actually doing behind the scenes. Many people confuse auto backup with AutoRecover. These are two different features that serve related but distinct purposes. Knowing the difference makes it much easier to decide which ones you want to keep or turn off.

What Is AutoBackup in Excel?

AutoBackup is a feature that saves a copy of your workbook every time you close it. This backup file is stored in a separate location, usually a folder called Backup inside your Excel options. The purpose is simple. If your original file gets corrupted or lost, you can restore it from the backup copy.

However, AutoBackup creates a new file every time you save and close. Over weeks or months, these files can pile up. They take up hard drive space and can confuse you when you are trying to find the right version of a file. This is the main reason most users want to turn off auto backup in Excel.

What Is AutoRecover in Excel?

AutoRecover is different. It saves your work periodically while you are actively working on a file. The default setting saves every ten minutes. If Excel crashes or your computer shuts down unexpectedly, AutoRecover can restore your unsaved work when you reopen the application.

AutoRecover files are temporary by nature. They are not meant to be permanent copies. When you close a file normally, AutoRecover stops saving for that file. This makes AutoRecover a useful safety net without creating long-term clutter. But if you want to disable auto backup in Excel, you may also want to adjust AutoRecover settings to reduce the frequency or turn it off entirely.

Step-by-Step Guide to Disable Auto Backup

Now let us get into the practical steps. You will learn how to turn off backup settings through the Excel options menu. This method works for most versions of Excel, including Excel 2016, Excel 2019, and Microsoft 365.

Method 1: Through Excel Options

Follow these steps carefully to disable the backup feature using the standard menu. This is the easiest and most common approach.

1. Open Excel and click on the File tab in the top left corner.
2. Select Options from the left sidebar. A new window will pop up.
3. Click on Save in the left menu of the Options window.
4. Look for the checkbox that says Save AutoRecover information every. Uncheck it if you want to disable AutoRecover entirely.
5. Next, look for the checkbox that says Keep the last AutoRecovered version if I close without saving. Uncheck this one too if you do not want to keep recovered versions.
6. Now look for the Backup File option. It may appear as a checkbox that says Always create backup copy. Uncheck this box.
7. Click OK to save your changes.

That is it. Excel will no longer create automatic backup copies when you close your files. Your backup folder will stay clean from this point forward.

Method 2: Changing the Backup Folder Location

If you do not want to disable backup entirely but just want to manage where backup files go, you can change the backup folder location. This helps you keep things organized and avoid clutter in your default folders.

• Go to File > Options > Save.
• Look for the Default local file location field.
• Click Browse and select a new folder where you want backups stored.
• Click OK to confirm the change.

This method gives you more control without fully removing the backup feature. It is a good middle-ground option for users who still want some level of protection but better file management.

Method 3: Disabling AutoSave for OneDrive and SharePoint Files

If you save your Excel files to OneDrive or SharePoint, you have another feature to deal with: AutoSave. AutoSave is different from AutoBackup. It continuously saves your work in real time while you are connected to the cloud.

To turn off AutoSave for a specific file:

• Open the file from OneDrive or SharePoint.
• Look at the top left corner of the Excel window, near the Save button.
• Toggle the AutoSave switch to off.

To turn off AutoSave for all files by default:

• Go to File > Options > Save.
• Uncheck the box that says AutoSave files stored in the cloud by default.
• Click OK.

This stops Excel from constantly saving your cloud files in the background. It can improve performance and give you more control over when changes are actually saved.

How to Manage and Delete Existing Backup Files

Even after you turn off backup features, you may still have old backup files taking up space on your computer. Let us look at how to find and clean them up.

Finding Your Excel Backup Files

Excel backup files are usually stored in a specific folder. The default location depends on your version of Excel and your Windows settings. Here is how to find them:

• Open Excel and go to File > Options > Save.
• Look at the AutoRecover file location field. It will show you the folder path.
• Copy that path and paste it into your File Explorer address bar.
• You will see all your AutoRecover and backup files in that folder.

You can also search for files with the .xlk extension. These are Excel backup files. Simply type *.xlk in the Windows search bar to locate them across your computer.

Deleting Old Backup Files Safely

Once you find the backup files, you can safely delete them. Here is what to do:

1. Open the backup folder you located above.
2. Select all the files you no longer need.
3. Right-click and choose Delete.
4. Empty your Recycle Bin to free up the space completely.

Tip: Before deleting any backup files, make sure you have a recent copy of your important workbooks saved somewhere else. You never want to lose data you still need. If you are unsure about a file, move it to a separate folder instead of deleting it right away.

Advanced Settings: Using the Registry Editor

For advanced users who want deeper control, you can modify the Windows Registry to disable backup features at a system level. This method is more technical and should be done with caution. Always back up your registry before making any changes.

Steps to Edit the Registry

1. Press Windows + R to open the Run dialog.
2. Type regedit and press Enter.
3. Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options. (The number may vary based on your Excel version.)
4. Right-click in the right pane and select New > DWORD (32-bit) Value.
5. Name the new value DisableBackup.
6. Double-click it and set the value data to 1.
7. Restart Excel for the changes to take effect.

This registry edit forces Excel to stop creating backup copies entirely. It is a powerful method but should only be used by users who are comfortable working with the Windows Registry. If you make a mistake, it could affect other Office applications, so always create a backup of your registry first.

Why You Might Want to Keep Some Backup Features On

While disabling auto backup in Excel has its benefits, there are also good reasons to keep some backup features enabled. Let us look at the trade-offs so you can make an informed decision.

Protection Against File Corruption

Excel files can become corrupted for many reasons. Sudden power outages, application crashes, and disk errors can all damage your work. Backup files act as a safety net. If your original file becomes unreadable, a backup copy can save hours of work.

If you work with important or sensitive data, keeping at least one form of backup is a smart choice. You can always adjust the frequency or storage location instead of turning it off completely.

Peace of Mind for Frequent Users

If you use Excel for hours every day, AutoRecover can be a lifesaver. Losing even a few minutes of work because of a crash can be frustrating. The key is to find a balance that works for you. Maybe you keep AutoRecover on but increase the save interval to every 30 minutes instead of every 10. This reduces the number of backup files while still protecting your work.

Common Mistakes When Disabling Excel Backups

Many users run into problems when trying to turn off auto backup in Excel. Here are the most common mistakes and how to avoid them.

Forgetting to Save Before Closing

When you disable backup features, you lose the safety net that catches unsaved changes. Always make a habit of pressing Ctrl + S before closing any file. This simple habit protects your work even without auto backup.

Confusing AutoSave with AutoBackup

AutoSave and AutoBackup are not the same thing. AutoSave continuously saves your file while you work. AutoBackup creates a separate copy when you close the file. Make sure you are adjusting the right setting for what you want to achieve. Check the Save section in Excel Options carefully.

Not Clearing Old Backup Files

Even after you disable backup, old files remain on your computer. They continue to take up space until you manually delete them. Make it a habit to clean out your backup folder every few weeks. This keeps your system running smoothly and prevents storage issues.

Ignoring Cloud Sync Settings

If you use OneDrive or SharePoint, disabling local backup does not stop cloud sync from creating version history. You need to manage your cloud backup settings separately. Check your OneDrive or SharePoint settings to control how your files are backed up in the cloud.

Quick Tips for Better Excel File Management

Here are some practical tips to help you manage your Excel files more efficiently after disabling auto backup:

• Use descriptive file names. Instead of calling a file “Report1.xlsx,” name it something like “Q3_Financial_Report_Final.xlsx.” This makes it easy to find what you need without relying on backup copies.
• Create a versioning system. Save different versions of your file manually. For example, “Budget_v1,” “Budget_v2,” and so on. This gives you control over which version you keep.
• Use cloud storage with version history. Services like OneDrive and Google Drive keep track of file versions automatically. You can restore previous versions without needing Excel backup files.
• Organize your folders. Create a dedicated folder for Excel projects. Keep active files separate from archived ones. This reduces clutter and makes backup management easier.
• Set a weekly cleanup reminder. Spend 10 minutes every week reviewing your Excel folders and deleting files you no longer need. This small habit prevents storage bloat over time.

How Excel Backup Settings Differ Across Versions

Excel backup settings can vary slightly depending on which version you are using. Here is a quick comparison of the main versions:

Excel Version	Backup Option Location	AutoSave Available?
Excel 2016	File > Options > Save	Yes (OneDrive only)
Excel 2019	File > Options > Save	Yes (OneDrive only)
Microsoft 365	File > Options > Save	Yes (OneDrive and SharePoint)
Excel for Mac	Excel > Preferences > Save	Yes (OneDrive only)
Excel 2013	File > Options > Save	Yes (OneDrive only)

The steps are very similar across all versions. The main difference is that Excel for Mac uses Preferences instead of Options. If you are on a Mac, look for the Save section under Excel Preferences to find the backup settings.

Conclusion

Learning how to disable auto backup in Excel gives you more control over your files and your storage. You now know the difference between AutoBackup and AutoRecover, how to turn off each feature, and how to manage existing backup files. You also learned about advanced methods like registry editing and how to avoid common mistakes.

Remember that disabling backup does not mean losing all protection. You can still manually save versions, use cloud storage with version history, and develop good file management habits. The goal is to create an Excel workflow that feels fast, clean, and organized.

Take a few minutes today to go through the steps in this guide. Adjust your backup settings, clean up old files, and set up a system that works for you. Your future self will thank you when your Excel files are easy to find and your storage is free of unnecessary clutter. Take control of your Excel experience and enjoy a smoother, more efficient workflow.

Frequently Asked Questions

What is the difference between AutoBackup and AutoRecover in Excel?

AutoBackup creates a separate copy of your file every time you close it and save. AutoRecover saves temporary copies of your work at regular intervals while you are actively working. AutoBackup creates permanent backup files, while AutoRecover files are temporary and designed for crash recovery only.

Will disabling auto backup cause me to lose my data?

No, disabling auto backup does not delete your existing files or data. It simply stops Excel from creating automatic backup copies. You should still save your work manually using Ctrl + S. If you use cloud storage like OneDrive, your files are still backed up there even with local backup disabled.

Can I re-enable auto backup after turning it off?

Yes, you can re-enable auto backup at any time. Simply go back to File > Options > Save and check the boxes you previously unchecked. The same applies to AutoRecover and AutoSave settings. All changes are reversible.

Where does Excel store backup files by default?

Excel stores backup files in the AutoRecover file location, which you can find by going to File > Options > Save. The default path is usually something like C:\Users\[YourName]\AppData\Roaming\Microsoft\Excel\Recovery. You can also search for .xlk files on your computer to find all backup copies.

Does disabling auto backup improve Excel performance?

Yes, disabling auto backup can improve performance, especially if you work with large files or have limited storage. Auto backup creates additional file writes every time you close a file, which can slow down the save process. Turning it off reduces these background operations and can make Excel feel faster.

Is it safe to delete old Excel backup files?

Yes, it is safe to delete old Excel backup files as long as you have a recent copy of your work saved elsewhere. Before deleting, make sure the backup file is not the only copy of any important data. If you are unsure, move the file to a separate folder instead of deleting it immediately.