In 2007, click the Office Button, then Excel Options and Formulas.

If this post helps click Yes
---------------
Jacob Skaria


"Neil" wrote:

Jacob
I am using Office/Excel 2007 - no 'Tools' option on the ribbon menu there.
That is the problem - nowhere to set universal defaul options.
Neil

"Jacob Skaria" wrote:

This is an application setting. ToolsOptionsCalculation..

If this post helps click Yes
---------------
Jacob Skaria


"Neil" wrote:

ans there any way that I cna set a default option so that "automatic
recalculate" becomes the default for all worksheets, old and new?
It seems silly that you have to open a worksheet saved with the automatic
recalculation option in it for other worksheets to be that way. There is no
way i can remember how I saved each and every spreadsheet I have used over
the last 10 years!!