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
|