Excel and calculations

[alrodopial]

I have 3 sheets open that they are not linked each other.
In the first I log a market from BA that refreshes every sec.

I see that every second the formula's in the other two sheets are been calculated also. Is this logical?

[osknows]

These 2 links give a pretty good overview of what's calculated on Automatic & Manual recalc with some good examples

http://www.decisionmodels.com/calcsecretsg.htm
http://www.decisionmodels.com/calcsecretsh.htm

[greenfingers]

Thanks for the links Os, that was helpful for me working out where all the CPU is going on my spreadsheet!