Registry file available for validating your windows
HKCU\Software\Microsoft\Office.0\Excel\Security\File Validation\Enable On Load – This is a DWORD that if set to 0 Office will not validate files.
HKCU\Software\Microsoft\Office.0\Excel\Security\File Validation\Disable Edit From PV – This is a DWORD that if set to 1 will not allow files to be edited that fail validation.
HKCU\Software\Microsoft\Office.0\Excel\Security\File Validation\Pivot Options – This is a DWORD that controls specific options around validating pivot caches (for performance reasons) in files that have them.
0 = Never validate any pivot cache 1 = Validate the pivot cache in the following cases: (1) file is opened from the internet, and the platform marks the file locally as having come from the internet.
(4) The file is opened from a known "unsafe location" locally where internet content is cached, and any special user-defined untrusted locations, unless protected view unsafe locations are disabled via (a different) registry key.
(5)The file is opened and the pivot cache is parsed on load.
These policies are located under the application’s “Options\Security\Trust Center\Protected View” in the group policy templates and it is a per application setting.
There are several registry keys that control various aspects of Office File Validation.
We realize that many administrators (or security conscious users) may not like the idea of opening a file that fails validation, so there is a group policy to control the default action when a file fails validation.
2 =Always validate all pivot caches For custom solutions built on top of Office there are a few interesting properties that have been added to the Application Objects that will disable file validation for that session.
There is also an extra option for Excel to control the validation of Pivot Caches (i.e. Here’s a powershell script example showing how to set these two options for Excel (but the File Validation property would also apply for Word and PPT): $excel = New-Object -comobject Excel.
DOCX, XLSX, PPTX, etc), nor does it validate macros or other custom items.
What it does validate is the structure of the file, for example if you have a XLS file that has a FONTINDEX structure with the ifnt value set to 4 (which is an invalid value for that particular item) then it fails validation. not in a trusted location and not a trusted document) is loaded by Word, Power Point, or Excel it goes through a check to see if it is a valid file.