View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Excel spreadsheets over WAN

Hard to say. What's the connection speed? I frequently open 60MB XL
workbooks over my company's intranet.

Do the workbooks use a lot of volatile functions?
--
Brevity is the soul of wit.


"TJ Dowling" wrote:

Does anyone have experience with designing Excel spreadsheets for better
performance over a WAN?

I have some users that have large files that take forever to load over a
WAN link. Since they share them with other users at different locations, it
needs to be on the WAN.

I wasn't sure if there were some design tips that I was missing that could
lead to improved performance. Please advise if you have a tip.

Thanks,
--
TJ Dowling