Excel has a known problem opening/saving files over a WAN: the only bypass
is to filecopy the workbook to a C drive at open time, but this of course
gets very tricky if the users need to modify the workbook.
Otherwise you just need a faster WAN ...
see Q254733 for an article discussing some aspects of the WAN problem
Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com
"TJ Dowling" wrote in message
...
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