Office 2007 Compatibility Issues – _xlfn prefix error in Excel 2003

Posted on | September 1, 2010 | No Comments

Problem: When you try opening and Excel 2007 file in earlier version of Excel, you will notice an _xlfn prefix is displayed in front of a function in a formula. When the formula is calculated, it displays the #NAME? error value.

Cause: Microsoft Office Excel workbook contains a function that is not supported in the version of Excel that you are currently running. For Ex, you may have opened a workbook that contains the ‘IFERROR’ function, which is not supported in version of Excel earlier than Microsoft Excel 2007.

Solution: Remove the unsupported functions, or if possible, replace the unsupported functions with supported functions.


Leave a Reply