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...
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
Hi Catalin,
Thank you. This was very helpful. Sorry for the late reply.
Scotty81