Hi All

I have a problem with a workbook doesn't seem to calculate on some cells
until I click into the cell's Formula and exit out then it finally updates.
Is any thing that could be doing that and how can I fix that?

Jason

Maybe you have calculation set to manual.

In xl2003, I'd try:
tools|Options|Calculation tab|make sure it was set to automatic.

Jason Zischke wrote:

Hi All

I have a problem with a workbook doesn't seem to calculate on some cells
until I click into the cell's Formula and exit out then it finally updates.
Is any thing that could be doing that and how can I fix that?

Jason

--

Dave Peterson

Sounds like calculations have been set to manual instead of automatic. To
switch it back to automatic, click the Tools menu, then Options. Go to the
Calculation tab and set it to automatic.

"Jason Zischke" wrote:

Hi All

I have a problem with a workbook doesn't seem to calculate on some cells
until I click into the cell's Formula and exit out then it finally updates.
Is any thing that could be doing that and how can I fix that?

Jason