Mar 06 2022 07:10 PM - edited Mar 06 2022 07:12 PM
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
Mar 07 2022 01:56 AM
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.
I know I don't know anything (Socrates)