BACK TO PCSTATS Follow PCSTATS on Facebook PCSTATS RSS Feed PCSTATS Twitter Feed + Motherboards
+ Videocards
+ Memory
+ Beginners Guides
News & Advanced Search  Feedback?
[X]   Directory of
Guides & Reviews
The PCstats Forums

Beginners Guides
Weekly Newsletter
Archived Newsletters

Beginners Guides: Hard Drive Data Recovery

PCSTATS TechTip - Fix Excel Being Extremely Slow to Opening Network Files - PCSTATS TechTip - Fix Excel Being Extremely Slow to Opening Network Files
Mon, Jan 06 2014 | 2:05PM | Filed under: Tips| PermaLink Posted by: STAFF

Accountants will want to pay attention to this PCSTATS TechTip.

Here's what usually happens; someone in accounting goes to open up an Excel spreadsheet stored on another users computer. They navigate across the network to the folder share, locate the .xls file and double click it. After waiting for a minute or possibly several minutes, the spreadsheet finally opens. Perplexed by this slowness, the user who owns the file will usually try opening it up on their PC system and find it responds immediately, so what gives?

The extremely slow response is not because your office Ethernet network is slow, the computer is out of RAM or antivirus is gumming up the works, it's because of something called "Microsoft Office File Validation". This comes into play with Excel 2003 and sometimes Excel 2007 files. OFV causes excel spreadsheets accessed over a network to open painfully slowly, even if the file itself isn't very large.

PCSTATS can help you fix this problem with a simple Registry hack. We found it most reliable to apply the registry fix on both source and destination computers.

First, exit Excel 2003. Then go 'Start' > 'Run' > type 'regedit'. Navigate to 'HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\11.0' and right click on '11.0' to bring up the properties menu > select 'New' > select 'key' > type "Excel" and hit Enter. Right click on "excel" > 'new' 'key'> type "Security" and hit Enter. Right click on "security" > 'new' 'key'> type "FileValidation" and hit Enter. Right click on "FileValidation" > 'new' 'DWORD Value'> type "EnableOnLoad" and hit Enter. EnableOnLoad will automatically be set to a value of '0' which disables OFV.

Most tips for this issue stop there, but in our office network where there is a mix of Office 2003, 2010 and 2013 we found it necessary to repeat this Registry hack for HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\11.0, ...\12.0 and ...\14.0.

After that's all done Excel files open across the network normally! Catch more PCSTATS TechTips like this on our Facebook page - LikeUs to get the Tips as they're posted!


Recent News in Tips
Office 2013 Crashes on Start Up - Solved - PCSTATS TechTip Feb 26
PCSTATS TechTip: Excel Cannot Complete this Task with Available Resources - SOLVED Oct 27
PCSTATS TechTip - Automatically Shut Down Windows at a Certain Time Jan 27
PCSTATS TechTip - More to Calculator than you think Jan 13
PCSTATS TechTip - Fix Excel Being Extremely Slow to Opening Network Files Jan 6
AMD fans rejoice Oct 10
TIP - Windows 8 and Bringing back the Start Menu May 2
TechTip - Bring Back the Quick Launch Bar in Windows 7 May 2
Windows 8: How to Bypass Metro and Boot Directly to the Desktop Interface Oct 31
HotHardware's 2012 Back To School Shopping Guide Aug 28

News Categories
Audio / Sound Beginners Guides Benchmarks
Biometrics BIOS Business / Industry
Cases Chipset Computer / SFF PCs
Cooling / Heatsinks CPU / Processors Digital Cameras
Drivers Editorial Games
Gossip Hard Drives/SSD Hardware
Home Theatre Imaging Memory
Mobile Devices Monitors Motherboards
Mouse Pads MP3 Players Networking
Notebooks Operating System Optical Drives
Overclocking Peripherals Power Supply
Press Release Printers Servers
Site News Software Tips
Tradeshows / Events Video Cards Web News
   Looking for something a little farther back? Try PCstats News Archives: 1999 - present
   02 / 21 / 2020 | 7:58PM
Hardware Sections 

PCSTATS Network Features Information About Us Contact
PCSTATS Newsletter
ShoppingList Assistance
Tech Glossary
Technology WebSite Listings
PermaLink News
Archived News
Submit News (Review RSS Feed)
Site Map
PCstats Wallpaper
About Us
Privacy Policy
Advertise on PCSTATS

How's Our Driving?
© Copyright 1999-2020 All rights reserved. Privacy policy and Terms of Use.