Testing Name Resolution
Posted on 2011-02-28
Is there any inbuilt way to test the resolution of all in all formulas in a workbook?
For example, if a cell has this formula...
=IF(Month(Now())=1, MyJanuaryValue, "It's not January!")
...I would have no way of knowing if the name "MyJanuaryValue" actually resolved to anything unless it actually were January now, in which case the formula would yield "#NAME?". In fact, without looking into the formula I wouldn't even know if it contained any names at all. The point is, I want to audit my workbook for invalid names. Parsing every formula is a pain. Is there a better way?