How to Recover a Deleted or Unsaved File in Microsoft Excel

  • MORE

Accidentally deleting a file you’ve spent hours working on -- or worse, collaborating on with several others -- is never an easy pill to swallow. Luckily, Microsoft Excel has an excellent file recovery tool that often helps you to recover these accidentally deleted documents if you can’t just pull it out of the Recycle Bin.

hero

A word of warning though: this isn’t foolproof, and it doesn’t always work. Saving regularly and backup up these saves to the cloud is always a better bet.

1. Open a blank Microsoft Excel document and click the File tab.

file2. Click the Options link at the bottom.

options3. Choose the Save option from the left.

save4.Once you find the section with a path showing where your autosaved documents go, select and copy it. In my case, it’s here: C:\Users\Bryan\AppData\Roaming\Microsoft\Excel\

path

5. Open File Explorer and paste in the copied file path. Hit enter.

paste 3185191507326351

6. Here, we’ll see the last save of the document I was working on, which starts with the name “MYDOC.” Click it to open the file.

open

7. Right click the Microsoft Excel Binary file, and select Open with.

right click

8. Choose Excel, and click Ok.

open excel

Add a comment
9 comments
  • Charles Donald Says:

    I LOVE YOU!!!!!! I had made a lot of changes to an Excel doc and lost it - but your site told me what to do and it worked! Thank you so much!!

  • Sarah Says:

    I don’t know who you are- but I love you! Just saved me hours!

  • Sharon Numerow Says:

    Thank you x a million for the where to find your autosaved file
    you saved me so much time

  • Sarah Edwards Says:

    Bloody brilliant, I accidentally said no when asked if I wanted to save auto recovered files. There was 2 weeks worth of work! PHEW

  • Titilayo Says:

    Thank you sooooo much! Whew! This was very helpful😄

  • Sagar Roy Says:

    Wow, thanks a lot for help for the help

  • Celina Beach Says:

    BRILLIANT! Just saved me an entire DAY'S WORTH of work!!

  • abcabc Says:

    Thank you so much! Saved my life!!

  • Bruce Says:

    Hi,

    Since yesterday i have been working on an excel file but today morning suddenly laptop get shutdown due to low battery. After turning on the laptop the file was not at its location. I searched on all the partition for the the excel file but found nothing. Had also tried the Autosaved option but it didn't worked for me. Finally i downloaded the Stellar free data recovery software and it successfully recovered my file.

Back to top