Excel 2003 Office File Validation (OFV) opens workbooks slower across the network

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_USER\Software\Microsoft\Office\11.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.