Troubleshooting Excel issues after Microsoft Office File Validation for Office high priority update was installed

IT

Troubleshooting Excel issues after Microsoft Office File Validation for Office high priority update was installed

We have been dealing with poor performance with Excel 2003 after the High Priority update 2501584 was installed on client computers. This update adds the MS Office File Validation that originally shows up in Office 2010 into Office 2007 and Office 2003. For most users with Office 2007 they have not seen any issue in performance after the update was installed. For many with Office 2003 they see huge hits in performance when opening excel files across the network even if it is just the 100MB local LAN.  With one client they were experiencing 15-20 delays in opening the file with the update installed. After uninstalling it that dropped down to just 2 seconds to open the file up. Today when looking for the update to remove from the computer and see about hiding it from installing I found this “fix” from Microsoft on the issue (http://support.microsoft.com/kb/2570623).  There is a Fix it button and installation which did the fix for you or you can follow the steps below (copied from the site) to do it manually.  These steps either manually or through the Microsoft FixIt application keep the file validation checking on for all programs except excel which seems to be the only one that is experiencing these performance degradations.

Let me fix it myself

You can use the EnableOnLoad registry entry to configure how you want
Excel to handle opening workbooks for the OFV. By default, the
EnableOnLoad entry is not present in the Windows registry. To add the
EnableOnLoad entry to the Windows registry, follow these steps:

  1. Exit Excel.
  2. Click Start, click Run, type regedit, and then click
    OK.
  3. Locate and then click to select the following registry key:

    HKEY_CURRENT_USERSoftwarePoliciesMicrosoftOffice11.0

  4. After you select the key that is specified in step 3, point to New on
    the Edit menu, and then click Key.
  5. Type Excel, and then press ENTER.
  6. Select Excel, point to New on the Edit menu, and then
    click Key.
  7. Type Security, and then press ENTER.
  8. Select Security, point to New on the Edit menu, and
    then click Key.
  9. Type FileValidation, and then press ENTER.
  10. Select FileValidation, point to New on the Edit menu,
    and then click DWORD Value.
  11. Type EnableOnLoad, and then press ENTER.
    Note: The default value
    is 0 which disables the validation.
  12. On the File menu, click Exit to quit Registry
    Editor.

More About the Author

Richard Clapp

Systems Engineer
Cleaning Up WinSXS Folder on Windows Server 2008 R2 I finally found some good information for cleaning up the WinSXS folder on new instances of Windows. I found the following site ...
Getting Access to Multiple Branches while Using a Split VPN Tunnel for Performance I recently had to help a client who was having performance issues over the VPN. They had a fast connection at home, but just a standard ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072