I sometimes use some functions that require the analysis toolpack, the basic
EXCEL one, not the VBA one. A typical function is eomonth(date, # of
months), which finds the ending date of the month that is so maybe months
later.

I notice that, when I save a file with this function, though there is no
message asking me to update links, when I re-open this file, there is a link
when I go to edit links, showing ATPVBAEN.xla. I'm not sure it was this way
before. I occasionally get messages suggesting the add-ins are not
installed even though clearly they are, since the equation is still there
and changes when I change the date it is computing from. In any event, I
also sent such a file to someone else to use and he ended up losing all
cells that had this eomonth function in them - they all show up as =#N/A,
though the right answer is still there, probably because he did not update
links, or maybe because he did. In any event, he loses the equations. I
even notice that when I open this file, sometimes, I see the formula change
so that, in the formula bar, it shows something like
atpvbaen.xls//eomonth(x,y), which seems the cause of the problem.

My first question is whether this link to ATPVBAEN.xla should show up as a
link, under edit links - can someone else try it on their computer - just
type =eomonth (a1,1) into cell a2 with any date in cell a1 - and tell me if
a link to atpvbaen.xla shows up for them (assuming you have the analysis
toolpak installed)? Also, how can I fix things so that, when I send the
file to someone else, he won't have the problem with his computer not being
able to find this link? Can he just change the source, assuming he can find
his own ATPVBAEN.xla file? Also, I think he has upgraded to EXCEL 2007,
which may not deal with add-ins in the same way.

Help, please!

Thanks
Dean