MS Visio: How to synchronize multiple cells beetween beetween multiple master instances in different pages?
Posted on 2016-08-12
I have build a system in Visio 2013 back ago, and now my client wants to synchronyze multiple cells beetween multiple master instances in different pages. Each page has 100+ master instances, each master has 10+ cells to be synchronized. So in each master's cell I entered a formula like this:
and so on.
that works well to the synchronize purposes, but it will take a LOT of time to synchronize all the master instances.
I want to take the approach to make the "MasterInstanceID.000001" a variable in the formula, related to a User Defined cell, so I only have to change the 000001 number once in each master instance, and not in each shapesheet cell, when I have had applied the changes in the master, and all the master instances being actualized. I can't use the EVALTEXT() function, because I'm not allowed to change the text displayed by the master instance.
Any ideas? Best regards.