Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have lets say 40ish objects on one sheet and 25ish of them are Charts. Most of the objects are hidden though and only a few are displayed at one time. However these objects aren't the quickest and that could be becasue of a few things. One thing I was wondering though is if having 20 objects that are hidden could affect the performance?
Thanks,
Bryan
Hi,
No, hidden objects are not calculated. However, if they have a very complex, say, several nested if() in their show/hide condition, that might affect, as any click requires all the show condition to be refreshed in case they should change their state.
Is that the case?
The easiest way to test whether or not they are impacting performance is moving those hidden objects to a new, hidden sheet.
Miguel
Yes that is the case. They aren't heavy If's but there are a lot of them. I'll go ahead and test what the timing is when the other objects are on a different tab.
Thanks for the help