ExcelBanter - Formula Auditing

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula Auditing (https://www.excelbanter.com/excel-discussion-misc-queries/190109-formula-auditing.html)

Nav

Formula Auditing

Hi

When I click on the trace dependents on a particular cell, a table like icon
appears. Is there any way I can find out which table (sheet and cell) this
actually feeds into?

All help appreciated, thanks in advance.

Regards,
Nav

Mike H

Formula Auditing

Hi

You don't give an Excel version but you try double-clicking the dotted line
between the cell and the table icon.

Mike

"Nav" wrote:

Hi

When I click on the trace dependents on a particular cell, a table like icon
appears. Is there any way I can find out which table (sheet and cell) this
actually feeds into?

All help appreciated, thanks in advance.

Regards,
Nav

Nav

Formula Auditing

Sorry - it was Excel 2003 SP2.
But this works, thank you for your help.

"Mike H" wrote:

Hi

You don't give an Excel version but you try double-clicking the dotted line
between the cell and the table icon.

Mike

"Nav" wrote:

Hi

When I click on the trace dependents on a particular cell, a table like icon
appears. Is there any way I can find out which table (sheet and cell) this
actually feeds into?

All help appreciated, thanks in advance.

Regards,
Nav

All times are GMT +1. The time now is 05:57 AM.