I'm importing a report from a third party and then running a macro. The
macro has nothing in it about calculation (I created it). But I do usually
run this report first thing in the morning, and I haven't checked the
calculation status before running it, so maybe it is the report that is doing
it. A co-worker has run the report without the calculation status switching,
but she runs it later in the day so she has already opened other files.
Usually, I won't have Excel open when I download the report -- Excel opens
from the report. So tomorrow, I'll try opening another file first and see if
this fixes the problem. I can't do anything about the third party report --
the company charge us if we want something modified, but I could add a line
to my macro to switch to automatic calculation.