Personal file slows navigation

S

snax500

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top