Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
_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 ..." |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
_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 ..." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countifs in 2003 = _xlfn. ?? | Excel Worksheet Functions | |||
Prefix | Excel Discussion (Misc queries) | |||
SUM without prefix | Excel Discussion (Misc queries) | |||
Prefix | Excel Worksheet Functions | |||
Application prefix or not | Excel Discussion (Misc queries) |