{"id":721,"date":"2011-07-01T18:44:04","date_gmt":"2011-07-01T18:44:04","guid":{"rendered":"http:\/\/pariswells.com\/blog\/?p=721"},"modified":"2011-07-11T21:59:42","modified_gmt":"2011-07-11T21:59:42","slug":"excel-2003-slow-opening-from-network-share","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/fixes\/excel-2003-slow-opening-from-network-share","title":{"rendered":"Excel 2003 Slow Opening From Network Share"},"content":{"rendered":"\"\"<\/a>Recently a user was having issues opening excel files , were by a 600kb file could take around 20 seconds to open. When you copied this file locally to the computer it opened it straight away , and other computers accessing the file had no problem. What I did notice was when you opened the file , the network usage would spike to 7mb\/s for the entire time while only retrieving a 600kb file. Opening .pdf \/ .doc files around double or triple the size would open instantly A bit of research online only proved the fault\/fix with a Windows 7 setup accessing office 2003 documents http:\/\/support.microsoft.com\/kb\/982860<\/a> I tried the “Under the registry entry, disable these two registry keys: Right-click Enablesecuritysignature, and then click Modify. Type 0 in the Value data box and then click OK. Right-click Requiresecuritysignature, and then click Modify. Type 0 in the Value data box and then click OK.” However no success , my setup however was Windows XP and Office 2003. After much searching the fix was actually pretty recent from microsft http:\/\/support.microsoft.com\/kb\/2570623<\/a> “reduces performance due to the network traffic when reading in the parts of the workbook” So upgrade to 2007\/2010 or disable OFV!

You can perform the below fix manually , or I have create a .re file which does it http:\/\/www.pariswells.com\/upload\/fix.zip<\/a>

You can use the EnableOnLoad<\/strong> registry entry to configure how you want Excel to handle opening workbooks for the OFV. By default, the\u00a0EnableOnLoad<\/strong> entry is not present in the Windows registry. To add the\u00a0EnableOnLoad<\/strong>entry to the Windows registry, follow these steps:\r\n
    \r\n\t
  1. Exit Excel.<\/li>\r\n\t
  2. Click Start<\/strong>, click Run<\/strong>, type regedit, and then click OK<\/strong>.<\/li>\r\n\t
  3. Locate and then click to select the following registry key: **EDIT** Thanks to Frank in the comments , the proper key is ” HKEY_CURRENT_USER\\SOFTWARE\\Microsoft\\Office\\11.0″ Old key “HKEY_CURRENT_USER\\Software\\Policies\\Microsoft\\Office\\11.0\\”<\/li>\r\n\t
  4. After you select the key that is specified in step 3, point to\u00a0New<\/strong> on the Edit<\/strong> menu, and then click Key<\/strong>.<\/li>\r\n\t
  5. Type Excel<\/em>, and then press ENTER.<\/li>\r\n\t
  6. Select Excel<\/strong>, point to New<\/strong> on the Edit<\/strong> menu, and then click Key<\/strong>.<\/li>\r\n\t
  7. Type Security<\/em>, and then press ENTER.<\/li>\r\n\t
  8. Select Security<\/strong>, point to New<\/strong> on the Edit<\/strong> menu, and then click Key<\/strong>.<\/li>\r\n\t
  9. Type FileValidation<\/em>, and then press ENTER.<\/li>\r\n\t
  10. Select FileValidation<\/strong>, point to New<\/strong> on the Edit<\/strong> menu, and then click DWORD Value<\/strong>.<\/li>\r\n\t
  11. Type EnableOnLoad<\/em>, and then press ENTER. Note: The default value is 0 which disables the validation.<\/li>\r\n\t
  12. On the File<\/strong> menu, click Exit<\/strong> to quit Registry Editor.<\/li>\r\n<\/ol>","protected":false},"excerpt":{"rendered":"

    Recently a user was having issues opening excel files , were by a 600kb file could take around 20 seconds to open. When you copied this file […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[418,420,416,414,415,417,413,419],"class_list":["post-721","post","type-post","status-publish","format-standard","hentry","category-fixes","tag-xls-slow-from-network-share","tag-420","tag-excel-2003-slow-to-open-network","tag-excel-slow-opening-from-network-share","tag-high-network-usage-office-2003","tag-ofv","tag-the-office-file-validation","tag-windows-xp-excel-2003-slow-opening"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=721"}],"version-history":[{"count":6,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/721\/revisions"}],"predecessor-version":[{"id":732,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/721\/revisions\/732"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}