D(one) IT

IT Tips, Tricks & Such

Monthly Archives: July 2011

Excel 2003 hung or long load time for network files

After applying Microsoft Office File Validation for Office 2003
http://support.microsoft.com/kb/2501584 users report Excel 2003 hanging when opening documents from a network share, or long load times.

Microsoft released a fix: http://support.microsoft.com/kb/2570623 but requires the user to be an administrator of their local machine.

  • To push the fix quickly to all users via GPO (not requiring local admin), create a logon script with the following entries:
  • ExcelOFVFIX.bat

    :: OFV fix for excel
    reg add "HKCU\SOFTWARE\Microsoft\Office\11.0\Excel\Security\FileValidation" /f
    reg add "HKCU\SOFTWARE\Microsoft\Office\11.0\Excel\Security\FileValidation" /f /v EnableOnLoad /t REG_DWORD /d 0
    
  • Or create a reg file with the following entries and have each effected user run it:
  • ExcelOFVFIX.reg

    Windows Registry Editor Version 5.00
    [HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security]
    [HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\FileValidation]
    "EnableOnLoad"=dword:00000000