Worksheet NOT updating

G

Guest

I removed a group of numbers from a series of columns which were summed into
totals. The removal didn't cause the totals to change. I don't know why it
is not updating or refreshing to new results. Anyone have a suggestion?
 
M

Max

Rough Trade said:
I removed a group of numbers from a series of columns
which were summed into totals.
The removal didn't cause the totals to change.
I don't know why it is not updating
or refreshing to new results. Anyone have a suggestion?

One guess .. The calc mode could have been
inadvertently set to Manual.

Try one quick check, press F9.
Does it now compute ?

To check / change the calc mode:
Click Tools > Options > Calculation tab
Check "Automatic" > OK

---
 
G

Guest

How about when the calculation is set to automatic, and the worksheet does
not update. This happens infrequently, and CTRL + ALT + F9 is required. Any
better solution?

Jerry
 

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

Top