Slow opening of Word and Excel documents over network
My setup
Windows SBS, plus about 10 PCs with XP Home in a workgroup. A single 'F
drive' shared and mapped to the client XP Home PCs. Guest account enabled
and permitted to the share, so that all clients can open files like in a
simple peer-peer network. Network all works perfectly, except that randomly
when opening a Word of Excel document, it will hang and go 'not responding'
for about 30 seconds before then waking up and continuing as before. Happens
about 30% if the time, on small and large documents.
(Word and Excel 2000 BTW).
Tried everything I could find - disabling Oplocks, NTCaching etc - and
nothing makes a difference.
Then, changed the network share so that it is mapped and signed on using the
server's Administrator username and password, rather than guest. All of a
sudden, problem is gone.
Question is.......why?
Why should this solve the issue?
Also, since this does, can I make XP Home remember the password between
boot-ups???? At the moment, we have to re-enter the Administrator password
every morning to reconnect the F drive.
Re: Slow opening of Word and Excel documents over network
These search results may help,
Slow when accessing the file located on a server You experience slow performance when you open, save, close, delete, ... When you try to open a Microsoft Word file, you may receive the following error ...
Slow to open a file or browse because of mapping to disconnected drive ... For example, when a user tries to browse his department shared folder from Word, ...
Re: Slow opening of Word and Excel documents over network
This problem can be caused by ACT!8. The preload setting needs to be
changed from -stayrunning to -preload in:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
Re: Slow opening of Word and Excel documents over network
I had the same problem, and found that the HP digital imaging monitor was
causing the long startup time. Once I got rid of it from the startup and
rebooted, the problem went away for my office docs.
Re: Slow opening of Word and Excel documents over network
We tried everything and finally decided since we are using Windows Server and it uses Internet Explorer a lot, we reset Internet Explorer to its default settings. Control panel to Internet Options. Then under Advanced, at the bottom, you can reset it to its default settings. We then did windows update, which had a bunch of updates to download and install. But, now, my computer is faster than it's ever been. I wish I had done this sooner!
Re: Slow opening of Word and Excel documents over network
For mapping the network share so you wouldn't have to enter username and password first you can create a logon script (.bat or someting else)
net use h: \\server\share /user:username password
With the slow opening of excel files it has something to do with the registry key
1. Close any instances of MS Office
2. Click Start, click Run, type regedit then click OK.
3. Locate and then click to select the following registry key: HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\11.0″
4. Nadat je de key hebt gespecifieerd in stap 3, point to New on the Edit menu, then click Key.
5. Type Excel, then press ENTER.
6. Select Excel, point to New on the Edit menu, and then click Key.
7. Type Security, and then press ENTER.
8. Select Security, point to New on the Edit menu, and then click Key.
9. Type FileValidation, and then press ENTER.
10. Select FileValidation, point to New on the Edit menu, then click DWORD Value.
11. Type EnableOnLoad, then press ENTER.
Note: The default value is 0 which disables the validation.
12. On the File menu, click Exit to quit Registry Editor.