formulas and cells

A

Aamir

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
 
B

Bill Kuunders

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.
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top