I am wondering if there are any better tools than what appears on the "Formulas" menu as the ability to show arrows?
I have a somewhat "mystery column" in a workbook and i am trying to determine what it is used for.
One thing i have discovered is that the "dependencies" arrows do not show if a cell is used in a chart.
QUESTION 1 - Is there any way to determine if a cell is used in a chart?
Also, using the dependency arrows on cells in this column, references to a cell with a formula like this come up as a dependency:
=VLOOKUP(B57,rng_goal[#All],COLUMN(rng_goal[[#Headers],[Sl60Wtd.mo]]),FALSE)
This cell is indeed part of "rng_goal". but it is not in the column referenced by that formula.
QUESTION 2 - Is there any way to narrow the list of dependencies to exclude references to a table (such as rng_goal[#All]) that the cell happens to be in, but where its value does not affect the result of the formula evaluation?
Thanks!
I have a somewhat "mystery column" in a workbook and i am trying to determine what it is used for.
One thing i have discovered is that the "dependencies" arrows do not show if a cell is used in a chart.
QUESTION 1 - Is there any way to determine if a cell is used in a chart?
Also, using the dependency arrows on cells in this column, references to a cell with a formula like this come up as a dependency:
=VLOOKUP(B57,rng_goal[#All],COLUMN(rng_goal[[#Headers],[Sl60Wtd.mo]]),FALSE)
This cell is indeed part of "rng_goal". but it is not in the column referenced by that formula.
QUESTION 2 - Is there any way to narrow the list of dependencies to exclude references to a table (such as rng_goal[#All]) that the cell happens to be in, but where its value does not affect the result of the formula evaluation?
Thanks!