How do I Recover an Overwritten Excel File?

Written by pat smith
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How do I Recover an Overwritten Excel File?
Recovering overwritten documents in Excel should take about half an hour. (computer image by blaine stiger from Fotolia.com)

Excel is a spreadsheet program distributed by Windows for Macs and PCs. It is used for budgets, financial documents, charts and timetables. Overwriting happens when new data is saved over an old file. This commonly happens if the program or your computer crashes while a document is open. The new information is saved automatically and retrieved when you reboot, but without the ability to undo or go back to old information. This situation can be remedied by recovering the overwritten document.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Locate the document that overwrote the old one you want to retrieve. Right-click the file name, then select "Rename." A box will pop up with the file name. Add the word "new" or today's date to make it easier to tell it apart from the file you want to recover. Once you've edited the name, click "OK" or "Continue."

  2. 2

    Download XLS Regenerator (see "Resources"). This program is made specifically to recover Excel files. Start with the free trial by clicking "Free trial" on the main page, then following the instructions to download for your operating system. Once it's downloaded, double-click on the icon to install.

  3. 3

    Run the program XLS Regenerator by double-clicking on the icon once it's installed. When the main screen pops up, select "Recover files," then "Recover overwritten files." The program will now ask for information on the file to be recovered. If you remember the date it was last open, select the date. Then type in whatever you remember from the file name. Click "Start."

  4. 4

    Wait for the program to search your computer for overwritten files. Usually this is in the form of an automatic save--often a hidden file--made before the first overwrite. When it finishes searching, look at the list for the document or documents you want to retrieve. Select all of the documents you want (avoiding the newly named file from step 1) and click "Retrieve" in the lower right corner.

  5. 5

    Move the retrieved files to a new folder once they've finished. Open each file to see if it has the correct information you need. If not, repeat steps 3 and 4 with different search parameters until you locate the overwritten documents.

Tips and warnings

  • Backup and save your data often to avoid losing files.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.