Tuesday, 8 April 2014

MS Excel spreadsheet is quite popular application due to its ability of storing and maintaining massive data. Also, it facilitates the users to perform different operations on that stored data. Such a crucial file containing long list of facts and figures if somehow undergoes corruption then it could be a brutal blow for its users. But there are some manual ways using which the accidentally deleted or unsaved excel files can be recovered. Now, first let us go through the reasons that are behind such mishaps and the manual as well as technical ways to deal with this problem. 

Reasons that could lead to loss of MS Excel Worksheet:
Sometime or the other, many of you must have encountered the situation of accidental deletion of your excel files or closing of the file without saving the data due to sudden unfavorable circumstances. Common reasons for occurrence of such situations remain the unexpected power failure, crashing of hard disk, turning off storage media while the writing process is going on, etc. But every problem has a solution. Here are some ways how you can get rid of this mishap.

Manual ways to recover the accidentally Unsaved/Deleted Excel sheet:
If somehow you have closed your MS Excel spreadsheet without saving it or have by mistake deleted your crucial excel file then here are some ways how you can get hold of them yet again:
Method 1: 
Step 1: Launch the Office 2010 application
Step 2: Now open an already existing MS Excel file or a new Excel file
Step 3: Click the drop-down File menu -> Info -> Manage Versions
Step 4: Here select Recover Unsaved Workbooks
Step 5: In the pop up window, there will be a list of unsaved files from where you can open the one you were looking for and then save it.
Method 2:
Step 1: Launch the Office 2010 application
Step 2: Click the drop-down File menu -> Recent
Step 3: Now click on Recover Unsaved Workbooks
Step 4: The saved drafts folder get opens up with all the files in a pop-up window. Choose the file and click on Open button and then save the file by using Save as option. 
Warning: Sometimes the manual process of recovering the unsaved or deleted Excel file takes up much time and effort. 
Limitations of Manual ways in restoring MS Excel files:
Usually, the manual ways of recovering the Excel files work only to restore the unsaved or accidentally deleted Excel worksheets. But in cases of major issues like fragmented partition structure, round tripping, virus attacks, intrusion of bad sectors in the storage media, damaged file headers, etc. the manual ways might not help. In such a situation, the need of a commercial excel file recovery software might crop up. 

Other way round to resolve the Problem:
When the unsaved or deleted excel files are not recovered using the options available within the MS Excel application then Kernel for Excel Repair software comes to your rescue. By using this utility, the users can get access to the Excel file that somehow was left unsaved or was accidently deleted. It facilitates the users to repair excel files- either one by one by using Single File mode or by recovering multiple files at a time by using Multi File Mode. After recovery, the software displays a preview of the recovered excel files in a tree-like hierarchical structure. Visit here : http://www.repaircorruptexcel.com/

28 comments:

  1. This says worksheet at the top, but it seems to be referring to a workbook. I am trying to recover inadvertently deleted worksheets from an unsaved workbook.

    ReplyDelete
  2. Sir,in emergency i have deleted some of rows and without see i saved excel sheet.
    Can i get back those deleted rows.?

    ReplyDelete
  3. Hi Ravi,

    You may try giving instruction: -

    1: Right-click the Excel document --> click Properties --> Click Previous Versions tab.

    2: Select a version of the Excel document --> Click the "Restore" button --> replace the existing Excel document --> Save

    ReplyDelete
  4. sir , accidently i have deletes one sheet from my excel file there are three sheets. but i have lost sheet 1. what can i do ..?

    ReplyDelete
    Replies
    1. @Imtiaz have you got the solution on a deleted sheet?? if Yes pls share it with me. thanks

      Delete
    2. @Imtiaz have you got the solution on a deleted sheet?? if Yes pls share it with me. thanks

      Delete
  5. great, works well for me! thanks for sharing!

    ReplyDelete
  6. Is it possible to recover whole excel files in any way if the whole disk is formated.
    Tahir

    ReplyDelete
    Replies
    1. Yes, it is possible to recover whole excel files in any way if the whole disk is formatted.

      Kernel for Windows Data Recovery tool helps you to recover files after delete, format by mistake or when Disk is formatted. Read more : http://goo.gl/vZqxSQ

      Delete
  7. Thank you, so much! It saved hours of work!

    ReplyDelete
  8. how to reopen reopening will cause any changes made to be discarded excel

    ReplyDelete
  9. how to recover a deleted tab (sheet)

    ReplyDelete
  10. how to recover a deleted tab (sheet)

    ReplyDelete
    Replies
    1. I am not sure, but you can try such solution:

      When you are accidentally lost a sheet, there is no Undo option to bring it back. One option too close your workbook without saving the changes and then re-open it in its original old state.

      Delete
  11. hi,
    accidently to make fresh sheet for next month, I deleted data from spreadsheet but it was actually for the current month's only sheet. I pressed the save button and also closed the excel sheet alto gather. please give me solution to recover those data

    ReplyDelete
  12. the data not showing in excel sheet but the data is available in the sheet so please let me know how to recover the data in same sheet

    ReplyDelete
  13. My excel file has been corrupted. it's not open given the error again after than i rename the excel file name & extension file. after open the excel sheet but i have lost the all data, please help it's urgent

    ReplyDelete
    Replies
    1. Repair your corrupted excel file with the help of
      1. Open and Repair inbuilt tool or
      2. Paid recovery tool.

      Delete
  14. I open a file, minimize it, reopen the same fie again. Later I realised I have opened same file twice. I x check first file and the below message appears "abc.xlsx is already open. Reopening will cause any changes made to be discarded. Do you want to reopen abc.xlsx?" If i choose yes and all the data lost. How to solve this issue?

    ReplyDelete
    Replies
    1. Select Cancel and save your all data

      Delete