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.
edit: I found this link that explains it now doubles 64bit capacity from 2GB to 4 GB.https://docs.microsoft.com/en-US/office/troubleshoot/excel/laa-capability-change
Are there any spreadsheets around with much greater capacity?