Permanent Fix for Office Validation Warning: Offile File VAlidation Detected A Problem While trying to open this file

spurs

Active Member
Joined
Oct 18, 2006
Messages
479
Office Version
  1. 2016
  2. 2013
  3. 2010
  4. 2007
  5. 2003 or older
Platform
  1. Windows
Last year Microsoft did a security update that affected Microsoft Office 2993 User

Most of those people using my spreadsheets now get this message when they open the spreadsheet.

Office File Validation WARNING: Office File Validation detected a problem while trying to open this file. It is suggesting that there may be malicious code in the file.

I found the following information online:





Solution: You must create the registry key to disable validation (this fix is easy!)


To prevent Office File Validation from validating files you must create the following registry key (all
the solutions online never said I had to create a key... they said go to it...duh) and assign it a value of “0
” for the specified application in Office 2003 or Office 2007:


HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\<11.0 or 12.0
>\<application>\Security\FileValidation, where <11.0 or 12.0> represents the version of Office and where
<application> represents the specific Office application for which Office File Validation is installed, such
as Word, Excel, and PowerPoint.


This is simple... really! Here's how:


Exit Excel
Click Start, click Run, type regedit, and then click OK.
Locate the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0 or 12.0\
Click on the version number to highlight it
On the menu, click Edit, New and then click Key.
Type Excel, and then press ENTER.
Select Excel, point to New on the Edit menu, and then click Key.
Type Security, and then press ENTER.
Select Security, point to New on the Edit menu, and then click Key.
Type FileValidation (Note there are no spaces between the words), and then press ENTER.
Select FileValidation, point to New on the Edit menu, and then click DWORD Value.
Type Enable****** (again... no spaces), and then press ENTER.


Note: The default value is 0 which disables the validation.
On the File menu, click Exit to quit Registry Editor.


Here's the documentation from MS...
Make a registry key to disable the validation.
Office File Validation for Office 2003 and Office 2007




Ok so this solution may work on one system that I control but its not easy for unfamiliar users who need an easer solution. Doe anyone know of an install or small program to pass on to my users who can run the program and it takes care of doing all this for them so they no longer have to deal with this annoying message?
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Forum statistics

Threads
1,216,075
Messages
6,128,667
Members
449,462
Latest member
Chislobog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top