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


Seagate Backup Plus Slim External USB 3.0 2TB Hard Drive Review

PCSTATS TechTip - Fix Excel Being Extremely Slow to Opening Network Files - PCSTATS.com 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!

A quick patch update to Windows can extend the useful life of a PC. To take the fear out of Upgrading Windows 98 to Windows XP, rely on this guide. - PCSTATS Tips

FULL STORY @ PCSTATS ON FB

Recent News in Tips
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
PCSTATS TechTip - Windows Directory Statistics (WinDirStat) Feb 6
PCSTATS TechTi p - Tale of the Corrupted Outlook PST Backup Feb 6
more...

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
   04 / 19 / 2014 | 8:54PM
Hardware Sections 


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

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