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