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 5. Total comments: 162

  1. Then method for "How to recover unsaved Excel files" does not work for Excel 2010.

  2. on my gmail account I have an existing excel which I have an information that is lost due to my phone crash. how do i recover the lost information please help.

  3. i opened an already open document in excel and lost all the information i had written. please help

  4. i opened an already open document in excel and lost all the information i had written. please help

  5. Thank you so much

  6. thank you.

    no words you saved me hours of work

    be blessed

  7. Thanks. It worked for me.

  8. Hi,
    My excel crashed yesterday. I managed to recover the file (didn't loose any of my last changes, which is a first). Clicked on the RESTORE button and continued working on my file. This time pressing save regularly. I saved the file last night before closing it.
    This morning I wanted to continue on the file only to find out that the file is back to the state as yesterday morning. All my work of yesterday is not there (I guess I wasn't lucky after all).
    Is there a way I can find all my work back? I did a file search on my PC in case excel has stored my latest version somewhere else but nothing.

    Thanks!

  9. There is no "option" button under the file menu on Excel.

  10. Can I find the recovery files?my file was crashed.but I cannot find the recovery file.autosave is on.

  11. Loved you.
    Thanks for share such great support!

  12. Thank u so much.......

    You saved my lot of time and effort __/\__

  13. Hello. Is there a way to edit profanity, such as what appears in the previous comment? Thanks

  14. Fuck Excel

  15. I made a file in excel but my PC had suddenly shut down due to power. After that when I opened the file again, I lost entire format of the file. The days format become in numbers, borders disappeared etc. How can I restore the file with earlier format? Please help.
    Sandeep

  16. I am very grateful I found this it helped me recover very crucial work data.

  17. Thank you! Thank you! Thank you! You may have just helped me save my job.

  18. I have opened my records in excel to up date but when double click the key board or pad doesn't appear as usual.Help me.
    There is an idencation at the top!only reading.
    Urgent.
    Jackson.Thanks.

  19. Please,help retrieve my info.my tablet went off and l have lost very thing though l saved them.
    Jackson Thank

  20. Do me a favor please retrieve my info for me.it very long record 2016.

    Thanks

  21. Thanks a ton Ekaterina, you saved my life with this article....

  22. Hi,

    I want to check if I can recover an excel file which was stored in Onedrive but was showing an error message and when I clicked on the message I was asked to click on the version I wanted to save. I clicked the latest one. But somehow I lost the data and the copy saved was of a previous version. Is it possible to recover the latest copy of the document?

  23. Thanks! Your article saved me from having to redo a lot of work.

  24. Thank you so much, this (recover overwritten excel file) has saved me hours of rework!

  25. i found it!! THANK YOU SO MUCH!

  26. Thanks Ekaterina. Appreciate the tutorials. But I am still in a fix here.
    I accidentally answered "yes" to the prompt that you no longer need access to excel files on my auto recover pane (which popped up as you explained after power outage). I have spent ample time populating this spreadsheet. Can you help guide me please? Its a Microsoft excel 2010 document

  27. AWSOOOOME

    Saved the "save error" file. It gave my 4 hours back.

  28. *******************HELP**************
    My computer crashed and I lost an important excel document. AUTOSAVE did not save my document. I know it was working. Can I find the lost file anywhere.

    using office 2013

    Thanks

  29. After working for hours in Excel - my laptop crashed and I cannot locate the document that I was working on. I've tried the above steps....but, nothing is working. Is there another explanation of where this might be.?

  30. How can I retrieve a a version that has not been saved. The copy has been overwritten by a new version I opened. I have tried file info, manage versions and there is it a latest version other than the one I have opened.

  31. Morning i have worked that excel sheet in Server.After Excel sheet evening not opened.Please help me.

  32. Thank you!!!

  33. thankyou guys what a great feature i was panicing and thought i had lost my spreadsheet.

    Great information thankyou

  34. Hi, yesterday i m making salary sheet in my excel file.next day morning my friend replace my all data in my file, & their data add ,please give me suggestion ,hw to come my data????

    1. Today I was working on an excel spread sheet entering data, the data i entered on one spread sheet was duplicated in another sheet sheet in which the original data was wiped out, How could this be...what did I do wrong?

  35. Thank you for saving my life! I almost cried after I accidently closed an excel file without saving it....I worked on it for hours.... thanks!!!!

  36. Thank you so much for this article! It saved me from losing a lot of work. I can't thank you enough!

  37. I closed down an unsaved file and was able to get it back. Thank you.

  38. hey! just so you guys know, this method works for me when under 'manage versions'show up nothing at all and i just can't seem to find the autosave file anywhere!

    no worries!

    continue to use the search option but search your file name under Computer, and it should be under the folder Users\XXX\Appdata\Microsoft\Roaming\....something like that! It should work for any word file, not just excel.

    Cheers!

  39. I did some modification on some excel sheets few weeks back while the files are on an external hard drive. But unfortunately my system got turned off due to some updating process, and I couldn't save any documents.

    I recovered several files from the auto recovery option but not all the files. After 2 weeks I need those updated files I couldnt save.

    What can I do

  40. Autosave doesn't work for me either :(

    AND cannot copy and paste from the excelbee website, the VBA code from the link given above (http://www.excelbee.com/create-backup-copy-of-a-workbook-in-excel-2007-2010-2013#close).

    Nice of them to tell us to "Just Paste the code into your VBA editor" then lock down the page so you can't actually copy it from the page. :/

    AND the bit of code (Macro) that they graciously give us is password protected so you can't modify the folder location there either.

    Totally possible it's just me. But I tried in 3 diff. Browsers and even tried in the "Developer" console.

    I guess I could just type it all in.
    Why does everything have to be so hard!

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

  42. Thank you very much for this magic!

  43. 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

  44. 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.

  45. 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.

  46. 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?

  47. 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.

  48. 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

  49. 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.

  50. 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?

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 :)