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
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
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!