Office 2007 Compatibility Issues – _xlfn prefix error in Excel 2003

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 […]