Office 2007 – can we decide on a UI document model, please?

I posted before about a few inconsistencies in the Office 2007 UI, and now I found that there’s not even a common UI document model underneath the various applications. I did some tests with PowerPoint, Word and Excel – what I want is really simple: I want to be able to open more than one document at once, and I want each document to appear in its own window. Of course each of those windows should have its own button in the task bar (it wouldn’t cross my mind to mention this specifically, but as I found out, this is apparently not a normal thing to expect). I have three screens attached to my computer, so I want to be able to view several documents of the same type next to each other, and I want to use Alt-Tab to switch between main windows, because my task bar is seldom where I need it and always so full that I can’t easily find the right button anyway.

So here’s how the three applications behaved in my test.


There’s an option called “Show all windows in the Taskbar” (Advanced/Display) in the options dialog. This effectively switches between an old-style MDI interface and a new-style interface that behaves exactly like I would expect (see above). Good! The drawback about MDI is that there’s no Windows menu anywhere to be seen, so the handling of a number of MDI windows is probably more difficult then it used to be.


Excel has a similar option (same name, but this time it in the Personalize/Top options for working with Excel section) as Word, but the result is different. After analyzing it for a while, I would say that Excel simply always works as an MDI container. When the option to show all windows in the task bar is switched on, there are two differences:

  1. The task bar shows one button for each open Excel workbook, although there’s always just one Excel main window.
  2. The close button for maximized MDI child windows vanishes. I can still close them if they are not maximized, though… I guess the reason for the disappearance of the close button is that I’m supposed to use the main window close button. In this mode, the main windows doesn’t close the main window, but instead the active child window. Ridiculous.
Excel-window-option-off    Excel-window-option-on

In my quest to make Excel behave the way I want it to, I tried to run multiple instances of the application, and I was surprised to see that this actually works! No matter what the button option is set to, it’s possible to run Excel more than once to get multiple main windows on screen.


PowerPoint has, once again, a similar option, and this time it can be found in the same place as in Word. But the behaviour of the application itself is closer to what Excel does: it works as an MDI container always, and the option switches the number of buttons in the task bar. In contrast to Excel though, when the option is On, there are no MDI child window buttons at all. So the only way to switch between one child window and another is to use the Windows task bar.

In contrast to Excel, it turned out to be impossible to run multiple instances of PowerPoint. Every time a new instance is run, a new document is created in the existing instance instead.


So we have at least three different UI document models in these three applications. All three of the applications can be used as MDI applications, but in absence of proper in-application window handling (no Windows menu!), this is not very useful. Switching off the MDI mode has three different results – multiple main windows in Word, no real effect at all in Excel and MDI without child window buttons in PowerPoint. The workaround of running multiple app instances is available in Excel, in PowerPoint the only way to see multiple presentations on screen at the same time is to use the broken MDI mode. Way to go, Microsoft!

3 Comments on Office 2007 – can we decide on a UI document model, please?

  1. Yeah. This has been a longstanding gripe and I find unfathamable that it isn’t addressed in Office 2007.Not only is it frustratingly unintuitive, it’s a serious productivity killer. For instance, opening up new documents in Excel is impossible while a dialog is open or it’s otherwise busy (such as running a time-consuming macro). We have Excel macros that pour through a spreadsheet and lookup things in a database that may take 20 minutes…. my users complain that Excel (all their open documents) are innaccessible during this time!!!I really wish all Office apps (including Word) implemented a Tabbed document Interface (like Access 2007 seems to have and FrontPage has today). But, I’d settle for all of them to have Word’s True-SDI.


  2. I just installed Office 2007 Ultimate with the specific hopes of finding an SDI mode in Excel. Damnit all.


  3. Dear Microsoft, It’s called Windows. Note the s at the end, which signifies plurality. Screwing us down to one window is not what Windows (again, note the s) users want. I.E. tabs are stupid for the same reason. I paid for Windows, plural, and I want windows, plural, in Excel! Just to be clear: 1. Multiple workbooks in a single Excel window will not do; that is still 1 window 2. Multiple Taskbar buttons (1 per each multiple workbook in a single Excel window) will not do; that is still 1 window Sick and tired of being screwed down, Lee


Leave a Comment

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s