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