2.1 Workbook Versioning, AutoRecover, & File Properties

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:

$\text{File} \longrightarrow \text{Options} \longrightarrow \text{Save}$

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

1. 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.
2. 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.
3. 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\

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:

1. Launch Excel and open a blank workbook.
2. Click File and select Info.
3. Click the Manage Workbook button (adjacent to the Versions heading).
4. 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:

$\text{File} \longrightarrow \text{Info} \longrightarrow \text{Check for Issues} \longrightarrow \text{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.