System Requirements 50-85MB files Excel

Occasional Visitor

What are the requirements needed to handle 50-85 MB files - 500k-900k rows - 30+ columns with 10+ of them with formulas with out excel constantly freezing up.

 

I currently have a Dell Latitude 5420 - 11th Gen Intel(R) Core(TM) i7-1165G7 @ 2.80GHz 1.69 GHz. 16GB RAM but am struggling.

 

Thanks 

 

1 Reply

@valama123 

Excel specifications and limits

Worksheet and workbook specifications and limits

Data Model specification and limits

This article documents the maximum and configurable limits for Excel workbooks that contain data models.

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)