Cells not updating/formulas not calculating

Asked by pgrmdave

For some reason, the formulas in my spreadsheet aren't automatically calculating anything. If I change the data that the formulas use, the result stays the same until I click the formula button, 'f(x)', and walk through each step. For example:

I set cell A1 to 5
I set cell A2 to 6
I set cell B1 to "=A1+A2"
At this point, B1 = 11
I change cell A1 to 3 and cell A2 to 5
At this point, B1 still = 11
I hit 'f(x)' and hit ok
B1 changes to 8

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
DrewJensen
Solved:
Last query:
Last reply:
Revision history for this message
Best DrewJensen (atjensen) said :
#1

Looks like you inadvertantly turned off auto-calculate

With Calc open select the menu
Tools>Cell Contents>AutoCalculate

Make sure there is a tick mark there.

HTH

Drew

Revision history for this message
pgrmdave (pgrmdave) said :
#2

Thanks DrewJensen, that solved my question.