Forum Discussion
FILTER Function Lagging, alternative function for this case?
FILTER may not be the best fit for this task, but I don't believe it's causing a "lag" in the workbook. I timed several full recalculations on the workbook and the average time was about .15 seconds.
Are you referring to a "lag" in navigating the sheet and moving from cell to cell, etc.? The sheet does have a lot of objects (200+) that will slow navigation:
Thank you for your response!
Do you have an idea what other function could be used?
The lag I'm talking about is the delay between entering a number in the Team column (G), and the timeline part of the sheet updating, especially when quickly entering team numbers.
I have attached a screen recording to demonstrate. Note that as soon as I type the number, I press enter immediately, however it has a delay.
In regards to the shapes, even with the shapes removed, it is the same.
Many thanks for your help and time!
Sam
As Patrick2788 already stated the lag is only a "long" fraction of a second.
And that is because of 84240 formulas. If you remove alle formulas the lag would be gone.
- I thought this might be the case, in which case i'm out of luck.
However I just tried deleting rows 42 onwards, vastly decreasing the amount of formulas, and it is still the same?
