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.

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.

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.

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.