Skip to content

Overwrote an Excel or Word file: how to restore the old version

Easy 15 min Updated:

Quick answer

If you overwrote a Word or Excel file, first check whether the document is saved in OneDrive or SharePoint, where version history exists. Then check AutoRecover and the Compare Documents option in the program itself, and finally look for a copy in backup or in previous versions of the folder on Windows.

How to recognize the problem

  • The file opens, but the content is replaced with new or empty text
  • You saved the document over the old name and the old version disappeared
  • Word or Excel was closed without saving, and the changes were lost
  • There is only one, the latest version of the file in the folder
  • The file is on a network drive or in a cloud folder, and the old version is not visible

Most common causes

Saving over the same file

The most common scenario: you open a document, delete the content and press Save. The program faithfully writes the new state over the old one.

Version history not enabled

If the file is not in OneDrive, SharePoint or on a disk with shadow copies, the system has nowhere to remember previous states.

AutoRecover did not save a copy

Word and Excel make temporary copies, but they are deleted on normal close or if the option is turned off.

Backup does not cover that folder

File History or cloud backup may not include the folder where the file is located, so no copy exists.

Step-by-step fix

  1. 1

    Check version history in OneDrive

    If the file is in OneDrive, open OneDrive in a browser at onedrive.com, right-click the file and select Version history. From the list, choose a version from before the mistake and click Restore. The same applies to files in SharePoint libraries.

  2. 2

    Restore a previous version from Windows

    In File Explorer, right-click the file and select Properties > Previous Versions. If the list is not empty, click Open to check the content first, and if the version is correct, save it under a new name. The Restore option overwrites the current file, so use it only when you are sure. This option works only if restore points or volume shadow copies are enabled.

  3. 3

    Look for an AutoRecover copy in Word

    Open Word and some document (an empty one will do), then go to File > Info > Manage Document > Recover Unsaved Documents. If a list appears, open the latest copy and save it under a new name. In Excel, open a workbook and go to File > Info > Manage Workbook > Recover Unsaved Workbooks.

  4. 4

    Check temporary files

    Open File Explorer and type %appdata%\Microsoft\Word or %appdata%\Microsoft\Excel in the address bar. In the Word folder look for .asd, and in the Excel folder for .xlsb; both may also contain .tmp files. Open them from the program via File > Open (not by double-clicking), if Word or Excel recognize them. This is useful if the program crashed before saving.

  5. 5

    Compare with a copy if you have one

    If you have an older copy of the same document, open it and in Word go to Review > Compare > Compare Documents. Select the original and the changed version to see what was lost, then manually copy the missing parts.

  6. 6

    Restore the file from backup

    If you use File History, open Control Panel > System and Security > File History > Restore personal files and find the folder with the document. For cloud backup (e.g. Microsoft 365 Backup or a third-party solution), look for the single file restore option in the web console.

  7. 7

    Save the recovered version under a new name

    When you find the correct version, immediately save it as a new file, for example Report_v2.docx, so you do not overwrite the original again. Only after checking can you replace the main file.

If nothing helped

When there is no version history, AutoRecover copy or backup, what remains is searching the disk to find remnants of temporary files. Data recovery tools can find deleted .tmp, .asd and .xlsb files, but the more time has passed and the more was written to the disk, the lower the chances. Before any recovery, stop saving new files to that disk. For business documents, also check whether one of your colleagues had a copy in email or on a shared drive. Long term, enable version history in cloud storage and regular backup, as that is the most reliable protection against overwriting.

How to prevent it

  • Keep important documents in OneDrive or SharePoint where version history is enabled
  • Enable File History or cloud backup for folders with documents
  • Before major changes, save a copy under a new name or date
  • Check that AutoRecover is enabled in Word and Excel and set the interval to 5 minutes

When to call a professional

If the document contains important business data and there is no backup or version history, it is better to contact IT support before attempting disk recovery yourself, because wrong steps can permanently overwrite data.

IT infrastructure maintenance · Servers, networks, backup, security and helpdesk

FAQ

Can I restore a version if the file was not in the cloud?

You can if previous versions of the file exist on Windows or if you had File History enabled. Otherwise, what remains is an AutoRecover copy or recovery of temporary files, which are not guaranteed.

How long does OneDrive keep old versions?

OneDrive usually keeps version history for up to 30 days for standard accounts, and longer with an appropriate license or administrator settings. That is why it is important to act immediately, while the version still exists.

Is it enough to press Ctrl+Z?

Ctrl+Z undoes the last change while the document is open, even if you saved it in the meantime. Once you close and reopen the file, you need version history or backup.

Share
Didn't find a fix?The AI IT assistant is available 24/7. Describe the problem or send a screenshot of the error and get instructions for your case.Ask the AI IT assistant