opening excel over wan is slow

[christian maanz]

Good morning!

A few users complain, that opening of an excel-file (excel 2000) is very
slow.
The users are connected over WAN (256 kbit/s).
The excel-file is stored on a drive in the network.
The size of the excel-file is approx. 10 MB.
Does excel have to transfer the whole 10 MB to the client?
In this case, I would not be surprised, why it takes so long to open it.
I am not sure how excel over WAN (network) is working.

Thanks.
Chris

[Michael Bednarek]

On Sun, 29 Jan 2006 08:30:22 +0100, christian maanz wrote in
microsoft.public.excel:

>A few users complain, that opening of an excel-file (excel 2000) is very
>slow.
>The users are connected over WAN (256 kbit/s).
>The excel-file is stored on a drive in the network.
>The size of the excel-file is approx. 10 MB.
>Does excel have to transfer the whole 10 MB to the client?

How else can the client access the spreadsheet?

>In this case, I would not be surprised, why it takes so long to open it.

Indeed; according to my calculations, it should take exactly 5 minutes
and 5 seconds, if the transfer is working at nominal speed - which it
never is.

>I am not sure how excel over WAN (network) is working.

I don't expect any witchcraft - it just opens and reads the file. The
weird way Excel date-stamps a file on opening, and reverses that process
when closing without saving, doesn't help with the transfer speed.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"