formula help

  • Thread starter Thread starter ther
  • Start date Start date
T

ther

I was running a spreadsheet with multiple formulas, basically it adds
few cells and gives a result. The problem i encountered now is tha
when the values in the cells are changed, the formula won't ad
them!!.
i tried creating in a blank cell a basic add formula with 3 cell as th
source for the addition. it worked. but when i changed the value of on
of the cells the total didn't change.
Anyone has any ideas?
Thank
 
Calculation may be set to manual. To change it to Automatic, choose
Tools>Options.
 
ther

Just to try to clarify Debra's response.

Excel takes the Calculation mode of the first workbook it opens for a session.

If first book opened was saved with manual calculation and you open other
books, they will also have manual calculation even if they were saved as
"auto".

Gord Dibben Excel MVP
 
Back
Top