D(one) IT

IT Tips, Tricks & Such

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
    
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: