Posted 26 May 2021, 8:37 pm EST
We have a book with table and slicer. We notice that the performance of reference cell degrades drastically when table has lots of rows and slicers are defined. We are using the latest version V4.1.1.
Please reference attachment for reproduction. Target workbook: slicer.xlsx
Sheet0: Table has 100, 000 rows and no slicer is defined. It’s very fast to access cells in this sheet.
Sheet1: Table has 1000 rows and slicers are defined. It’s running a litter slower but still acceptable.
Sheet2: Table as 10, 000 rows and slicers are defined. Every access to cell costs 6 seconds or so at our end.
Sheet3: Table has 100, 000 rows and slicers are defined. Almost unusable with this setup. Every cell operation costs infinite time and almost not responding.
Please help to investigate this issue. Thank you.