Yes, it is in automatic calculation mode.

"DallasLDY" wrote:

I have several spreadsheets and I made changes to a LOT of formulas using the
EDate function. I have the Analysis Tool Pack add-in checked in Excel. It
all worked fine yesterday.

Today, if I open the ss, I get the #NAME error. I have to go to Add Ins,
uncheck the Analysis Tool Pack, hit okay, then go back and re-activate it in
order to make my formula calculate. I save and close the spreadsheet, and I
open it again with the same error.

Is this a bug or does anyone know what is going on? Please help. I have
used this function in about 200 ss's in about 50 fields per ss!

These ss's are shared, and I've asked everyone who uses them to activate the
add-in. Can you help me?