Excel formula only working after saving 2

[guymason]

Very odd, if I write a formula and then use Autofill to run it down a column, the formula shows the value of the first cell in all the other cells. Then if I press 'Save' it will calculate properly and change the values to the correct values. Why is this happening?

Cheers
Guy

 

[Bowers74]

Under Tools->Options... in the "Calculation", check to see if the "Calculation" is set to "Automatic" or "Manual"

;-)



Peace!!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[mrsnrub]

It sounds like you may have your calculation settings switched to 'Manual'. Under the Tools menu choose Options and then select the 'Calculation' tab. Change your 'Calculation' option to 'Automatic'.

I hope this helps.

 

[mrsnrub]

Oops.. looks like you beat me to that Submit button Bowers74!!

 

[guymason]

Excellent, thanks both of you.

gh