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/ex...045691033.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

What is the formula that is giving you the error?

Tyro

"GollyJer" <(E-Mail Removed)> wrote in message
news:C90461A9-7644-4207-8048-(E-Mail Removed)...
>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/ex...045691033.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

"Tyro" <(E-Mail Removed)> wrote in message
newsO%xj.4542$(E-Mail Removed)...
> What is the formula that is giving you the error?
>
> Tyro
>
> "GollyJer" <(E-Mail Removed)> wrote in message
> news:C90461A9-7644-4207-8048-(E-Mail Removed)...
>>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/ex...045691033.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
>
>

So, Excel is not giving you an error.

Tyro

"GollyJer" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> uhm... "The only problem is every formula is calculating correctly."
> A search for # in values & formulas in the workbook returns nothing.
>
> -Jeremy
>
> "Tyro" <(E-Mail Removed)> wrote in message
> newsO%xj.4542$(E-Mail Removed)...
>> What is the formula that is giving you the error?
>>
>> Tyro
>>
>> "GollyJer" <(E-Mail Removed)> wrote in message
>> news:C90461A9-7644-4207-8048-(E-Mail Removed)...
>>>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/ex...045691033.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
>>
>>

What is Advanced Name Manager, and where did you get it?


Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm

"GollyJer" <(E-Mail Removed)> wrote in message
news:C90461A9-7644-4207-8048-(E-Mail Removed)...
>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/ex...045691033.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

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.



"Charles Williams" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> What is Advanced Name Manager, and where did you get it?
>
>
> Charles
> __________________________________________________
> Outlines for my Sessions at the Australia Excel Users Group
> http://www.decisionmodels.com/OZEUC.htm
>
> "GollyJer" <(E-Mail Removed)> wrote in message
> news:C90461A9-7644-4207-8048-(E-Mail Removed)...
>>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/ex...045691033.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
>
>

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


"GollyJer" <(E-Mail Removed)> wrote in message
news:761E032F-5252-4CD4-99D6-(E-Mail Removed)...
> 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.
>
>
>
> "Charles Williams" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> What is Advanced Name Manager, and where did you get it?
>>
>>
>> Charles
>> __________________________________________________
>> Outlines for my Sessions at the Australia Excel Users Group
>> http://www.decisionmodels.com/OZEUC.htm
>>
>> "GollyJer" <(E-Mail Removed)> wrote in message
>> news:C90461A9-7644-4207-8048-(E-Mail Removed)...
>>>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/ex...045691033.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
>>
>>