EOMONTH error in Excel 2007

[scanavan10]

Hi,

I've just upgrade to 2007, to encounter numerous problems. The most frequent error ir the eomonth function being replaced wtih #N/A in files saved in 2003 format due to the need to distribute the file to other people.

I believe this is because there is no separate need for the Analysis Toolpack in Excel 07. Does anyone have a fix for this problem that will allow me to keep the file in 2003 format?

Thanks

Stephen

 

[shg]

Should be fine if the 2003 users have the ATP installed.