eomonth quit working

[foxguy]

I'm using an unfamiliar computer because mine is in the shop.

I opened a file that has worked for 2 years, and one of the cells that uses "EOMONTH()" had "Name ?" error in it. After playing around with it, ALL the cells that "EOMONTH()" in them had the "NAME ?" error.

I reinstalled Excel, opened an empty workbook and EOMONTH does not work in the new workbook.

Am I missing something?

[Colin Legg]

Hi,

I assume this is pre XL 2007. Make sure you have the analysis toolpak ticked in your addins.

[foxguy]

Thanks, that appears to be my problem.

Do you know where there is a list of all the functions that are in an add-in, not in plain Excel.

[Cutter]

Here's a list of what's in the ATP

http://support.microsoft.com/kb/121730