1.2.1 Ensure 'Do Not Show Data Extraction Options When Opening Corrupt Workbooks' is set to Enabled

Information

This policy setting controls whether Excel presents users with a list of data extraction options before beginning an Open and Repair operation when users choose to open a corrupt workbook in repair or extract mode. The recommended state for this setting is: Enabled. By default, when users choose to open a corrupt workbook with the Open and Repair command, Excel prompts them to choose between repairing or extracting data. Also, for cells that contain formulas, users are prompted to either convert the contents to values or to recover formulas. If users choose to extract data instead of attempting to repair the workbook, important formulas, formatting, and VBA code could be lost unnecessarily.

Solution

To implement the recommended configuration state, set the following Group Policy setting to Enabled . User Configuration\Administrative Templates\Microsoft Excel 2013\Data Recovery\Do Not Show Data Extraction Options When Opening Corrupt Workbooks Impact: Enabling this setting will prevent Excel users from choosing how workbooks are recovered, which could increase desktop support requests.

See Also

https://workbench.cisecurity.org/files/568

Item Details

Category: SYSTEM AND COMMUNICATIONS PROTECTION

References: 800-53|SC-24

Plugin: Windows

Control ID: c5a8eac6a402c93c0343f2a4e9e3576796c0c0a9491a2093bacb6cf81df9a5cb