Hi! I am working on a Visio (Visio 2010, but I'm not sure if that makes a difference), and I have the following formulas in user-defined cells:
- Formula that lists a bunch of values, and the values come from a shape's text. Here is the formula:
The values are: 0;0;0;0;0.157 (list is longer, but you get the idea)
When I change the value in "Sheet.906," this list does update. So, I changed the values from "0;0;0;0;0.157" to "0;0;0;0;0.16" and User.WeldingValues did update accordingly.
- I am then using an INDEX/LOOKUP formula to find the correct value in this list. Here is that formula:
(User.ZetaValues in a similar list to the above, and comes from another shape's text).
When I change the text in shape "Sheet.906," User.WeldingValues changes as stated above, but User.ToWelding does not update. Therefore, User.ToWelding should have found the 0.157 value, which it did, but it did not update to 0.16 when I changed "Sheet.906."
Why is this? Are there rules around ShapeSheet formula updates of which I am not aware?
Thank you so much in advance for any help that can be provided!