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

Kingston SSDNow V300 240GB SATA III SSD Review

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 - Windows 7 and older Integrated Graphics Drivers Apr 18
Dealing with CryptoLocker ransom ware Mar 28
Office 2013 Crashes on Start Up - Solved - PCSTATS TechTip Mar 14
PCSTATS TechTip: Isolate a browser with Sandboxie to protect your PC Feb 11
PCSTATS TechTip: When FireFox Crashes Constantly Feb 11
PCSTATS TechTip - Finding Your Windows product Key Feb 6
PCSTATS TechTip - Testing the waters with new Windows Operating Systems Feb 6
PCSTATS TechTip- Disabling Shutdown Event Tracker in Windows Server 2003 Feb 6

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 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
   03 / 30 / 2015 | 7:18PM
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-2015 All rights reserved. Privacy policy and Terms of Use.