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

Attached Files

Auto Calc Samplet.xlsx (10.0 KB, 15 views)

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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

Maybe the attached can be of some help.

Attached Files

AutoCalc.xlsx (10.8 KB, 10 views)