Here is a simple scenario:
a document with 3 sheets
- the first and the second are shown according to the value of Seconds(Now()) with conditional view (for example when seconds
are between 1 and 30) in this way I want to hide and show sheets to obtain a dynamic presentation.
- The third sheet (even if you don't need it, you can use one of the previous) contains a chart (bar or line) in which I have
an animated dimension.
The problem is that animation reset each seconds, it seems that Now() in other sheets triggers the animation
Can someone help me?