Search This Blog

Sunday, January 20, 2013

From network drive Excel file takes long time to open (Office 2003)

Office 2003
The problem is with big excel files. When you try to open them from network drives, it takes long time to load.
For fix this issue you will be need to edit your REGISTRY.
Please follow these steps:

Please open StartRun →  and type regedit  <Enter>
Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\FileValidation
****(If under Excel Key, Security and FileValidation does not exist, create it.)****
Right click on key "FileValidation" New → DWORD
Under Name of DWORD type EnableOnLoad  <Enter>
Right clcik on DWORD and choose Modify.
Set Value Data 0
Click <Ok> and exit from editor. Try Open again your EXCEL File.
Should be ok. :)




No comments:

Post a Comment