I have a macro in a workbook that suddenly has begun to run much slower
than in the past (by a factor of about 40).

Not only that, when this workbook is open all macros in other workbooks
run much slower. When the workbook is closed all the macros in other
workbooks return to normal speed.

Anybody have any ideas?

I should have added this to my first post:

The macro in question is simply opening and reading a text file to an
array then writing array elements to a new workbook. If I use the same
code in a different workbook (after closing the "bad" workbook), the
speed is normal

My problem is that there is a lot of other stuff in the"bad" workbook
that I don't want to have to transport to a new workbook

It sounds like a calculation issue to me. When the book is open every time a
recalc initiates that book chews up your resources. Here is a link to give
you some advice. Take a look at the section on volitile functions...

http://www.decisionmodels.com/calcsecrets.htm

--
HTH...

Jim Thomlinson


"SteveF" wrote:

I have a macro in a workbook that suddenly has begun to run much slower
than in the past (by a factor of about 40).

Not only that, when this workbook is open all macros in other workbooks
run much slower. When the workbook is closed all the macros in other
workbooks return to normal speed.

Anybody have any ideas?