Excel spreadsheets over WAN

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger Rabbit - 03 Jan 2008 10:32 GMT

I have a user that tries to load a 6.24MB Excel spreadsheet that takes "an
excessive amount of time to load". The spreadsheet in question is stored on
a remote file server on a different subnet. I already know that, in this
particular case, the 2Mb WAN link (MPLS circuit) connecting the two sites is
the bottleneck, that's a no brainer, but I was wondering if there were any
settings within Excel itself that affect the way the app handles
spreadsheets over a network?

TIA

Reply to this Message

Roger Rabbit - 03 Jan 2008 10:42 GMT

Forgot to add, I should note a contributing factor to the time it takes for
the spreadsheet to load from the remote file server is the 52 inherent
worksheets (representing 52 weeks in a year). If I create a new spreadsheet
in the same folder with only a couple of worksheets, it opens with no
noticeable delay (because it's a smaller file). So, I was still wondering if
there are any settings within Excel that changes the way the app handles
spreadsheets over a network?

"Roger Rabbit" <roger@rabbit.com> wrote in message news:...

>I have a user that tries to load a 6.24MB Excel spreadsheet that takes "an
>excessive amount of time to load". The spreadsheet in question is stored on
[quoted text clipped - 5 lines]
>
> TIA

Reply to this Message

Wigi - 04 Jan 2008 10:34 GMT

see
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.
public.excel&tid=4686ab93-1fe0-4e35-ad46-97210c69638b&p=1

Signature

Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music

> I have a user that tries to load a 6.24MB Excel spreadsheet that takes "an
> excessive amount of time to load". The spreadsheet in question is stored on
[quoted text clipped - 5 lines]
>
> TIA

Reply to this Message