I'm not sure if I'm phrasing the title of my post correctly, but I'm looking for a way to find all of the cells that are driven by one particular cell. For example if I have:
In sheet1 A1 I have the value 10
In sheet1 A10 I have the formula =average(A1:A9)
In sheet2 A1 I have =Sheet1!A1
In sheet3 C20 I have =sumifs(Sheet1!A:A,Sheet1!A:A,12)
Now I want to find all of the cells driven by Sheet1 A1, I'd expect some list or result to include Sheet1 A10, Sheet2 A1, and Sheet3 C20.
Is ther a way to do this? I'm wondering because I'm trying to change the value of a cell, but don't want to mess up any other claculations of a very large workbook, so I'd like to see what cells are being driven by the cell I propose to change before actually making the change.
I already tried putting in Sheet1 =aaa to get a #name? error and seeing where else that pops up in the workbook, but the problem is, if cells were linked to a cell that is linked to the actual cell in question would also throw an error.
In sheet1 A1 I have the value 10
In sheet1 A10 I have the formula =average(A1:A9)
In sheet2 A1 I have =Sheet1!A1
In sheet3 C20 I have =sumifs(Sheet1!A:A,Sheet1!A:A,12)
Now I want to find all of the cells driven by Sheet1 A1, I'd expect some list or result to include Sheet1 A10, Sheet2 A1, and Sheet3 C20.
Is ther a way to do this? I'm wondering because I'm trying to change the value of a cell, but don't want to mess up any other claculations of a very large workbook, so I'd like to see what cells are being driven by the cell I propose to change before actually making the change.
I already tried putting in Sheet1 =aaa to get a #name? error and seeing where else that pops up in the workbook, but the problem is, if cells were linked to a cell that is linked to the actual cell in question would also throw an error.