keepcalculator

06 Numbers and Powers

Office Backup Files: What They Are & How to Use Them

Card No. 06·18402 · Updated · Standard formula, shown below

Office backup files are automatic copies of your Word, Excel, and PowerPoint documents that Microsoft Office creates to protect against data loss from crashes, power failures, or accidental closures. When you open a backup file, you see a previous version of your document that you can recover, compare, or restore. This article explains what these files are, where they are stored, how to open them, and how to manage them effectively.

What Are Office Backup Files?

When you work on a document in Microsoft Office (Word, Excel, PowerPoint), the application periodically saves a copy of your work in the background. These copies are called backup files or autorecover files. They are not the same as the original document; they are snapshots of your work at a specific moment, usually a few minutes before the last change. If the program crashes or your computer loses power, the backup file lets you recover most of your unsaved work.

There are two main types of backup files:

  • Autorecover files – created automatically at set intervals (default every 10 minutes) while you work. They are stored in a temporary folder and are used to restore the document after a crash.
  • Backup copies – older versions of the document that Office may create when you save, if the “Always create backup copy” option is enabled. These are stored in the same folder as the original file, with a .wbk extension for Word, .xlk for Excel, and .bak for PowerPoint.

Where Are Office Backup Files Stored?

The location of backup files depends on your operating system and Office version. For Windows, the autorecover files are typically stored in a hidden folder:

  • Word: C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Word
  • Excel: C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel
  • PowerPoint: C:\Users\[YourUsername]\AppData\Roaming\Microsoft\PowerPoint

On macOS, the files are usually in ~/Library/Containers/com.microsoft.Word/Data/Library/Preferences/AutoRecovery (and similar for Excel and PowerPoint). If you have enabled the “Always create backup copy” option, the backup file is saved in the same folder as the original document, with a different extension.

How to Open and Recover an Office Backup File

If Office crashes or you accidentally close a document without saving, the next time you open the application it usually shows a “Document Recovery” pane on the left side. You can click on the version you want to recover and then save it as a new file. If that pane does not appear, you can manually locate the autorecover file and open it.

  1. Open the Office application (Word, Excel, or PowerPoint).
  2. Click on File > Open > Recent and look at the bottom for “Recover Unsaved Documents” (Word/Excel) or “Recover Unsaved Presentations” (PowerPoint).
  3. If you know the file location, navigate to the autorecover folder and open the file with the .asd extension (Word/Excel) or .tmp (PowerPoint).
  4. Once opened, immediately save it with a new name to avoid overwriting the original.

If the backup file has a .wbk extension (Word), you can open it directly in Word by double-clicking, but you may need to change the file type filter to “All Files” in the Open dialog. Excel .xlk files open in Excel, and PowerPoint .bak files open in PowerPoint. After opening, save the file as a regular document.

How to Change Autorecover Settings

You can adjust how often Office creates autorecover files and where they are saved. In Word, Excel, and PowerPoint:

  1. Click File > Options (or Preferences on Mac).
  2. In the Save category, you will see “Save AutoRecover information every X minutes.” The default is 10 minutes. You can set it to a lower number (e.g., 1 or 2 minutes) for more frequent backups, but this may slow down large documents.
  3. You can also change the autorecover file location by typing a new path in the “AutoRecover file location” box.
  4. For the “Always create backup copy” option, go to File > Options > Advanced, scroll to the “Save” section, and check the box. This creates a backup of the previous version every time you save, which can be useful for comparing changes.

Common Problems and Solutions

Even with backup files, you may encounter issues:

  • Backup file is corrupted – If the autorecover file is damaged, Office may show an error when opening it. Try opening it in a different Office application (e.g., open a Word .asd file in Notepad to see if it contains readable text). If that fails, you might need to rely on the original file or a previous manual save.
  • Backup file is not created – If you have disabled autorecover or the option is not checked, no backup will be made. Ensure that “Save AutoRecover information” is enabled in Options.
  • Cannot find the backup file – The autorecover folder is hidden by default. In Windows, enable “Show hidden files and folders” in File Explorer (View > Options > View > Show hidden files). On Mac, use Finder > Go > Go to Folder and paste the path.
  • Backup file is older than expected – Autorecover only saves every few minutes, so you may lose a few minutes of work. To minimize loss, set the interval to a lower number, but be aware that frequent saves can affect performance on very large files.

Office Backup Files vs. Cloud AutoSave

If you store your documents in OneDrive, SharePoint, or another cloud service, you also have the benefit of AutoSave, which saves changes continuously to the cloud. This is different from local autorecover files. AutoSave keeps a version history that lets you view and restore previous versions from the cloud. Local backup files are only for the current session on your device. If you work offline or do not use cloud storage, local backup files are your primary safety net.

Best Practices for Protecting Your Documents

Backup files are a helpful safety net, but they should not be your only line of defense. Here are some best practices:

  • Set autorecover interval to 5 minutes or less for critical documents.
  • Enable “Always create backup copy” for important files.
  • Save your work frequently (Ctrl+S or Cmd+S) to reduce the gap between backups.
  • Use cloud storage (OneDrive, Google Drive, etc.) to keep a copy off-site and access version history.
  • Periodically export a copy to an external drive or USB stick for long-term storage.

Frequently Asked Questions

What is the difference between a backup file and an autorecover file?

An autorecover file is created automatically at set intervals while you work, and it is used to restore your document after a crash. A backup copy is a separate file that Office creates when you save, if the “Always create backup copy” option is enabled. The backup copy contains the previous version of the document, while the autorecover file contains the most recent autosaved state.

How do I open a .wbk file in Word?

Double-clicking a .wbk file may open it directly in Word, but if it doesn’t, open Word first, go to File > Open, and in the file type dropdown select “All Files.” Navigate to the .wbk file and open it. Word will display the backup content, and you can save it as a normal .docx file.

Can I recover an unsaved Word document after a crash?

Yes, if autorecover is enabled. When you restart Word, it usually shows a Document Recovery pane listing the unsaved versions. If not, go to File > Open > Recent > Recover Unsaved Documents. You can also search for .asd files in the autorecover folder.

How do I delete old backup files?

Backup files are stored in the autorecover folder and in the same folder as your documents. You can safely delete them if you have saved your documents and no longer need the old versions. However, it is a good idea to keep a few recent backups in case you need to revert to an earlier version. To clean up, go to the autorecover folder and delete files older than a few weeks.

Why is my backup file larger than the original document?

Backup files may contain additional metadata, multiple versions, or temporary data that the original file does not have. Also, if you have embedded images or objects, the backup may store them in a less compressed format. This is normal and does not affect the quality of your document.

Related

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.

More cards in this drawer

The whole Numbers and Powers drawer →