Earlier quoted context omitted.
I would go further and say that MS products have completely backwards priorities that lead to an overinflated feature count. What good is fancy formatting in excel if it chokes and crashes once the file hits about 20 MB? Yet despite all this emphasis on form over function over multiple decades of being a flagship product for a multibillion dollar software empire, it still produces plots that are unacceptable for publ…
It's possible you found a bug in Excel somewhere but I guarantee that when working with large files it's generally faster and more reliable than the competition. I have successfully worked with files way larger than 20 MB which make competing products such as Apple Numbers or Google Sheets completely choke.
I have a direct comparison because the exact same computations were previously implemented in excel and libre office. Both dropped plots from files, had straight-up reference bugs once things got large, and would regularly crash attempting to render dozens of tiled plots in 4k. The idea of using Google sheets for this is laughable.