Excel - autofill formula but doesnt calculate? 1

[rcrecelius]

This is probably an easy one but I'm stumped and in a hurry.

The formula is =B13 but when I copy it down, the formula copies(=B14, =B15, etc) but all cells display the value from B13. If I go to each cell and click in the formula bar, it will then calculate and display the correct value.
I realize I could just copy/paste but I dont want this quirk to sabotage me later in the project.

 

[AnotherHiggins]

Tools > Options go to the Calculation tab. It sounds like you have Manual chosen right now. Change that to Automatic.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[rcrecelius]

That was it...I knew it had to be something simple.

 

[RandDUser]

You could also press F9, and all the cells will refresh their calculation.