Excel spreadsheets over WAN
 

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

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

Excel spreadsheets over WAN
 

From what I know, they have a T1 line (1.43 mbps) but the spreadsheets have
links into other spreadsheets and even an Access database. I'm thinking of
recommending terminal services or similar solution.
--
TJ Dowling


"Dave F" wrote:

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

Excel spreadsheets over WAN
 

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

Excel spreadsheets over WAN
 

Well, I'm not sure what terminal services is, and I'm no network expert, but
as I say I've had no trouble accessing large spreadsheets via a network, even
ones that communicate with Access dbs.

Do these people have the same performance problems if they save the
spreadsheets/access db to a local drive? If not, I would presume that
there's a problem with their connection speed?
--
Brevity is the soul of wit.


"TJ Dowling" wrote:

From what I know, they have a T1 line (1.43 mbps) but the spreadsheets have
links into other spreadsheets and even an Access database. I'm thinking of
recommending terminal services or similar solution.
--
TJ Dowling


"Dave F" wrote:

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

Excel spreadsheets over WAN
 

My feeling is that I can do 1 of these things:

-rewrite app using SQL Server with VB or ASP.Net front end
-use terminal services or Citrix for remote access
-copy to local drive for editing (links will need to be fixed)

I'm not aware of anyway to design spreadsheets differently that improves
performance over a WAN. I was hoping someone had an Excel solution.
--
TJ Dowling


"Charles Williams" wrote:

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

Excel spreadsheets over WAN
 

There certainly are ways to make spreadsheets more efficient. See this
whitepaper for extensive details:
http://technet2.microsoft.com/Office...8f2401033.mspx

Without knowing how your spreadsheets are designed it's impossible to give
you details on how to improve them. Do they use a lot of volatile functions?
Do they have more than 65,000 functions?

Etc.
--
Brevity is the soul of wit.


"TJ Dowling" wrote:

My feeling is that I can do 1 of these things:

-rewrite app using SQL Server with VB or ASP.Net front end
-use terminal services or Citrix for remote access
-copy to local drive for editing (links will need to be fixed)

I'm not aware of anyway to design spreadsheets differently that improves
performance over a WAN. I was hoping someone had an Excel solution.
--
TJ Dowling


"Charles Williams" wrote:

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

Excel spreadsheets over WAN
 

I may have misread your initial post. If you are referring to how to get a
pivot table to suppress empty cells, then in the pivot table wizard dialog
box choose the "table options" button, and make sure the option "For empty
cells, show:" is checked, and leave the field blank. That should work.

Dave
--
Brevity is the soul of wit.


"TJ Dowling" wrote:

My feeling is that I can do 1 of these things:

-rewrite app using SQL Server with VB or ASP.Net front end
-use terminal services or Citrix for remote access
-copy to local drive for editing (links will need to be fixed)

I'm not aware of anyway to design spreadsheets differently that improves
performance over a WAN. I was hoping someone had an Excel solution.
--
TJ Dowling


"Charles Williams" wrote:

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