Calculation time & computer or laptop specification

[Prashant7648]

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 or any changes changes in basic data...it will take minimum 30 min.

I trying to change my formula with minimum times...but still there is big lags...''

kindly suggest if my laptop is required more RAM or HDD (like M.2 or NV ME)

Currently I am using laptop and desktop. Containing 8 GB RAM & SATA SSD 512GB...I3 Processor (Excel 365)

Please suggest …what do to do for better spec. or any other tips

[#2]

@Prashant7648 

Depending on the Excel version, there are different specification options and limits.

In the link below you will find some information about it.

Excel specifications and limits

Hope I was able to help you with this info.

NikolinoDE

I know I don't know anything (Socrates)

[#3]

@Prashant7648 

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)