Forum

How to trace all de...
 
Notifications
Clear all

How to trace all dependents in all cells in all tabs at once

3 Posts
2 Users
0 Reactions
160 Views
(@scotty81)
Posts: 46
Trusted Member
Topic starter
 

I inherited a rather complex spreadsheet and I see there are dependencies not only from cell to cell within a tab but also between tabs.  There are some external links too.  I know how to identify external links, and I know how to use cell auditing to trace dependencies for a single cell.

What I'm looking to find is a solution, likely a VBA one, to list all cell dependencies between tabs.  Although it would be nice if I could see dependencies within a tab, I'm less concerned with that now.  I am more focused on identifying the dependencies between tabs.  And although I could do that manually, that would be a time consuming exercise given the complexity of the spreadsheet. 

If you think of the various tabs of a house, I am just trying to reverse engineer the connections between the tabs to see if the kitchen is connected to the dining room, and what parts of the house lead to the garage.  

Although I have seen a couple of posts that mention this, I haven't been able to identify a viable piece of code.  I did see a reference to one commercial solution but this is more of 1-off need so I wasn't interested in purchasing a commercial product.  Has anyone come across such a thing before?

Thanks for checking...

 
Posted : 28/10/2023 4:44 pm
(@catalinb)
Posts: 1937
Member Admin
 

Hi Scotty,

You can adjust this code for your specific needs:
http://azlihassan.com/apps/articles/microsoft-excel/vba/show-and-navigate-formula-dependency-chain

 
Posted : 02/11/2023 11:03 am
(@scotty81)
Posts: 46
Trusted Member
Topic starter
 

Hi Catalin,

Thank you.  This was very helpful.  Sorry for the late reply.

Scotty81

 
Posted : 10/11/2023 12:25 pm
Share: