I've never been a fan of Microsoft products, but this is beyond
ridiculous. A few months ago I made the mistake of upgrading (a word
that becomes ever more ironic) to the latest version of Office for the
Macintosh, largely in hope that a native Intel version would
outperform the emulated PowerPC version I'd been using up to then. It
didn't. And worse, not only didn't it perform better, but it had
serious bugs, with graphs that didn't display correctly or wouldn't
let me change parameters, and regular crashes. An update eliminated
some of the crashes, although it left me with repeated popup dialogues
complaining of nonexistent problems. (If I'm out of memory, how come
you stop complaining after I cancel the dialogue a few times?)
But, I thought, even Microsoft has to get it right eventually. So
when I heard there was a new update out, I couldn't wait to install
it. It finally showed up this morning, and it made things so much
better, in much the same way that a tornado cleans up a neighborhood.
Yep, now even the smallest change to my spreadsheets crashs the
program. Every. Damn. Time. Excel has gone from extremely annoying
to completely and utterly useless. What's the next update going to
do: set my apartment on fire?
Update 05/15: A quick update. I think the problem is Excel's background error checking feature, which, by the way, complains every time I use a range that includes empty cells. I turned off background error checking and was able to get a version of the spreadsheet to update without crashing. So I'm back in business, and slightly less furious at Microsoft for selling me such a piece of utter crap.
Update 05/15: A little later... I tried updating a cell in my spreadsheet and watched it go into an endless processing loop, pegging one of my processors at 100%. After killing and restarting Excel, I discovered that the act of loading another spreadsheet had turned background error checking back on, including for the sheet where I had explicitly turned it off. So not only is background error checking hopelessly fucked, but it insists in being in my face about its fuckedness. Thanks so much, Microsoft.
Update 06/25: Another month and a half, another Office update. And this one seems to have undone the damage done by the last one. My spreadsheets don't crash, at least for the moment. And isn't that what we all don't want?