Excel 2007 - Data May Be Lost - MRound function replaced with #N/A?

[Steve McDonald]

I am one of the first people in my organisation to have Office 2007
installed - the majority of other users are still on Office 2003. As a
result, I have to keep all my workbooks in Office 2003 format.

The problem I have is that the message 'File error: Data my be lost'
is frequently displayed when I open one of these workbooks and then
several formulae are replaced with '#N/A'. I then have to go through
and re-enter all the formulae. It's worth noting that this doesn't
happen every time I open a workbook but after it's happened to a
particular workbook once it will happen every time I open that file,
even if I don't save it.

It would seem that it's got something to do with the functions MROUND
and NETWORKDAYS, which used to be included in the Excel 2003 Analysis
TookPak. Does anyone know of any add-in, patch, etc that I can
installed to get round this as I use these functions all the time and
it's getting very tedious!

Thanks

Steve

 

[Pete_UK]

Those ATP functions are now built in to XL2007, so you can use them as
if they are native functions. However, if you save the file as 97/2003
compatible, those were not native functions, so I imagine that Excel
treats them as unknown - I would have expected #NAME errors, though,
not #N/A.

I use XL2000 and avoid all of the ATP functions as I can't guarantee
that users will have it installed. There are usually other ways of
achievng the same results without using those functions.

Hope this helps.

Pete