Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I make a selection on one sheet, at what point in time are the visualizations on non-active sheets calculated? Is it when I make the selection or when I navigate to the non-active sheet.
Thanks,
Mark
Sheet objects are rendered and therefore calculated when the sheet is activated. So by changing to a sheet the objects will be recalculated and rendered. Changing selections while on a sheet will also trigger a recalculation. Objects on non-active sheets are not recalculated when selections change. The same applies to hidden objects on an active sheet unless they contain expressions that are used to determine if they're shown or not.