Iterate upon opening - DA

D

DA

I have received an EXCEL file and, whenever I open it, it changes the
calculation mode into iterate, even though it has no need for such.
Regardless of whether there is a need or not, I am having trouble
locating the source of this action, which I'd like to defeat. There
seem to be no "do this upon opening" macros listed anywhere, in fact
no macros at all. The This workbook tab is empty and there is only
one oter item listed: Sheet1(summary). Can someone list the places
such a macro could be hiding? Or any other way this could be
happening?

Here's some clues, maybe: On Sheet1(summary) in VBE, I notice that
"enable calcualtion" is set to True. If I change it to false, resave
the file, and reopen, the problem goes away, although I notice that
the enable calculation is back to True again (maybe it's a toggle).
Though that does seem to fix the file, I'd still like to know how it
got set to iterate to start!

This does not happen with my other files.

Thanks much for any help
Dean
 
J

JLGWhiz

Look in Tools>Options>Calculation and see if the Automatic is checked. If
it is, then you probably have something in the worksheet that changes when
the sheet is activated, like a date, that triggers the calculation.
You can check the Manual box to turn it off, but will have to remember to
turn it back on when you change data on the sheet.
 
J

Joel

There maybe a add-in in the workkbook or macros that a protected that you
can't see.
 
D

DA

That does seem to fix it permanently, as I may have already
mentioned. Still, I would like to know where such a reset upon
opening (of the original file) can be hidden, so as to do what the
original file (without resaving) does.

I guess I should just get over it!

Thanks
Dean
 

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