Avatar of Ian Bell
Ian Bell
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Excel memory capacity

Can someone please enlighten me on the memory capacity for Excel 2019 64bit ?
The info on the Excel site says
"64-bit environment imposes no hard limits on file size. Workbook size is limited only by available memory and system resources."
However if I exceed 3.2GB as shown in Task Manager I run the risk of a crash hence corrupting the open workbook/s.
I use an i9 processor and 48GB DDR4 Ram
Any help much appreciated on buying a new computer (Preferably Dell) solely for doing regressions using Excel Solver.
Many thanks

edit:  I found this link that explains it now doubles 64bit capacity from 2GB to 4 GB.
Are there any spreadsheets around with much greater capacity?

Microsoft ExcelStorage HardwareMicrosoft Office

Avatar of undefined
Last Comment
Ian Bell

8/22/2022 - Mon