Better testing with large, complex workbooks
I work with a large, complex workbook (several MBytes, about 150 worksheets). Excel crashes several times per day, and even crashes Windows 10 regularly with a stack overflow. Simple VBA code that works with small workbooks will regularly crash Excel (e.g., For Each ws In wb.Worksheets; do something simple; next ws). I suspect that the problems are memory or stack related, but my real request is for the testers to specifically create test cases based on huge workbooks, then see what happens.
Over the last few years, we’ve improved our ability to detect and fix performance issues significantly, and as a result we’ve seen performance improvements for users as well.
We intend to continue working on performance, but we’re marking this suggestion as completed.
Steve [Excel team]
You may want to consider using Access for such large amounts of data.