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.
We’d love to get samples of these workbooks that are crashing, along with steps that cause them to crash. Until then, there’s not much we can do without more data.
If you have such a workbook, please create a new idea entitled “I have a workbook that crashes, which I want to send you” and I’ll get back to you with an email address where you can send it so we can take a look and fix the problem.
You may want to consider using Access for such large amounts of data.