Hi,

Try unticking the box and test it, the XIRR function is now a native
Office 2007 function, there is an MS article about this at
http://support.microsoft.com/kb/912719

Thanks,

Amit


"nguyensea" wrote:

Does this mean that I should uncheck the Analysis ToolPak box in order to
make EDATE and XIRR functions work? Thanks.

"Mike Middleton" wrote:

Your problem may depend on how your template sheet uses the Analysis ToolPak
functions, since in Excel 2007 those functions are fully integrated into the
Excel function library. That is, you can use those worksheet functions
without having the "Analysis ToolPak" box checked in the Add-Ins manager.
For example, see

http://blogs.msdn.com/excel/archive/...20/483205.aspx

- Mike
www.MikeMiddleton.com


"amcnelis" wrote in message
...
Yes, I'm having the same issue using the function EDATE. Did you find a
solution?

Alison

"Amit" wrote:

Hi,

We have a template sheet we generate in Excel 2003 which uses the
Analysis
ToolPack references such as :

=EOMONTH(K42,6)
=XIRR(L42:L47,K42:K47)

Our users have used the templates and edited and saved their copies using
Excel 2003 and we have recently been moving to 2007 and have found that
when
they open their versions in 2007 we will often get the error:

File error: data may have been lost.

I have checked the compatibility checker in 2007 and it does not give us
any
warnings. We do have some of our add-ins but these seem to behave. Also
we
notice that in the name manager that our references will often get
deleted
and removed and replaced with #N/A in some of the users 2003 Excel files.


Has anyone had the same occurrence at all.

Many Thanks,

Amit