Information
This policy setting controls whether users with the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats installed can open Office Open XML files saved with pre-release versions of Excel. Excel Open XML files usually have the following extensions: .xlsx, .xlsm, .xltx, .xltm, .xlam. The recommended state for this setting is: Enabled. The Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats enables users of Microsoft Excel 2000, Microsoft Excel 2002, and Microsoft Office Excel 2003 to open files saved in the Office Open XML format used by Excel. Excel Open XML files usually have the following extensions: #x2022; .xlsx #x2022; .xlsm #x2022; .xltx #x2022; .xltm #x2022; .xlam By default, the Compatibility Pack does not open files that were saved in pre-release versions of the new Office Open XML format, which underwent some minor changes prior to the final release of Excel. If this configuration is changed through a registry modification or by some other mechanism, users with the Compatibility Pack installed can open files saved by some pre-release versions of Excel, but not by others, which can lead to inconsistent file opening functionality.
Solution
To implement the recommended configuration state, set the following Group Policy setting to Enabled. User Configuration\Administrative Templates\Microsoft Office 2016\Office 2016 Converters\Block Opening of Pre-release Versions of File Formats New to Excel 2016 Through The Compatibility Pack for Office 2016 and Excel 2016 Converter Impact: Enabling this setting enforces the default configuration, and is therefore unlikely to cause usability issues for most users. Note See Plan block file format settings in the Office Resource Kit for more information about using Group Policy to manage and enforce file format requirements. Also, see the 'File Block Technology' section in Chapter 4 of the Microsoft Office Security Guide for information about the Microsoft Office Isolated Conversion Environment (MOICE), which provides another method.