Hi Everyone
I'm having real difficulty with the speed of opening two Excel files on my network.
We have an SBS 2003 network as such:
WAN > Netgear DG834 router > SBS 2003 Server > XP Pro clients
The router, SBS 2003 server and XP client are all plugged into a central switch.
Thye SBS provides DNS, Exchange, VPN etc. The router provides DHCP. I know this is not ideal. I can change DHCP to server but this will disrupt business ALOT.
We have two Excel files shared via mapped drive to all the client. They are 14BM and 8MB in size respectively.
The thing is it takes ages to open them. Even files half their size. I've restarted the server to see of it makes a difference but none whatsoever.
It take about 1 minute for the 14MB file and 45 seconds for the 8MB file to open via tyhe mapped drive. Even when saved locally on thye machine it takes that long.
Both files does contain loads of PivotTables for reporting from one worksheet to the other etc.
Any ideas? Or anyone working with SBS 2003 that experienced this before? This is really doing my head in. Other much smaller Excel (and all OFFICE files) works fine. We use Office XP.
Thanks in advance
If the files start up slowly, even when stored locally then the SBS box is not at fault, so you are down to network traffic. If they are doing lots of reporting / pivot table work, perhaps the CPU is pegged on the client doing that work? Or it could be that the pivots are accessing other files to get the data to fill into the pivot.
A quick scan using perf mon or the performance tool XPERF (from the MS web site) on the CLIENT should show you where the problems are.
Thanks
David
(c)David Overton 2006-23