Win 2k and Excel 2k issue

[1665]

Hi, my boss has a large Excel file (77MB), it can take up to 2 mins to save on his laptop to the network drive. The laptop is a Dell c400, 1.4Mhz, 256mb etc, if I open the file on my laptop (same spec) it takes 30 secs. I have changed his port on the switch (gigabyte) to the same as mine, but no change. If he saves the Excel document to his C drive and makes a change to it and saves it locally again, it takes 20 secs (great), but then if he saves it to the network it takes 2 mins. However if I just copy the file to the network it is very quick (20 secs). Whats different with the Excel save to a straight copy and paste?

Hope you have some ideas ;-)

1665

 

[InfrArch]

Hi,

What is the max speed allowed by the NIC on boss's PC? (10 or 100?)
Check the boss's PC and switch port to full duplex/half duplex settings.

Pls., post the results.

P.S. a VEERY interesting problem.






Victor K
psas@canada.com
MCSE+I;MCSA;MCSE(w2k);CNE(5.1);CNE(6);CIWSP;CIWSA;Net+;CCNA

 

[1665]

Hi, It's running at 100MB..

 

[Mijjoiji]

Hi,

Just a thought, are you running Excel 2k aswell? You aren't running Excel XP? I know Excel XP has a bigger cache or something. As I said just a thought. )

 

[1665]

Hi, as stated in the main title it's Excel 2k

 

[rosieBsDad]

What's the network - W2k, NT or otherwise?

I know you say you have the sames spec as the boss, but may be worth checking the NIC driver parameters, especially things like AUTOE-DETECT of speed, which can cause real fun and games sometimes.

I would not be surprised to find that Saving a file from within Excel uses a different internal mechanism to the straight Copy, and things like frame types and buffer sizes suddenly come into play.

Just out of interest, what's the comparable performance between your PC's when LOADING the file?

RosieBsDad

 

[1665]

Hi, they load at the same speed, which confuses me.

 

[1665]

Hi all again, this is an update to this problem again, some bits are repeated:

Hi all, this has really got me stumped. I have a user with a Dell laptop (1.4mhz, 256mb, 20gb etc), and a Excel 2000 spreadsheet which is 77mb. This spreadsheet if saved on the local HD takes 10-15 seconds to save. If this spreadsheet is then saved to the users Network drive it can take 2-5 minutes if not more! If saved on another server it takes 25 seconds. So ok it's the server that's the problem, as it's all pointing to that and even on unbusy parts of the day the laptop will save the document very quickly (25seconds) to that server. BUT GET THIS! If the spreadsheet is taking 2-5 minutes to save on the laptop and once it's finished I then try saving it on any other PC they all take 20-25 seconds to save it at any part of the day. It could be the be that the server is being hit heavily, but all the other PC's we have will take 20-25 seconds compared to the laptop.

The laptop has 10/100 3com 920 integrated card which is the same make as the other PC's.

I have tried changing the settings to 100 half duplex, full duplex but **what do these mean?**

I have updated the laptop to all the latest patches, turned off the virus scanner.

What can it be!!

Andy