Study guide

2.1 Workbook Versioning, AutoRecover, & File Properties

Microsoft Excel Expert Microsoft 365 Apps

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Exam Overview & MO-211 Fundamentals

1.1 MO-211 Exam Structure, Scoring, & Performance-Based Strategy 1.2 Excel Environment & Microsoft 365 Architecture

2 Chapter 2: Managing Workbooks & File Options

2.1 Workbook Versioning, AutoRecover, & File Properties 2.2 External Data Referencing & Cross-Workbook Formulas 2.3 Macro Security, Portability, & Workbook Distribution

3 Chapter 3: Workbook Protection & Collaboration Settings

3.1 Cell Locking, Range Permissions, & Worksheet Protection 3.2 Workbook Structure Protection & Editing Restrictions 3.3 Formula Calculation Options & Iterative Calculations

4 Chapter 4: Advanced Data Entry & Series

4.1 Flash Fill Patterns & Text Extraction Techniques 4.2 Advanced Fill Series (Linear, Growth, Date, & Step Configurations) 4.3 Dynamic Sequence & Random Data Generation (RANDARRAY, SEQUENCE)

5 Chapter 5: Custom Formatting & Data Validation

5.1 Custom Number Formatting Syntax & Masking Rules 5.2 Data Validation Criteria & Custom Formula Rules 5.3 Validation Input Messages, Error Alerts, & Data Circle Auditing

6 Chapter 6: Data Grouping, Summarization, & Cleansing

6.1 Data Grouping, Ungrouping, & Multi-Level Outlining 6.2 Subtotal Insertion & Summary Function Calculations 6.3 Duplicate Record Removal & Text-to-Columns Cleansing

7 Chapter 7: Advanced Conditional Formatting & Filtering

7.1 Formula-Based Conditional Formatting & Logical Tests 7.2 Data Bars, Color Scales, Icon Sets, & Rule Hierarchy 7.3 Advanced Filtering with Complex Criteria Ranges

8 Chapter 8: Logical Operations & Advanced Multi-Condition Functions

8.1 Nested IF, IFS, & SWITCH Logical Structures 8.2 Compound Boolean Logic: AND, OR, NOT, & XOR 8.3 Multi-Criteria Aggregations: SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, & MINIFS

9 Chapter 9: Advanced Lookup Functions & Variable Optimization

9.1 Modern Lookups with XLOOKUP & XMATCH 9.2 Classic Matrix & Two-Way Lookups: INDEX & MATCH 9.3 Formula Optimization & Variable Assignment with LET

10 Chapter 10: Date, Time, Text, & Auditing Functions

10.1 Current Date, Time, & Day-of-Week Functions: NOW, TODAY, & WEEKDAY 10.2 Business Date Calculations: WORKDAY, NETWORKDAYS, EDATE, & EOMONTH 10.3 Modern Text Extraction & Array Splitting: TEXTSPLIT, TEXTJOIN, TEXTBEFORE, TEXTAFTER 10.4 Error Handling & Formula Auditing Tools

11 Chapter 11: Dynamic Array Functions & Spill Operations

11.1 Array Filtering & Extraction: FILTER Function 11.2 Multi-Level Sorting: SORT & SORTBY Functions 11.3 Deduplication & Sequence Arrays: UNIQUE & Array Reshaping

12 Chapter 12: Data Analysis, What-If Tools, & Financial Functions

12.1 Summarizing Multiple Ranges with the Consolidate Feature 12.2 What-If Analysis: Goal Seek & Scenario Manager 12.3 Financial Modeling Functions: PMT, NPER, & Forecast Logic

13 Chapter 13: Macro Automation & VBA Fundamentals

13.1 Recording Macros with Absolute vs. Relative References 13.2 Macro Storage, Shortcut Assignment, & Form Control Buttons 13.3 Managing & Modifying VBA Code in the Visual Basic Editor

14 Chapter 14: Advanced & Specialized Visualizations

14.1 Statistical Visualizations: Histograms & Pareto Charts 14.2 Hierarchy & Financial Visualizations: Waterfall, Funnel, Treemap, & Sunburst 14.3 Distribution & Multi-Axis Charts: Box & Whisker & Dual-Axis Combo Charts

15 Chapter 15: PivotTable Construction & Field Configuration

15.1 PivotTable Data Architecture, Layouts, & Style Configuration 15.2 Field Summarization, Number Formatting, & Custom Calculations 15.3 Value Display Modes: % of Total, Running Total, & Differences

16 Chapter 16: PivotTable Grouping, Slicers, & PivotCharts

16.1 Date & Numeric Field Grouping Strategies 16.2 Calculated Fields & Calculated Items in PivotTables 16.3 Slicers, Timelines, Report Connections, & PivotCharts

2.1 Workbook Versioning, AutoRecover, & File Properties

Key Takeaways Explain This Topic AI

AutoRecover defaults to saving recovery snapshots every 10 minutes in the user profile directory ( %APPDATA%\Microsoft\Excel\ ), serving as a local crash-mitigation buffer rather than a continuous cloud sync tool.

Unsaved workbooks closed prematurely can be retrieved via File > Info > Manage Workbook > Recover Unsaved Workbooks, which accesses temporary .asd draft files stored in the UnsavedFiles directory.

Version history in local environments displays AutoRecover snapshots under Manage Workbook, whereas OneDrive/SharePoint-hosted workbooks provide cloud-backed version comparison and point-in-time restoration.

The Document Inspector (File > Info > Check for Issues > Inspect Document) audits workbooks for metadata, hidden properties, comments, personal information, and invisible content, stripping sensitive data permanently before external distribution.

Document Inspector sanitization actions cannot be reversed using the Undo command (Ctrl+Z); creating an archival backup copy prior to inspection is essential.

Last updated: September 2026

2.1 Workbook Versioning, AutoRecover, & File Properties

Workbook governance and data preservation form the bedrock of enterprise spreadsheet management. On the MO-211 Microsoft Excel Expert exam, candidates must demonstrate precise mastery of disaster recovery configurations, version management workflows, and metadata auditing protocols. A thorough understanding of how Excel caches uncommitted edits, stores emergency recovery states, and purges sensitive embedded properties ensures both business continuity and regulatory compliance before distributing workbooks.

AutoRecover Mechanics & Operating Architecture

Excel differentiates fundamentally between AutoSave and AutoRecover . AutoSave is a cloud-exclusive feature available in Microsoft 365 that continuously commits cell modifications in real time to OneDrive, OneDrive for Business, or SharePoint Online. In contrast, AutoRecover is a local, client-side safety net engineered to protect workbooks against catastrophic hardware failures, operating system crashes, or unexpected power interruptions.

To configure or audit AutoRecover settings, navigate through the Backstage view: File ⟶ Options ⟶ Save \text{File} \longrightarrow \text{Options} \longrightarrow \text{Save} File ⟶ Options ⟶ Save

Within the Save workbooks section, three vital parameters govern AutoRecover behavior:

Save AutoRecover information every [ X ] minutes : By default, Excel sets this interval to 10 minutes . Administrators and power users can configure this value anywhere from 1 to 120 minutes . Decreasing the interval reduces potential data loss between snapshots but may introduce momentary calculation latency on colossal workbooks with complex multi-threaded dependency trees.

Keep the last AutoRecovered version if I close without saving : This critical checkbox ensures that if a user accidentally closes a modified, previously saved workbook or a newly generated draft without clicking Save, Excel retains the latest background snapshot rather than discarding it permanently.

AutoRecover file location : This field dictates the local directory where Excel writes temporary recovery files ( .xar and .asd extensions). The standard default directory path follows: C:\Users\<Username>\AppData\Roaming\Microsoft\Excel\

  • Feature AutoRecover AutoSave
  • Storage Target Local disk ( %APPDATA%\Microsoft\Excel\ ) Cloud repository (OneDrive / SharePoint)
  • Execution Trigger Periodic timer interval (Default: 10 min) Real-time continuous push on every edit
  • Primary Objective Crash and abnormal shutdown mitigation Collaborative co-authoring & instant sync
  • Workbook Scope Any local or network workbook Only cloud-hosted workbooks

Exam Tip: AutoRecover does not replace manual saves. If you actively click Don't Save when prompted upon closing a file that was previously saved to disk, the operating system releases the session locks and discards temporary delta files unless the "Keep the last AutoRecovered version..." toggle is enabled.

Recovering Unsaved Workbooks & Emergency Drafts

When an abnormal shutdown occurs (such as an abrupt loss of power or application crash), Excel initiates an automatic recovery sequence upon its next startup. The Document Recovery task pane opens automatically docked along the left margin of the interface. This pane enumerates all discovered recovery files, displaying the file name, last modified timestamp, and recovery status:

[Original] : Represents the file state at the time of the last manual save command.

[AutoRecovered] : Represents the latest emergency snapshot generated by the background timer.

Users can click any version listed in the task pane to open it, inspect the contents, and immediately execute a standard Save ( Ctrl+S ) or Save As ( F12 ) command to replace the corrupted or outdated production copy.

The "Never Saved" Scenario

A common operational crisis occurs when an analyst builds a new workbook from scratch, works for an extended duration, and inadvertently closes the application window, clicking Don't Save before assigning a filename. Because no initial file container exists on disk, standard recovery panes may not populate.

To retrieve these stranded drafts, use the specialized Backstage recovery conduit:

Launch Excel and open a blank workbook.

Click File and select Info .

Click the Manage Workbook button (adjacent to the Versions heading).

Select Recover Unsaved Workbooks from the dropdown menu.

Excel instantly launches an Open dialog pointing directly to the hidden operating system cache:

C:\Users\<Username>\AppData\Local\Microsoft\Office\UnsavedFiles

Drafts in this folder carry the .asd (AutoRecover Saved Draft) extension. When opened, Excel renders the workbook in read-only mode with a prominent yellow Message Bar beneath the ribbon:

RECOVERED UNSAVED FILE This is a recovered file that is temporarily stored on your computer. [Save As]

Clicking Save As allows the user to commit the file to a permanent directory with a standard .xlsx or .xlsm format. Excel retains unsaved draft .asd files in the UnsavedFiles cache for up to 4 days before automatic operating system purging occurs.

Managing Versions & Historical Restorations

In modern Microsoft 365 environments, workbook versioning diverges depending on storage architecture:

Local Workbooks : Under File > Info > Manage Workbook , Excel displays available AutoRecover snapshots generated during the active editing session.

Cloud-Synchronized Workbooks : Storing workbooks in SharePoint Online or OneDrive activates comprehensive version history. Selecting File > Info > Version History reveals a sequential timeline of revisions categorized by author, date, and timestamp.

When an earlier checkpoint is selected from Version History, Excel displays the historical file in a secondary comparison window. The ribbon displays a dedicated Restore button. Clicking Restore promotes that prior state to the current active draft. Importantly, restoring an older version does not destroy subsequent revisions; instead, Excel appends the restored checkpoint as the newest revision in the historical lineage.

Document Inspector: Metadata Auditing & Sanitization

Distributing spreadsheets outside an enterprise carries severe security risks if proprietary comments, calculation paths, employee names, or hidden sheets remain embedded in the file structure. Excel provides the Document Inspector as an automated auditing utility designed to detect and excise hidden data before public or client dissemination.

Launching and Running Document Inspector

Before initiating an inspection, the workbook must be saved to disk. Navigate to: File ⟶ Info ⟶ Check for Issues ⟶ Inspect Document \text{File} \longrightarrow \text{Info} \longrightarrow \text{Check for Issues} \longrightarrow \text{Inspect Document} File ⟶ Info ⟶ Check for Issues ⟶ Inspect Document

Excel presents the Document Inspector dialog containing checkable inspection categories:

Comments and Annotations : Detects modern threaded comments, legacy notes, and ink markings.

Document Properties and Personal Information : Scans for standard properties (Author, Manager, Company, Title, Subject, Tags) and internal file metadata such as "Last Modified By" and absolute local file routing paths.

Task Pane Apps and Office Add-ins : Identifies web add-ins embedded in the workbook package.

Embedded Documents & OLE Objects : Flags external files packaged within the sheet.

Macros, Forms, and ActiveX Controls : Identifies underlying VBA projects, user forms, and ActiveX code.

Custom XML Data : Finds custom XML schemas and payload trees associated with the workbook.

Headers and Footers : Scans for custom text, file path codes, and graphic logos placed in worksheet print headers.

Hidden Rows and Columns : Detects rows and columns whose visibility property is set to hidden.

Hidden Worksheets : Identifies worksheets that are either Hidden or "Very Hidden" ( xlSheetVeryHidden via VBA).

Invisible Content : Scans for graphical shapes, text boxes, or objects formatted with 0% fill/transparency or covered by other visual layers. +-------------------------------------------------------------------+

  • | Document Inspector |
  • +-------------------------------------------------------------------+
  • | [x] Comments, Notes, and Annotations [Inspect] |
  • | [x] Document Properties and Personal Information |
  • | [x] Custom XML Data |
  • | [x] Headers and Footers |
  • | [x] Hidden Rows and Columns |
  • | [x] Hidden Worksheets |
  • | [x] Invisible Content |
  • +-------------------------------------------------------------------+
  • Sanitization & The Irreversibility Rule

Upon clicking Inspect , Excel analyzes the OpenXML package and displays a review screen highlighting flagged categories with red exclamation badges. Beside each flagged item, a Remove All button appears.

Caution & Exam Pitfall: Actions performed by clicking Remove All in the Document Inspector are permanent and cannot be reversed using the Undo command (Ctrl+Z) . Furthermore, stripping metadata such as Document Properties, Headers and Footers, or Hidden Worksheets permanently deletes those elements from the active document. Always save an archival backup copy ( Workbook_Master_Archive.xlsx ) before executing Document Inspector sanitization.