>Al,
>thank you for your detailed reply.
>- I create xls file from scratch, then save it on local drive. Only DBFs are on network drive
>- I set"Trust access to the VBA project object model" - no changes in speed
>- disabled all antivirus and spyvare programs - the same slow speed
>- all default and temp files folders are on local drive
>- "is there any kind of remote desktop or desktop virtualization going on?" - no
>
>I have no idea what else can I try...
Hmm, about all I can think of is to look at Task Manager while your Excel-related app is running. See if your computer CPU utilization is very high, if memory usage is high etc.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up