ace wrote:
Thanks to all of you smart people who knew the answer to my problem. It was
in fact the manual setting in the formula options. My next question is, how
did it get set to Manual? :-)


Excel uses the calculation setting from the first workbook that is opened.