ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tracking Linked Cells (https://www.excelbanter.com/excel-discussion-misc-queries/121663-tracking-linked-cells.html)

vpoincelot

Tracking Linked Cells
 
I recently aquired a large workbook with many linked worksheets. I can track
the linked cells back to the original worksheet, but is there anyway to
select a cell on an original worksheet and see where it feeds to?

Dave F

Tracking Linked Cells
 
I don't believe XL has such a feature, however John Walkenbach's Power
Utility Pak has a robust formula auditing feature that allows you to see a
summary of a cell's precedents and dependents.

Dave
--
Brevity is the soul of wit.


"vpoincelot" wrote:

I recently aquired a large workbook with many linked worksheets. I can track
the linked cells back to the original worksheet, but is there anyway to
select a cell on an original worksheet and see where it feeds to?



All times are GMT +1. The time now is 09:54 PM.

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