Excel Re-Calc causes network traffic and very slow response times.

T

toc1957

Platform:
Excel Ver 2003 SP2
Windows XP SP2
Microsoft SBS Server 2003
Workstations: P4 2Ghz, 512 Mb Ram

Problem:
I have an excel file with hundreds of vlookup and indirect formulas. It
has no links to any other spreadsheets. The file resides on a shared
network drive on our server. When users do a recalc or change a number
in the file causing a recalc it takes about 7 seconds... however after
a bit of experimentation I find that if we open the file and then
disconnect the workstations network cable the recalc takes less than
one second !
Tried saving the file to the local drive of a workstation - 7 second
recalc - disconnected network cable .05 Second recalc !

Does anyone know what is making excel create network traffic when doing
re-calc... and how to stop it ???

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why does an Excel Recalc cause traffic over Network ? 0
Excel slow to epen with Network Connection 5
Files open up very slowly 0
Outlook 2007 save to network problem. 3
excel opens very slow 3
Saving Excel files to Win 2003 Server very slow 7
Slow opening new document in MSWord 2007 0
Office 2007 slow to open files on network drive 4

Top