Yes, I have. I was able to solve the problem. I changed my macro security
setting from "High" to "Medium". Then when you are asked to accept macros
(when you open the file in question), you say yes. I guess the EOMONTH
function, or the ATP add-in, requires a macro?
Thanks for your reply. This discussion group seems like a pretty handy
resource. I frequently have detailed Excel questions, and don't know where
to turn.
Regards,
Jeff
"RagDyer" wrote:
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?
|