Excel fail to pull down formula

I have a excel file and setting some formula in it.
However, when i try to pull down the formula e.g. = A2, by put the mouse at right bottom of cell ( "+"). It fails to pull down the correct formula (should be =A3, =A4, etc...) and only return me with all =A2

what I see:
B column
=A2
=A2
=A2

what I want:
=A2
=A3
=A4

but if I put the cursor in the cell (e.g. in cell with formula =A3) and press "Enter", the value returns back to normal

How can explain this? memory problem or what?
hkgalAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
Looks like you may have calculation set to manual. Press F9 key to manually re-calculate

Depending on version you can set to automatic calculation. In Excel 2003 use

Tools > Options > Calculation > Automatic

In Excel 2007 it's in the formulas tab, at the right....

regards, barry
0
 
patrickabConnect With a Mentor Commented:
hkgal,

If you haven't solved the problem, try copying and pasting the formula from the source cell into the target cells. The cell references within the formula should autocorrect for each new cell.

Patrick
0
 
patrickabCommented:
hkgal - Thanks for the points - Patrick
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.