Calculations not changing in cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Hope this helps.

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

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

Hope this works
 
Back
Top