Auto Update feature

[justphilip]

I am attempting to understand an auto calculate and post feature that works sometimes and not other times. if you enter a number in column A of my attached file you will see how it works. Can anyone name the feature and give control advice? Thanks JP

[macropod]

Assuming you're working with Excel set to recalculate automatically, there is nothing I can see about the content of your workbook that would cause some value/formula changes to not recalculate immediately they're made.

[justphilip]

I do not think it is just a recalculate issue! When you enter a new figure in the next empty cell in column "A", a value automatically appears in the empty cell in column "B" and is based on the formula in the previous row of column "B". Some times I can copy a "B" cell that works, modify the formula and replicate it in column "C". Sometime column "C" reacts to the Column "A" entry. Is there a name for this feature? Is it possible there is a hidden macro; if so how is it activated? TIA JP

[xor]

Maybe the attached can be of some help.