ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   track changes (https://www.excelbanter.com/excel-discussion-misc-queries/166756-track-changes.html)

fsmilan

track changes
 
I have a complex workbook with many sheets and links between cells.
I would like to see which cells change if I enter a someting in one cell
(e.g. A1). With using "track changes" toolbar I can only see the cells which
are directly dependent of A1. But I would like to see those cells which are
not directly related to A1.

I would need a solution without pressing "Trace Dependents" several times.
My file is too big for thismethod.

Thank you
Milan


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

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