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 - 29 Mar 2006 00:28 GMT
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 - 29 Mar 2006 00:32 GMT
I am wondering if your excel is not set to automatic calculation
goto ,tools, options,calculate, set calculate to automatic
Hope this works

Signature
davesexcel