 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008_xlfn.IFERROR = #NAME? in Advanced Name Manager
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 What is the formula that is giving you the error? Tyro >I keep getting a "formula can't calculate" error in one of my workbooks. >The only problem is every formula is calculating correctly. [quoted text clipped - 12 lines] > Thanks, > Jeremy uhm... "The only problem is every formula is calculating correctly." A search for # in values & formulas in the workbook returns nothing. -Jeremy > What is the formula that is giving you the error? > [quoted text clipped - 16 lines] >> Thanks, >> Jeremy So, Excel is not giving you an error. Tyro > uhm... "The only problem is every formula is calculating correctly." > A search for # in values & formulas in the workbook returns nothing. [quoted text clipped - 21 lines] >>> 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 >I keep getting a "formula can't calculate" error in one of my workbooks. >The only problem is every formula is calculating correctly. [quoted text clipped - 12 lines] > 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. > What is Advanced Name Manager, and where did you get it? > [quoted text clipped - 19 lines] >> 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 > Wow. This is the first time I've gotten responses that have little to do > with my problem on this board. :-P [quoted text clipped - 37 lines] >>> Thanks, >>> Jeremy
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.