Forum Discussion
Calculation time & computer or laptop specification
My Excel file is around 100MB ..includes heavy formulas. Like pivot table ..VLOOKUP …sumifs and ifs formulas Total rows around 315000 and columns around 30... Any calculation just like filter...
100MB file is quite big and 8GB RAM is not a lot. However, perhaps rebuild your data structure and formulae could help. Especially if you are on 365.
Some performance tips are here Tips for improving Excel's performance (microsoft.com)