N/APosted on - 05/22/2015
Urgent help needed. I had a full excel document sheet with several sensor data. After several calculations I had plotted all of them in Excel. Due to power loss, the Computer turned off. But after turning on the computer what I can see is only a zero sized file. It is totally gone. The size was 2 mega bytes. I searched in temp folder but I could get the file. I cannot imagine redoing all the calculations as it takes not only time but also patience. I am totally lost in searching the file. Does MS excel keep backup? If yes how to access those files? Please help me quickly and get me out of trouble.
Help needed to recover MS Excel file after system crash
Excel has long had an AutoRecover feature that's designed to help you recover unsaved workbooks should Excel crash. If any version of Excel crashes, you sometimes get the opportunity to recover at least some of your work from the Document Recovery pane. However, this feature is limited to spreadsheets that were open in Excel at the time the program or your computer crashed.
When you make a blunder that you can't undo, or when you want to see how a workbook looked a few minutes earlier. To do so, choose File, Info, and then look for the Manage Versions button if previous versions are shown, you can open these alongside the most current version of your workbook and copy and paste data between the workbooks as needed.
In any version of Excel, you should carry out the following steps to increase the odds of being able to recover unsaved work:
• Excel 2010 and later: As shown in Figure 3, choose File, Options, Save, and then change the Save AutoRecover Information setting to every two minutes, down from the default of every ten minutes.
• Excel 2007: Click the Office button, choose Excel Options, Save, and then change the Save AutoRecover Information setting to every two minutes, down from the default of every ten minutes.
• Excel 2003 and earlier: Choose Tools, Options, click the Save tab, and then change the Save AutoRecover Information setting to every two minutes, down from the default of every ten minutes.