Details
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 ConfigurationAdministrative TemplatesMicrosoft Excel 2016Data RecoveryDo 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.
Supportive Information
The following resource is also helpful.
This security hardening control applies to the following category of controls within NIST 800-53: System and Communications Protection.This control applies to the following type of system Windows.