Tuesday, August 16, 2011

Microsoft Office File Validation Add-in

Is your excel slow and taking a long time to access files from a network. Microsoft listed this as a critical patch on April 12, 2011. Since this time I have had an issue with some of my clients. This only effects office excel 2003 as the later versions copy the file locally before they open them. This is what the add-in is doing. The OFV reads the file to determine whether the file is trustworthy before it opens the file. When this is done over the network it reduces performance because of the network traffic when reading in the parts of the workbook. This still may be an issue with new versions if you have folder redirection in place.
There are a few ways around this issue.

1. Tell the add-in to ignore excel files by adding this to the registry.
[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\FileValidation]
"EnableOnLoad"=dword:00000000
Microsoft has a tool to do this for you if you do not want to mess with the registry.
2. Uninstall the add-in with add/remove programs or with this command.
msiexec / x {90140000-2005-0000-0000-0000000FF1CE} / quiet

Ref: http://support.microsoft.com/kb/2570623

Monday, August 15, 2011