I have a file that contains many macros ( 20-30). I use it all the time
and tried saving it in my Personal file (file that comes up
automatically when starting Excel2000-XLStart), as an add-in, as a
hidden file. No matter what I do this file slows down my navigation
when I have other Excel files open. I do a lot of Control-Tab to go
from file to file and having this file open slows Excel down. I like
having this file open because of all the useful macros. Any suggestions
on how to speed Excel up? Any ideas why this might be slowing Excel
down?

Thanks

I've used my personal.xla in xl97 through xl2003 and it never changed any
response times when I used ctrl-tab.

In fact, ctrl-tab is more of a windows shortcut than excel. I'd keep looking
for the culprit.

Do you use an antivirus or anti-malware like AdAware?

If no, maybe it's time to start.

snax500 wrote:

I have a file that contains many macros ( 20-30). I use it all the time
and tried saving it in my Personal file (file that comes up
automatically when starting Excel2000-XLStart), as an add-in, as a
hidden file. No matter what I do this file slows down my navigation
when I have other Excel files open. I do a lot of Control-Tab to go
from file to file and having this file open slows Excel down. I like
having this file open because of all the useful macros. Any suggestions
on how to speed Excel up? Any ideas why this might be slowing Excel
down?

Thanks

--

Dave Peterson