I have a challenge for the folks on this forum!
In the attached diagram, the rectangle and the page contain identical User and Prop cells. The goal is to show/hide Prop A, B, and C by using a formula in the Invisible cell for A, B, and C. Toggling the value in “Show/Hide All” should do the trick. (I’m sure many of you have done this!)
It works fine for the shape.
However, when you select the page and attempt to do the same thing, the visibility of the Prop cells in the Shape Data window does not change – despite the fact that the values in the Invisible cells in the page's ShapeSheet do change. To say that another way: The ShapeSheet is correct after the user's change but the Shape Data window does not refresh.
I found one (very clumsy) workaround: After changing "Show/Hide All" for the page, enter and then exit any cell in the ShapeSheet – no need to make any changes, just enter and exit a cell.
Visio Guy found another (less awkward) workaround: Change "Show/Hide All" for the page, click a shape, and then click back to the page.
I've reported this as a bug, but in the meantime, the challenge is this: can anyone find a ShapeSheet formula, or combination of formulae, that forces the Shape Data window to update after the user makes a change? I've tried a couple of SETF and SETATREF combinations but haven't found one that forces the Shape Data window to update.
Thanks!