Have you installed the ATP add-in first?
--
Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"jefftlewis" wrote in message
...

Yes, i'm having the same exact problem. I tried the suggestion below by
Ragdyer, but it does not seem to work.

The excel file that is showing the "#NAME?" was created about 10 years
ago,
so the problem seems to have to do with newer versions of Excel trying to
use
an Excel file created many years prior.

If anyone has any further suggestions, I'd love to hear about them.

My only option it seems is to rewrite all the formulas that use EOMONTH.

Thanks, Jeff



"Ragdyer" wrote:

Try re-registering the formulas *after* you install the Add-In.

Select a range of cells containing some of these formulas, then:

<Edit <Replace
In "Find what", enter
=
In "Replace With", enter
=

Then <Replace All
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Ray" wrote in message
...
I have used the EOMONTH function successfully. But I transferred my
workbook
to someone who did not have the needed add-in installed so it
generated a
#NAME? error. So I installed the add-in on his computer but it did not
resolve the #NAME? error. I took his workbook and put it back on my
computer
and it still generates the #NAME? error. But if I open my original
file
the
EOMONTH works. I can flip between the two open workbooks and see the
error
on his file, but not on mine. Tried F9 to force a recompute, no help?
Any
ideas?