Formulas not updating??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jack.steinmann@gmail.com - 24 May 2007 21:15 GMT

I have used Excel 2004 for the Mac on my PowerBook for years.

Today, for the first time ever, my totals are not recalculating when I
change individual figures. Doesn't matter if my additon formula is a
sum of cels or each cel added together.

I can't figure out if I've changed a preference setting or what, but I
have to keep reinserting the addition forumla to get a correct total.

What am I doing wrong?

Thanks,

Jack Steinmann

Reply to this Message

JE McGimpsey - 24 May 2007 21:59 GMT

> I have used Excel 2004 for the Mac on my PowerBook for years.
>
[quoted text clipped - 6 lines]
>
> What am I doing wrong?

Try Preferences/Calculation/Automatic

Reply to this Message

CyberTaz - 24 May 2007 22:03 GMT

The first thing to confirm is Excel>Preferences>Calculation, make sure it's
set for Automatic. If that isn't the fix, post back with as much additional
detail as possible... Exact version of OS & Office, all workbooks or just a
specific one, anything else including 3rd party add-ins?

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 5/24/07 4:15 PM, in article
1180037732.582574.152200@k79g2000hse.googlegroups.com,

> I have used Excel 2004 for the Mac on my PowerBook for years.
>
[quoted text clipped - 10 lines]
>
> Jack Steinmann

Reply to this Message

Mac Forum / Applications / Excel / May 2007

Formulas not updating??