When I try to filter an excel table with approx 36000 rows I takes a long while to calculate. When I look at the processor and memory usage, I notice the cpu usage is at 100% and the memory usage around 60%.
The document has multiple sheets and the sheet containing the table has lookups to other sheets.
I already tried this:
- ForceFullCalculation set to true
- Switch off multi-threaded recalculation
So I already know it's because Excel needs to recalculate all the lookups in the table.
What options are there to have a better working experience?