I am trying to implement a "conditional show" for container objects.
The condition I am using is:
=Divison='ABC' or =Division='DEF'.
So dependant on the division selected by the user only the corresponding container objects should be shown.
I am using the same condition for chart objects and it works perfectly, but it doesn't work properly for CT objects, as I am loosing them either completely or sometimes, they just appear independant of the division selected.
When I go to sheet properties->objects, I can still find them in the list, but I can't get the back unless I remove the objects within a container. Once I do that, I see the empty container on the sheet and have to add the objects again.
Did anybody face similar issues or has an idea, what is going wrong?