Comments on: How to recover unsaved Excel file or restore its previous version

Do you want to protect your workbooks from unexpected computer crashes or power failures? This article explains how to recover unsaved files and restore previous versions of your workbook in Excel 2016 - 2010. You'll also learn different ways of file backup to your PC and to the cloud storage. Continue reading →

Comments page 7. Total comments: 162

  1. Fucking God fuck God it didnt god damn work!

  2. Thank you very much for this magic!

  3. Hi, today the 17th/Feb/2015 I have exported a report from SAP "Accounting package" and it happened that after hours working on it I remember saving it however I got frustrated when reopened at 7:31pm the Excel file prior to my email sending because it had lost its layout, feature and sheets are missing. It appears to me that I have tried your tips above but could not recover my original Excel file yet in MSO Excel 2010 apparently due to an older version (2003 or 2007) issue. PLease help me recover important document. Thanking you in advance

  4. I saved an updated document but some how kept the original document without the corrections. How do I retrieve my resent updates or can I.

  5. Greetings!

    My excel file crashed and the auto-recovery does not worked and when i clicked on the recent file i got this message that it has been remove or deleted but there's no traced of that in my trash bin. Are there any other way to recover this file? thank you very much.

  6. To day (3-1-2015)I worked for 2 hours and prepared a work sheet. Unfortunately I exited without saving. Is there a chance to recover the file?

  7. thanks for the amazing help, it just saved my day. I had accidentally deleted the excel sheet and stumbled for help on internet and came across this site. Your solutions just saved my days. God bless.

  8. Hi,

    Is there anything I can do if I have by accident clicked saved on a document and retrieve the information before I saved it??

    Many thanks.

    Helene

  9. I was working on an Excel file and kept clicking the disk button in the top left corner of Excel to save my work. It still did not save. When I re-opened the file, all my new work was gone. I've checked the Recover Unsaved Workbooks and there is nothing there. Is there something wrong with Excel? Is my work permanently gone? Why didn't it save my work? Please help and thanks in advance.

  10. Does turning the calculations to manual disable autosave/autorecover? Usually my Excel session autosaves my work, so I rely on it, but I had a crash yesterday and lost over 2 hours work. When I reopened Excel there was no autosaved or recovered version despite me saving the document at least once. Then I remembered that I'd set the calcs to manual, would this explain this?

  11. Thanks you so much.
    My important excel data file close without saving.
    I so worried and didn't know what to do.
    When i read your post, i very happy and i get my data back.
    I really thanks you.

  12. when i try to go in and manage/view older versions of my file, all i see is There are no previous version of the file can someone tell me is there any chance to recover the data

  13. I just opened a file that I haven't looked at in months. Significant amounts of data are missing! (It is a monthly income/expense sheet) I searched the computer and recycle bin to make sure I didn't somehow come across a different one I had started. I have printouts of the months I had completed so I know it exists. I tried looking in the two locations in your article to no avail...

  14. Hi From NZ. Im frustrated - I have MS Excel Starter. I have set AutoSave at 2 mins several times over the year. When System crashes or power cut, I look through to retrieve files but nothing at the location I am advised it is save to. I have gone through several instruction sites, and its confusing as they tell you different ways, none of which work. Im wondering if Excel Starter just doesnt auto-save consistently. Would appreciate some concrete advice that could not only accurately set up saving, but easy and consistent retrieval! Many thanks.

  15. Hi recently I copy from mu usb a file which I updated 30.12.2013 and name was the same name . but my wife has done some new data entering to the file already was in my lap. when I copy file from usb other file my wife was working has replaced and after copy the file from usb I worked on that file for few days. now I need the file which my wife was working on .can I recover it? I used recuva software but not found. please help me.

    1. Disk drill software may help u. It works for me. ?

  16. Excel crashed

    reopened - whilst files was there
    edited what it had lost, but before I could save excel closes with no warning
    no option to recover or anything
    excel 2013

  17. Hi ! How about if I have a saved excel on my pc, then I have a backup portable drive that i have connected to my pc. I transferred the files on my Portable drive then it asked me if i want to merge the folders and files, without thinking i clicked YES. now my updated excel was overwritten and it went back to July 2014. Is there a way for me to restore it? Thank you

    1. I am having the same problem...Can anyone help...?

  18. That was really really GREAT.
    Thanks

  19. when i try to go in and manage/view older versions of my file, all i see is 1 version only, the last one i saved. I was hoping to have older versions to choose from since the last time i saved my file, all of my sorting and such was out of wack! can someone tell me why i am not seeing older versions of my file that i can choose from to pick an older one... a version that was correct before i saved the last incorrect version...

  20. I am trying to recover an excel workbook and followed the instructions above, but I got the message that there are no unsaved versions? Id that possible?

  21. THANK YOU!!!! I just closed a document accidentally after hours & hours of work & when I re-opened the only thing that was there was the work I saved forever ago. Thanks to this article, I was able to recover my document with all my recent work. What a lifesaver!! Stick a fork in me, I'm done for the night but Ekaterina..bless you.

  22. I was making adding more data to a previous excel workbook and my computer froze. I had to turn off the computer. However, my excel file did not recover and did not show as previous version of the file.

    1. You are correct. The Autorecover feature in Office is limited and not foolproof. Furthermore, it doesn't function entirely the way it is supposed to. I have done extensive tests. I set the Autorecover to 1 minute. I saved my worksheet. Added some data. Waited a few minutes. Crashed Excel. Reopened it. And I got the choice to recover it. Good enough. I immediately added more data. Waited 2 minutes. Crashed Excel. Reopened it. Only option was to open from last save. Tried all other options to recover unsaved work. None worked at all.

      Office used to have an autosave feature that worked. But it got traded in for a hybrid feature that fails. Many business offices will work all day entering data without saving anything. Yes. Chances are the autorecover will save "something". But there is a good chance that under a crash some of that work will be missing when you try to recover it.

      Common sense tells me that an actual AutoSave function with user friendly settings make securing data easy. Most programs have it. Office does not. Some idiot at M$ decided to screw up a good thing. And this is not unusual for M$ to do that. If it weren't for hackers and IT developers, their software would not work at all. I don't know what they put in the water at M$, but their developers are of the worst kind. Just ask any M$ certified "genius" for help over at the M$ forums. You will notice that they rarely solve problems. But go to other websites and find your answers. Just like this one.

      1. Thanks... this really help restore my accidental mistake when I close my work without saving it. Thanks

      2. Thank you, Joe. That's why we published this article to describe at least some of the peculiarities.
        Before the built-in Autosave feature appeared, there were add-ins that periodically saved a backup copy of your file with timestamp. When the Autosave feature was added to Excel, the development of such add-ins stopped.
        We have been working with Office for a long time and instinctively press Ctrl + S after entering another portion of data :)

  23. I did it several times before and, today I closed the file after working of it for 3 hours and dint saved it. Thanks to auto recovery system it saved me lots of time.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)