excel 2003 not calculating

[stew]

Hi All

Is there any particular thing that would stop excel from calculating. It was
taking entries but formulas where not producing results and only previous
results were being displayed. I have rebooted my spread sheet from a previous
back up and all is now working . I am just a bit concerned it is something I
did unknowingly

Stew

 

[Gary''s Student]

Tools > Options... > Calculation > Automatic

 

[Pete_UK]

You probably had the calculation mode set to manual - this setting can
be picked up from another workbook opened in the same Excel session.
Click on Tools | Options | Calculation tab and check Automatic to
return it to the usual setting, and then save your file.

Hope this helps.

Pete

 

[Sandy Mann]

Excel takes the Automatic/Manual calculation setting from the first Workbook
opend in that session. The setting can be changed without having to reboot
by selecting: Tools > Options Calculation and selecting Automatic.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[stew]

THANKS EVERYBODY, DON'T KNOW HOW IT HAPPENED , BUT NOW I KNOW

STEW