Autocalculation

[ljtong]

Say A1 has the formula
=B1

When I type 5 into B1, A1 doesn't change until I press F9

I know how to set the options to "automatic calculation"

But is it possible to set just certain cells(A1 in this case) to "volatile" like in VBA so it recalculates for each change in its formula's source cell?

 

[acw]

Hi

Try Tools, Options, Calculation, and make sure the automatic radio button is selected.


Tony

 

[tactps]

Tony, I think they want to recalc one cell, rather than the whole sheet.

So try this:
1. Press Alt-F11 to bring up VBA
2. In the left pane, double-click the sheet to attach this to.
3. Paste this in (alter as required):

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then [a1].Formula = [a1].Formula
End Sub