_xlfn.AVERAGEIF ... How do I remove this?

**John Bates** · 08-20-2008, 05:20 PM

Hi,

I accidentally opened a 2007 Excel Workbook (containing an AVERAGEIF formula) in Excel 2003 and now I automatically have the following named range:
Name: _xlfn.AVERAGEIF
Refers to: =#NAME?

I believe it is the reason why I keep getting a popup box that says, "A formula in this worksheet contains one or more invalid references. Verify that your...etc.", whenever I try to save my file.

How do I fix this/remove it? It won't let me delete the named range.

Thanks for all your help...much appreciated!!!
John

**Paul** · 08-20-2008, 09:48 PM

Hi John,

If you have Excel 2007 available, try opening it there and deleting it (or post the file to the board and someone who has 2007 can try).

**John Bates** · 08-21-2008, 10:42 AM

Hi,

Yeah, I built it in Excel 2007 but I accidentally opened the file in Excel 2003 (I have both versions of Excel on my computer) and now the weird named range won't go away.

thanks,
John