Calculation Problem

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
 
D

Dave Peterson

Maybe you have calculation set to manual.

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

sb1920alk

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
You don't currently have permission to access this folder 0
Word 2003 won't exit 8
Excel does not accept text format! 0
Problem with Right Justified 1
Merging from an Excel file with graphics 1
Visio Utilizing 100% Memory - Troubleshooting 0
Blocking junk email 0

Top