Calculations not changing in cells

[Guest]

I am editing numbers in cells but when I do, the spreadsheet does not
recalculate the new total at the bottom of the column even though formula was
working correctly yesterday. Also, I put number in column
(ex: Column G Column H
row35 2500 formula (=g35*6) should calculate $15000 - it is
correct
row36 1000 formula (=g36*6) should calculate $6000 but
calculates $15000

I emailed the spreadsheet to my assistant to see if she could work with it
and the spreadsheet works correctly on her pc.

 

[Pete_UK]

Check out Tools | Options | Calculation (tab) - you might have this set
to manual, so change it to automatic, then OK.

Hope this helps.

Pete

 

[davesexcel]

I am wondering if your excel is not set to automatic calculation

goto ,tools, options,calculate, set calculate to automatic

Hope this works