How to Recover Deleted MS Excel File in Excel 2010?

-

Microsoft Excel is spreadsheet software in MS office suite. It is used to create and format the workbook. Workbook is a collection of several spreadsheets. MS Excel helps users in analyzing the data that is helpful for making a business decision. In order to this, user needs to protect his/her data in case of disaster. Disaster can be anything that prevents you to access your data from the workbook. Some of the popular causes of disaster are power outage, accidentally deletion, and hardware failure. All of us may face above terrible situation once in our life; therefore it make sense to be prepared to handle disaster and also need to know what should do in case of data loss.

Microsoft Excel 2010 comes with options: AutoSave & AutoRecover. AutoSave saves your data when you are working on the workbook while AutoRecover helps in recovery of accidentally deleted files. To get benefits of these options, you have to enable the options.


How to Enable the Options?
AutoSave & AutoRecover options can be enable by following steps:

  • Go to the File tab.
  • Click on the Options and select Save.
  • For AutoSave Select ‘Save AutoRecover information every x minutes’ box.
  • For AutoRecover Select ‘Keep the last autosaved version if I close without saving’ box.
How to Recover the MS Excel file?
Recovery of MS Excel file depends upon the last saved version of file.

If you have saved your file then follow below steps:

  • Open your desired MS Excel file.
  • Click on the File tab and go-to the Info section.
  • Select 'when I closed without saving' option from the Versions.
  • Now click on the Restore button to overwrite any previous changes.
If you have not saved your file then follow below steps to recover the file:

  • Click on the File tab and go-to the Info section.
  • Now select 'Recover unsaved workbook' from 'Manage versions'.
  • Now select your desired file and click on the 'Open' button to open the file.
  • Save as the file to save the file at new location.
What happen if you have not enabled the AutoSave & AutoRecover options?

Don't Worry! You can still recover your deleted MS Excel file. You can try below options:

Restore from Recycle Bin
If you have deleted your file with normal delete then your file is still present in recycle bin of your machine. Try to restore your file from there.

Restore from Mail
It may possible that you have mailed your file to someone previously so search your file from your mail. Recovered file may be very old file but you have something of your file.

Alternative Solution
There are so many data recovery companies out there that offer MS Excel file recovery software online. You can choose one of them and see what they can do for you.

Are you confused?
If it is applied for you then I will try to help you. Choose the software that meet below requirement.
  • Free Demo version – To see the preview of data.
  • Free Tech support - To get help if unable to recover the file.
  • Brand Company - It is always a better idea to get a software from Brand.
  • Lifetime License – For lifetime use with one-time payment.
  • Leader in their own field – Be-aware from the fake promiser.



Comments

Post a Comment

Popular posts from this blog

How to Fix Issues with Excel File Save

-
Sometimes users face problem in saving Microsoft Excel files. Excel shows different type of error messages while saving the file such as “Errors were detected while saving C:/Users/Filename.xlsx”, “an error message indicating the document was not saved or that someone else is using the file and can’t be saved”. You may face these types of issue while saving Microsoft Excel files if one or more of the following conditions are true. You have limited permissions to a network drive and you are trying to save an Excel file there. You do not have sufficient drive space and trying to save an Excel file to that location. While saving the Excel file, you have lost the connection to the file. Antivirus software program arise conflicts with the Excel file save. You are trying to save a shared Excel file. The path length for the Excel file exceeded than 218-characters. Excel file is damaged or some data in the file is corrupt. Here are some methods to troubleshoot Excel saving prob
Read more

How to resolve MS Access error “Cannot find the database you specified”?

-
Yesterday I had received an email from my friend regarding an error in MS Access. My friend was getting an error message due to which she was unable to open her Access file. Whenever she clicked on MS Access database shortcut to open her file, an error message pop ups on her screen. Initially I didn't understand the reason behind the error but after searching for hours on internet, I got the solution. The error was: “Cannot find the database you specified, or you didn't specify a database at all”.
Read more

How to resolve Excel error “MS Office Excel is waiting for another application to complete an OLE action"

-
Image
It is not uncommon to receive error messages in Excel. Sometime these error messages are so strange and weird that it becomes very difficult to understand them. Today I will talk about one such error in Excel. “MS Office Excel is waiting for another application to complete an OLE action.” The above error may occur when you try to open your Excel sheet. There are three main reasons for the occurrence of this error: This error may occur when you use 'Send as Attachment' option of Excel to send the Excel sheet as an email attachment. If Excel is trying to access data from an active application. You have added too many add-ins in your application.
Read more