Extend Formula

[straydawg]

So, Sheet1 Cell B2 I have =Data!A2, basically wanting to copy the value

from cell A2 on data sheet to cell B2 on Sheet 1.

Previously, I would use fill handle to drag down and cell B3 would then

populate to =Data!A3, B4 = Data!A4 etc.. and their corresponding values



But tweaked something??? now the formula is still referencing the =
Data!A4, but the value appearing is the same as the first cell B2


Tried changing Tools\Options\Edit\Extend Datarange format and formulas,

no success...


Thanks,
D

 

[Ragdyer]

Check if your calculation is set to automatic.

<Tools> <Options> <Calculation> tab,
And make sure "Automatic" *IS* checked.