Scribd Logo
Upload

Welcome to Scribd!

  • 30 views

    Excel Recovery

    Uploaded by

    Chindhi Laal
    Excel provides several options to recover unsaved or overwritten workbooks. The AutoRecover feature automatically saves workbooks every few minutes if enabled, allowing recovery after a crash if the file has been previously saved at least once. For completely unsaved workbooks, the Recent menu has an option to recover unsaved workbooks from the current session. Excel also keeps track of previous versions when files are auto-saved, allowing recovery of overwritten data from within the past session. Taking regular backups by saving alternate copies of workbooks with a different file extension also allows recovery of older versions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Excel Recovery

    Uploaded by

    Chindhi Laal
    30 views2 pages
    Excel provides several options to recover unsaved or overwritten workbooks. The AutoRecover feature automatically saves workbooks every few minutes if enabled, allowing recovery after a crash if the file has been previously saved at least once. For completely unsaved workbooks, the Recent menu has an option to recover unsaved workbooks from the current session. Excel also keeps track of previous versions when files are auto-saved, allowing recovery of overwritten data from within the past session. Taking regular backups by saving alternate copies of workbooks with a different file extension also allows recovery of older versions.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Excel provides several options to recover unsaved or overwritten workbooks. The AutoRecover feature automatically saves workbooks every few minutes if enabled, allowing recovery after a crash if the file has been previously saved at least once. For completely unsaved workbooks, the Recent menu has an option to recover unsaved workbooks from the current session. Excel also keeps track of previous versions when files are auto-saved, allowing recovery of overwritten data from within the past session. Taking regular backups by saving alternate copies of workbooks with a different file extension also allows recovery of older versions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    30 views2 pages

    Excel Recovery

    Uploaded by

    Chindhi Laal
    Excel provides several options to recover unsaved or overwritten workbooks. The AutoRecover feature automatically saves workbooks every few minutes if enabled, allowing recovery after a crash if the file has been previously saved at least once. For completely unsaved workbooks, the Recent menu has an option to recover unsaved workbooks from the current session. Excel also keeps track of previous versions when files are auto-saved, allowing recovery of overwritten data from within the past session. Taking regular backups by saving alternate copies of workbooks with a different file extension also allows recovery of older versions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    HOW RO RECOVER EXCEL DATA

    Imagine you had been working on a really important Workbook for hours and the system crashes. The file
    is not saved, and you just lost hours of work because you forget to hit the save button.

    But what about when you realize that you made a mistake while working on the workbook an hour ago?
    How do you go back to an older version of the Excel file?

    Well, don’t panic because we have compiled together some of the most efficient tips to recover unsaved
    Excel files and their older versions.

    By default, Microsoft provides an AutoRecovery option which can recover files that were saved, but their
    latest version cannot be accessed because the system or Excel crashed.

    Configure the AutoRecover Settings in Excel


    1. Go to the File tab and click on Options
    2. Click on the Save tab
    3. Make sure both ‘Save AutoRecover information every Z minutes’ and Keep the last autosaved version if I
    close without saving’ are checked. You can also keep the autorecover duration to the smallest to make sure
    every file is saved
    4. Click on OK
    After this, whenever you open Excel after a crash, you will be able to see the files that can be
    autorecovered. But, this only applies to files that have been saved at least once. For files that haven’t
    been saved at all, follow the steps in the next section.

    Recover unsaved Excel file 


    In order to recover an Excel file that you forget to save, follow the steps below

    1. Go to the file tab and click on ‘Open’


    2. Now click on the Recent Workbooks option on the top left
    3. Now scroll to the bottom and click on ‘Recover Unsaved Workbooks’ button
    4. Scroll through the list and search for the file you lost.
    5. Double-click on it to open it
    6. The document will open in Excel, now all you have to do is hit the Save As button
    Recover overwritten Excel files
    If you are using Excel 2010 or 2013, then you can easily recover an older version of the document. It is
    extremely helpful if you made a mistake on the Workbook and realized it late or you just want to see what
    the workbook looked like before.

    To do this, here are the steps you need to follow


    1. Click on the File tab and select Info
    2. Now click on the manage versions tab. There you will be able to see all the versions that were autosaved by
    Excel
    But you can also see these autosaved versions until you have saved the file. Once the current version of
    the file has been saved, all the previous autosaved files will disappear. To save them, you need to take
    the backup of the file.

    Saving a backup of Excel file


    Taking a backup of Excel files makes it possible to revisit older versions in case you made a mistake. This
    can be useful when you hit the save button when you didn’t mean it or when you delete the main original
    final.

    Here is how you can take a backup in Excel 2010 and 2013

    1. Go to the File tab and click on ‘Save as’


    2. Now click on the Browse tab at the bottom
    3. A Save as window will open up. At the bottom of it, there is an option called Tools
    4. Click on Tools and select ‘General options’
    5. In the new Window, check on ‘Always create backup
    Now every new Excel file that you create will have a backup file associated with it. But remember that
    backup Excel files have a different extension – .xlk

    Overall, it’s very easy to recover Excel files even when you forgot to save them. All you have to do is not
    panic and follow the steps we mentioned.
    Share this:

    You might also like