Forum Discussion
Excel slow filter issue
HI, i'm using office365 for business at 64bit on a 64bit OS - Updated at the last security fix. I have a workbook with 10 sheets, one of them have 50.000 rows and 115 column. The relative SHEET1.BI...
To be honest, a 50,000 row by 155 column table is quite large for Excel. Especially if it also contains VLOOKUP formulas and SUMIFS. You are stretching the limits of what is feasible to do with Excel just using formulas. Pivot tables would perform a lot beter and if those VLOOKUPS are pointing to other tables, you can combine those tables into the same pivottable by setting a relationship between them.
Under the hood, you would then be using PowerPivot to summarise that data.
Under the hood, you would then be using PowerPivot to summarise that data.
- Shall we assume it is the correct answer?
