Here’s a happy little dialog that I’m freakin’ sick and tired of seeing:
You see, Excel 07 has new file formats. “XML is the wave of the future”, they said. “Everything’s going XML”, we’re told. Ten years from now we’ll be saying “Remember that XML fad? Man we were jerks. And look how thin I was.”
Excel’s main formats are now:
Excel Workbook *.xlsx
Excel Macro-Enabled Workbook *.xlsm
Excel Binary Workbook *.xlsb
Then there’s some legacy formats and other sundry formats you’d expect from a spreadsheet program. The binary format is necessary because as great as XML is, it just can’t hold 18 quadrillion cells of data. Particularly large workbooks will be better off in binary. But the main point of my gripe is that there’s two new xml formats, not just one. And the one that I almost never want to use is the default. So I get to see this dialog box every time I save a new workbook with macros. Yippee.
To be fair, this is a fairly uninformed diatribe. There may be a way to change the default, but I doubt it. The program should recognize when there’s macros and suggest the macro-enabled version as the default. Also, there may be a good reason for having two xml formats and an equally good reason for making the non-macro-enabled one the default. I admit I haven’t been keeping up on the Excel 12 blogs, but if you can point to a post on this topic, leave a comment.
More complaining to come, I promise.