Computing.Net > Forums > Office Software > excel won't update the numbers

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

excel won't update the numbers

Reply to Message Icon

Name: Azen
Date: September 5, 2008 at 01:21:00 Pacific
OS: WinXP
CPU/Ram: Intel T7400 / 2G
Product: Asus
Comment:

I''m working on my computer as usual, and after I open another excel file from my co-worker, all the formulas freeze. For example, cell A is 1, cell B is 2 and cell C is the total of cell A and B, which is 3. Originally, when I change the number in cell A to 6, the number C will change to 8. Now, I have to double click on cell C and hit enter and then cell C changes to 8.

Hello!



Sponsored Link
Ads by Google

Response Number 1
Name: Jennifer SUMN
Date: September 5, 2008 at 03:20:12 Pacific
Reply:

This is normal behavior. The calculations won't reflect the correct information until the cell "accepts" the new number.

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown


0

Response Number 2
Name: DerbyDad03
Date: September 5, 2008 at 06:23:38 Pacific
Reply:

I guess that depends on your definition of "normal".

This would only be "normal" behavior if your Calculation option was set to manual, which I'll wager is extremely rare for most users.

While it may be true that you might have to take some action to have the data "accepted", most users do not have to double click on the cell containing the formula and hit enter. Typically most users can simply hit Enter or Tab or an Arrow or click anywhere in the sheet, etc. after typing in the new data.

Look at:

Tools > Otions > Calculation Tab > Automatic



0

Response Number 3
Name: Azen
Date: September 7, 2008 at 17:36:16 Pacific
Reply:

DerbyDad03:
Thanks, I will check the option

Hello!


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: excel won't update the numbers

Excel won't start www.computing.net/answers/office/excel-wont-start/3520.html

Word links to Excel won't update www.computing.net/answers/office/word-links-to-excel-wont-update/6524.html

Excel won't open a file www.computing.net/answers/office/excel-wont-open-a-file/8833.html