Calculation Problem

  • Thread starter Thread starter Jason Zischke
  • Start date Start date
J

Jason Zischke

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.
 
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.
 
Back
Top