Excel for Mac SR1 installed on MacBookPro won't automatically calculate

[Nick]

I've just upgraded from a PowerBook G4 to a MacBookPro 2.33 GHz Intel
Core 2 Duo with 2GB 667 MHz DDR2 SDRAM. I installed Office:mac v.X on
the new computer. Excel spreadsheets won't calculate. I have verifies
that Preferences/Calculation is set to automatic, but formulas in cells
display as formulas, not values. Does anyone have any ideas how I can
correct this short of buying the newer version of Office for Mac OS X?

Thanks, Nick

 

[Ken Johnson]

I've just upgraded from a PowerBook G4 to a MacBookPro 2.33 GHz Intel
Core 2 Duo with 2GB 667 MHz DDR2 SDRAM. I installed Office:mac v.X on
the new computer. Excel spreadsheets won't calculate. I have verifies
that Preferences/Calculation is set to automatic, but formulas in cells
display as formulas, not values. Does anyone have any ideas how I can
correct this short of buying the newer version of Office for Mac OS X?

Thanks, Nick

Cells with the formulas formatted as Text is one possible cause.
Another is Preferences|View|Window Options...Formulas is ticked.

Ken Johnson

 

[little_creature]

Another posibility - check your "international" setting in "system
preferences", what is set as decimal point separator - but do not relly on
it.

I'm desperately longing for DOT as decimal point separator - all others
application will load setting from system pref. (the DOT) but NOT EXCEL -
still uses comma and then numbers with dots are asummend to be text rather
then numbers and excel will not calculate.
There's a know issue with language preferencences and office.