What is the most straightforward way to find all references to a User cell?

Started by Visisthebest, August 23, 2023, 10:11:42 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Visisthebest

To check if there are dependencies with a certain user cell in a Visio document, I need to go through all the shapes in a document to see if any cell there references this particular cell.

Let's say the:
User.WhoReferencesMe cell in the document shapesheet.

Is there a built-in way in Visio to see which cells in all the Visio shapes in this document references this cell, other than to loop through all the shapes and all their cells?
Visio 2021 Professional

Surrogate

Quote from: Visisthebest on August 23, 2023, 10:11:42 AM
Is there a built-in way in Visio to see which cells in all the Visio shapes in this document references this cell, other than to loop through all the shapes and all their cells?
Please try Cell.Dependents and Cell.Precedents properties...

Visisthebest

Surrogate I didn't know this function exactly what I was looking for thank you!
Visio 2021 Professional

Nikolay

Hm there is a formula tracing directly in the shapesheet??
To navigate to the child/parent formula you just click a row in that sidebar window.

Visisthebest

Thank you for pointing this out Nikolay I didn't know about this functionality as well! Very handy.
Visio 2021 Professional