ExcelBanter

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/74777-formula-auditing.html)

Jeff

Formula Auditing
 
I want to use the "Trace Dependents" when the dependent cell is in another tab.

When this happens a little mini square icon appears. But there does not
appear to be any way of telling which tab or cells in the tab are dependent.

Is there anyway to get this info?

Thanks for your help

Max

Formula Auditing
 
Try double-clicking on the arrow which points to the mini square icon
The info will show in the "Go To" dialog which pops up.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jeff" wrote in message
...
I want to use the "Trace Dependents" when the dependent cell is in another

tab.

When this happens a little mini square icon appears. But there does not
appear to be any way of telling which tab or cells in the tab are

dependent.

Is there anyway to get this info?

Thanks for your help





All times are GMT +1. The time now is 10:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com