Excel runs slowly, but only when connected to a network
 

I have an excel program that runs very slowly when connected to a network.
When I physically disconnect the lan, the program runs fine. Other excel
programs I have run fine when my computer is attached to the network. The
program in question has about 10 macros (nothing unusual, I have other
programs more complex that work fine). Has anyone experienced anything like
this? Thanks for your help in advance.

Excel runs slowly, but only when connected to a network
 

Does your file maybe look for other data outside itself?............if its
trying to find that data in your C drive directory maybe it finds it fast,
but if trying while on the network, maybe not so fast.....

hth
Vaya con Dios,
Chuck, CABGx3



"Pete" wrote:

I have an excel program that runs very slowly when connected to a network.
When I physically disconnect the lan, the program runs fine. Other excel
programs I have run fine when my computer is attached to the network. The
program in question has about 10 macros (nothing unusual, I have other
programs more complex that work fine). Has anyone experienced anything like
this? Thanks for your help in advance.

Excel runs slowly, but only when connected to a network
 

Thanks CLR,

I suspect you are right. When I disable macros the Excel program works fine
(as far as speed is concerned). I went throught all the macros to see if
they are looking for something outside the workbook, but haven't seen
anything obvious (I am a rookie when it comes to writing macros, and several
have been written by a coworker who no longer works with us). The funny
thing is that I did not have these problems until my department moved to a
new office (bolstering your theory that it is out looking for something) and
put onto a new server.

Are there any diagnostic tools that can help me "audit" this program while
it's running.

"CLR" wrote:

Does your file maybe look for other data outside itself?............if its
trying to find that data in your C drive directory maybe it finds it fast,
but if trying while on the network, maybe not so fast.....

hth
Vaya con Dios,
Chuck, CABGx3



"Pete" wrote:

I have an excel program that runs very slowly when connected to a network.
When I physically disconnect the lan, the program runs fine. Other excel
programs I have run fine when my computer is attached to the network. The
program in question has about 10 macros (nothing unusual, I have other
programs more complex that work fine). Has anyone experienced anything like
this? Thanks for your help in advance.

Excel runs slowly, but only when connected to a network
 

And/or it might even be "links" that it's looking for..............Bill
Manville has a fine Add-in called "Find Links" that I use a
lot...........might be helpful here.........

Vaya con Dios,
Chuck, CABGx3



"Pete" wrote:

Thanks CLR,

I suspect you are right. When I disable macros the Excel program works fine
(as far as speed is concerned). I went throught all the macros to see if
they are looking for something outside the workbook, but haven't seen
anything obvious (I am a rookie when it comes to writing macros, and several
have been written by a coworker who no longer works with us). The funny
thing is that I did not have these problems until my department moved to a
new office (bolstering your theory that it is out looking for something) and
put onto a new server.

Are there any diagnostic tools that can help me "audit" this program while
it's running.

"CLR" wrote:

Does your file maybe look for other data outside itself?............if its
trying to find that data in your C drive directory maybe it finds it fast,
but if trying while on the network, maybe not so fast.....

hth
Vaya con Dios,
Chuck, CABGx3



"Pete" wrote:

I have an excel program that runs very slowly when connected to a network.
When I physically disconnect the lan, the program runs fine. Other excel
programs I have run fine when my computer is attached to the network. The
program in question has about 10 macros (nothing unusual, I have other
programs more complex that work fine). Has anyone experienced anything like
this? Thanks for your help in advance.