_xlfn.IFERROR = #NAME? in Advanced Name Manager

  • Thread starter Thread starter GollyJer
  • Start date Start date
G

GollyJer

I keep getting a "formula can't calculate" error in one of my workbooks.
The only problem is every formula is calculating correctly.

When using Advanced Name Manager, I'm able to see a named range that looks
like _xlfn.IFERROR with a value of = #NAME?
It's not visible with Excel's native name manager. A little research turned
up this article:
http://office.microsoft.com/en-us/excel/HA102045691033.aspx
which states if you will get this error when using 2007 formulas in older
version BUT, I'm using 2007.

I'm at a loss on how to go about tackling this problem. Any help is
appreciated.

Thanks,
Jeremy
 
uhm... "The only problem is every formula is calculating correctly."
A search for # in values & formulas in the workbook returns nothing.

-Jeremy
 
So, Excel is not giving you an error.

Tyro

GollyJer said:
uhm... "The only problem is every formula is calculating correctly."
A search for # in values & formulas in the workbook returns nothing.

-Jeremy
Click to expand...
 
Wow. This is the first time I've gotten responses that have little to do
with my problem on this board. :-P

Advanced Name Manager is the name I use (of my own creation I now see) for
Jan Karel Pieterse and your Name Manager addin. Thanks for such a great
application.

It's showing me this named formula:
_xlfn.IFERROR = #NAME?
when the built in Name Manager shows nothing.

Excel doesn't throw an error on every calculation either. But sometimes it
throws "A formula can't be calculated because of missing name" or something
like that. It's not doing it now so I don't know the exact text.

This is a strange one which I'm sure will be obvious once figured out.
 
Thanks: I thought it was probably our Name Manager but the Advanced tag
threw me (mind you, I like the name <vbg>)

The reason you can see it in our Name Manager but not native Excel2007 Name
Manager is that our Name manager defaults to showing hidden names but theirs
does not seem to be able to show hidden names even if you want to.

I can see that this hidden name gets created as soon as you create a
formulae in 2007 that contains the IFERROR function, but it does not seem to
be used in XL 2007.
My guess is that it has something to do with the ability to create an Excel
2007 workbook containing IFERROR, then open it in previous versions of
Excel, recalculate it so that it gives #Name, save it and then reopen the
saved workbook in Excel 2007 - magically the IFERROR springs back to life!

But that does not explain why XL2007 should occasionally complain about
names/functions like this: we need some more clues about the circumstances
that make it happen.

Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm
 
I was wondering if a solution was ever found to this error. I recently added several Sumifs formulae to one of my workbooks and I am now receiving a similar error in the Name Manager for the Sumifs function.

Thank you for any information you might have!
 
Back
Top