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!!