_xlfn prefix
 

Hi all,

I have a "true blood" XL 2007 .xlsb workbook that was created in XL 2007.
There are no workbooks open in compatibility mode anywhere. The workbook
however does contain links to a 2003 workbook (currently closed.)

In my Range name list, I have a range name _xlfn_IFERROR with a value of
#NAME. I am using IFERROR functions embedded in the 2007 workbook not
relating to "linked" cells.

According to the Help file (Search for IFERROR then select the item Issue:
An _xlfn prefix is displayed ...", it states "The Microsoft Office Excel
Workbook contains a function that is not supported in the Version of Excel
you are running." Fair enough.

My question is - is the integrity of the IFERROR statement affected by the
fact that there are links to a previous version of Excel? Can I still trust
the result?

Thanks for reading this.

Regards,
Bony

--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."

_xlfn prefix
 

Can I still trust the result?

I don't know. However, when there might be version compatibility issues, why
not use the equivalent IF(ISERROR which will work in any version of Excel?

--
Biff
Microsoft Excel MVP


"Bony Pony" wrote in message
...
Hi all,

I have a "true blood" XL 2007 .xlsb workbook that was created in XL 2007.
There are no workbooks open in compatibility mode anywhere. The workbook
however does contain links to a 2003 workbook (currently closed.)

In my Range name list, I have a range name _xlfn_IFERROR with a value of
#NAME. I am using IFERROR functions embedded in the 2007 workbook not
relating to "linked" cells.

According to the Help file (Search for IFERROR then select the item Issue:
An _xlfn prefix is displayed ...", it states "The Microsoft Office Excel
Workbook contains a function that is not supported in the Version of Excel
you are running." Fair enough.

My question is - is the integrity of the IFERROR statement affected by the
fact that there are links to a previous version of Excel? Can I still
trust
the result?

Thanks for reading this.

Regards,
Bony

--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."