formulas and cells
 

Wanted to know if any of you have experienced this, and if there is a solution:
I established a spreadsheet using a number of different formulas for a
number of cells. For sometime everything worked nicely, but then one or two
cells which were to give results based upon the formula established in the
formula bar, did not make any changes. With the cursor in that cell, the
formular bar would still show the formula entered, but it was not doing any
good to the value in the cell. This value remained the same as for an earlier
calculation. I rebooted the computer, when it worked the first time, but then
again the same thing in a couple of cells.

Thank you.
Aamir

go to

<tool<option<calculations and set it to automatic.
you may have had an other sheet open where this option was set to manual.

--
Greetings from New Zealand
Bill K
"Aamir" wrote in message
...
Wanted to know if any of you have experienced this, and if there is a
solution:
I established a spreadsheet using a number of different formulas for a
number of cells. For sometime everything worked nicely, but then one or
two
cells which were to give results based upon the formula established in the
formula bar, did not make any changes. With the cursor in that cell, the
formular bar would still show the formula entered, but it was not doing
any
good to the value in the cell. This value remained the same as for an
earlier
calculation. I rebooted the computer, when it worked the first time, but
then
again the same thing in a couple of cells.

Thank you.
Aamir

Try Tools Options CalculationTab see if "manual" or "automatic" is
checked..........you want "automatic"

Vaya con Dios,
Chuck, CABGx3



"Aamir" wrote in message
...
Wanted to know if any of you have experienced this, and if there is a
solution:
I established a spreadsheet using a number of different formulas for a
number of cells. For sometime everything worked nicely, but then one or
two
cells which were to give results based upon the formula established in the
formula bar, did not make any changes. With the cursor in that cell, the
formular bar would still show the formula entered, but it was not doing
any
good to the value in the cell. This value remained the same as for an
earlier
calculation. I rebooted the computer, when it worked the first time, but
then
again the same thing in a couple of cells.

Thank you.
Aamir