Need a better distinction between "long calculation" and "frozen/crashed"
There are calculations so large and long that Excel is unresponsive until they are done. It will say something like "Book1 - Excel (Not Responding)" in the title bar. The GUI will not update and will fade if you try to click in it with your "hourglass" cursor.
If I didn't know any better (and I used to not know any better), I would assume that Excel was frozen and just kill the process and lose all of my saved work. But it isn't frozen. It's just taking a very long time. This should be made clear to the user but isn't.
For an example of this, fill columns A and B with all 1s. Fill column C with SUMIF(A:A,1,B:B). Excel should appear frozen for a few minutes.
Agreed, better feedback while processing would be v helpful, even if it meant listing out the various steps that Excel is doing or an estimate of the time required.
What is the best competitive spreadsheet program?
Is it time for a class-action lawsuit against MS?
One mouse click can cause Excel to lock-up. A three hour wait is unacceptable. MS knows there are countless problems. What happened?
This is very much needed especially given that Excel overall performance seems to have slowed.
Better feedback for user. I work with huge spreadsheets that take awhile to calculate. Sometimes I don't know if Excel is still working or if it is hanging without looking in task manager. Occasionally it will show calculating or iteration messages, but other than that, no feedback message.