Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Lookup entire row in Excel
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to get first row number in range in Excel
  • How to get address of named range in Excel
  • How to use Excel LOOKUP Function

Data Analysis Examples

  • Conditional Formatting Rules in Excel
  • How to create a Histogram in Excel
  • How To Create Frequency Distribution in Excel
  • Example of COUNTIFS with variable table column in Excel
  • Get column name from index in Excel Table

Data Validation Examples

  • Excel Data validation date in specific year
  • Excel Data validation require unique number
  • Excel Data validation don’t exceed total
  • How To Create Drop-down List in Excel
  • Excel Data validation allow weekday only

AutoRecover file that was never saved in Excel

by

Excel periodically saves a copy of your Excel file. Learn how to recover a file that was never saved and how to recover a file that has been saved at least once.

If Excel crashes, it displays the Document Recovery Pane, the first time you open Excel again. This is a quick way to recover the last autosaved file.

File that was never saved

If you’ve never saved a file and you accidentally click Don’t Save below when you close Excel (or Excel crashes), execute the following steps to recover the last autosaved file.

Worked Example:   List worksheet index numbers in Excel

Note: Excel tells you if a recent copy will be available.

1. On the File tab, click Info.

2. Click Manage Workbook, Recover Unsaved Workbooks.

3. Click the last autosaved file.

Saved at least once

If you’ve saved a file at least once and you accidentally click Don’t Save below when you close Excel (or Excel crashes), execute the following steps to recover the last autosaved file.

Worked Example:   Save As in Excel Explained

Note: Excel tells you if a recent copy will be available.

1. Open the Excel file!

2. On the File tab, click Info.

3. Under Manage Workbook, click the last autosaved file.

Versions

When you are working on an Excel file, Excel saves all previous autosaved files under Manage Workbook.

Worked Example:   Create dynamic workbook reference to another workbook in Excel

1. On the File tab, click Info.

2. At any time, you can go back to a previous version of your Excel file.

Note: Excel deletes all previous autosaved files when you close the Excel file.

Options

To change the AutoRecover options, execute the following steps.

1. On the File tab, click Options, Save.

Note: you can save AutoRecover information every x minutes, change the AutoRecover file location, etc.

Post navigation

Previous Post:

View Multiple Workbooks at The Same Time in Excel

Next Post:

Save file in 97-2003 Format

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to extract text between parentheses in Excel
  • NUMBERVALUE function: Description, Usage, Syntax, Examples and Explanation
  • How to check cell contains which things in Excel
  • How to count keywords in a range of cell
  • How to check if cell contains one of many things in Excel
  • Extract date from a date and time in Excel
  • Find Last Day of the Month in Excel
  • Get days, hours, and minutes between dates in Excel
  • TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Convert date to Julian format in Excel
  • DDB function: Description, Usage, Syntax, Examples and Explanation
  • PRICEDISC function: Description, Usage, Syntax, Examples and Explanation
  • Example of Future value of annuity in Excel
  • RECEIVED function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan interest in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles