Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Working With Tables in Excel
  • How To Create Pareto Chart in Excel
  • How To Compare Two Lists in Excel
  • Conditional Formatting Icon Sets Examples in Excel
  • Excel Frequency Function Example

References

  • How to use Excel ROW Function
  • Extract all partial matches in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • To count total rows in a range in Excel

Data Validations

  • Excel Data validation must not contain
  • Excel Data validation must begin with
  • Prevent invalid data entering in specific cells
  • Data validation must not exist in list
  • Excel Data validation require unique number

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.

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.

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.

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:

VLOOKUP without #N/A error in Excel

Next Post:

Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel

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

Logical Functions

  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel FALSE Function
  • How to use Excel NOT Function
  • Invoice status with nested if in Excel
  • Excel If, Nested If, And/Or Criteria Examples

Date Time

  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation
  • Get age from birthday in Excel
  • Calculate years between dates in Excel
  • Get work hours between dates in Excel
  • How to get number of days, weeks, months or years between two dates in Excel

Grouping

  • Group times into 3 hour buckets in Excel
  • Group numbers with VLOOKUP in Excel
  • Map text to numbers in Excel
  • Categorize text with keywords in Excel
  • If cell contains one of many things in Excel

General

  • Using Existing Templates in Excel
  • 44 Practical Excel IF function Examples
  • How to calculate percent of students absent in Excel
  • With vs Without Array Formula in Excel
  • Convert column letter to number in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning