For most users the Office SP3 means that they won’t be able to recover their old documents. They won’t know to install Open Office, access Microsoft support or edit the registry. But bowing to complaints that the data is not literally “destroyed” I’m updating the title here. But anyone who doesn’t think that most users will be baffled and hurt by this doesn’t know many average users. End update.

Will Microsofties ever learn?
Without warning the Microsoft Office SP3 update blocks over a dozen common document formats, including many Word, Powerpoint and Excel documents. Install the update and you can’t open the files. Why? Because they can!

We don’t care. We don’t have to.
What’s affected? Powerpoint formats prior to PowerPoint 97. Excel formats prior to Office 2003. Lotus, Quatro and Corel Draw. And the following Word formats:

• Word 11 saved by Word 12
• Word 4.x, 5.x, 6.0, 98, 2001, X and 2004 for Macintosh
• Word 1.x, 2.x, 6.0, 95, 97, 9, 10 and 11 for Windows
• Any older formats

Trust us. It is for your own good.
Microsoft forthrightly explains why in article 938810 buried deep in the support section of their web site:

By default, these file formats are blocked because they are less secure. They may pose a risk to you.

So no whining, peasants.

Thank you sir, may I have another?
Of course, it would be irresponsible to block these formats without notification if a work-around wasn’t provided. All you have to do is edit the registry, a task so simple a child could do it. Do it correctly? Ah, that’s the rub.

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

Alarmist? No doubt. Here’s a sample instruction:

To enable Office 2003 to open files that are saved in previous Word file formats, follow these steps:

• Click Start, click Run, type regedit, and then click OK.
• Locate and then click one of the following registry subkeys:

  HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Word\Security\FileOpenBlock

  HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Security\FileOpenBlock

• Note This registry subkey may not be present. If the subkey is not present, you must create it.
• Double-click the FilesBeforeVersion registry entry, and then type the value in the Value data box that corresponds to one of the values in the following table.

For example, the default value of this entry is set to “Word 6.0 for Windows” or “101.” This setting means that all Word documents that were created in Word 1.x for Windows through Word 2.x for Windows Taiwan are blocked from opening. You can increase or decrease the default version. The versions that are specified in the list are in ascending order.

Or you could just skip Office 2003 SP3. Perhaps that would be best.

The Storage Bits take
If anyone still trusts Microsoft with their data, this is reality’s final boarding call. We need open document standards that are NOT defined by Microsoft and that Microsoft is required to does female cialis work support.

Microsoft also needs serious file system competition (see How Microsoft puts your data at risk and Outlook’s risky archives – and how to fix them ) before they will get serious about reducing data corruption and protecting your data.

Oh, be sure to turn off automatic updates. And wait for them to fix Windows Home Server’s little file corruption problem.

Comments welcome. Please, Redmond spinmeisters, make me feel good about this!

Update: “Limp” best describes the early defenses of Microsoft’s indefensible action. Some have accused me of sensationalism for using “destroys” rather than “renders inaccessible” in the title. No apologies there: yes the data may be intact, but if you can’t read it how does that differ from destruction?

We’re all reasonably technical here. But think of the hundreds of millions of users who aren’t, the small businesses and grandmothers who rely on their computers for work and play, who’ll install SP3 and then maybe not realize for weeks or months that they can’t access their data. What are they supposed to do?

Update 2: A commenter placed an incomplete list of the blocked file formats so here is the complete list of blocked Word formats from the MS article.

Blocked file format:

• Word 11 saved by Word 12
• Word 2004 for Macintosh
• Word 11 for Windows
• Word 10 for Windows
• Word 9 for Windows
• Word X for Macintosh
• Word 2001 for Macintosh
• Word 98 for Macintosh
• Word 97 for Windows
• Word 95 Beta
• Word 95 RTM
• Word 6.0 for Macintosh
• Word 6.0 for Windows
• Word 2.x for Windows Taiwan
• Word 2.x for Windows Korea
• Word 2.x for Windows Japan
• Word 2.x for Windows BiDi
• Word 2.x for Windows
• Word 1.2 for Windows Taiwan
• Word 5.x for Macintosh
• Word 1.2 for Windows Korea
• Word 1.2 for Windows Japan
• Word 4.x for Macintosh
• Word 1.x for Windows
• All older formats

One of the most accepted bits of conventional wisdom among pundits as 2007 draws to a close is that the marketplace has rejected Windows Vista in favor of Windows XP. The biggest piece of evidence is Dell’s decision in April 2007, based on a vocal response via its Dell IdeaStorm page, to continue offering Windows XP as an option on some consumer systems. It picked up steam with Microsoft’s announcement in September that it was going to allow its large OEM partners to preinstall Windows XP until June 30, 2008, a five-month extension over the original January 30 cutoff date. (A CNET News report from last April indicates that HP and Lenovo have adopted similar strategies, offering XP as an option on business-class machines but for consumer products.)

Both of those moves got a lot of press, but proof about how either decision has actually played out in the marketplace is, unfortunately, pretty thin. Microsoft doesn’t break out its mix of Windows shipments with this level of detail. OEM computer makers are tight-lipped as well. And if any third-party market research firms have done any studies on this subject, they have yet to publish the results.

But I stumbled on an unexpected source of data that has helped me get a much better picture on what the actual numbers might be like. As it turns out, Dell has published a large database of information about its current inventory for anyone to see, and I was able to sift through it to form some surprising conclusions about the current relationship between XP and Vista in the PC marketplace. The short version: Consumers have embraced Vista overwhelmingly, whereas small business is much more reluctant, preferring XP by a better than 2-to-1 margin.

My data source is Dell’s Outlet Center, where I have bought five desktop PCs in 2007. Dell maintains separate outlets for its Home and Home Office and Business and Education divisions. Products in the outlet are all current models, divided into three categories: refurbished products, which have been returned by a customer after purchase (typically within 15-30 days); products previously ordered new but not booted by a customer; and “scratch and dent” products, which have minor cosmetic flaws.

The secret of successful shopping at the Dell Outlet, I’ve learned, is to monitor the inventory carefully. In popular categories, such as high-end XPS desktops, new products arrive and are snagged within hours or even minutes if the deal is especially good.

The selection is especially wide and diverse, covering thousands of notebooks and desktops in all price ranges and configurations. If one assumes that the likelihood of a product being returned is more or less equal across the board, that makes the outlet’s inventory an excellent proxy for Dell’s larger daily cialis business.

And best of all, there’s a fully searchable database front end for the whole thing, which makes it easy to filter the entire inventory by model, processor, memory, video card, or – aha! – installed operating system. In about an hour, I was able to produce some detailed crosstabs and turn them into very informative graphs. Here are the results:

For the time period that I looked at, I examined the full, unfiltered inventory for both outlets. The small business segment included 1509 systems, consisting of low-end Vostro notebooks and desktops and high-end Latitude notebooks and Optiplex desktops. In most of these categories, Dell offers buyers a choice between XP and Vista via its online interface, and 70% of these small business buyers have opted for XP, with only 30% choosing Vista (interestingly, 2% chose the option to have XP Professional installed with a license to upgrade to Vista Business or Ultimate later).

In the consumer category, Dell offers low-end Inspiron desktops and notebooks and higher-end Dimension and XPS desktops and notebooks. Windows XP is available as an online option on a relatively small selection of models. As a result, only 7% of the inventory in the Home and Home Office Outlet is available with Windows XP preinstalled. A full 93% of the systems included Windows Vista.

One apparent reason for the higher proportion of Vista machines in the consumer segment is the lack of online configuration options. To make the comparison with the business category more accurate, I narrowed the field to only those machines that explicitly offer XP and Vista as options in the online configurator. In the notebook category, this includes the Inspiron 1520, the XPS M1710, and the XPS M1730. In desktops, this includes the Inspiron 530 and 530s and XPS 210.

[Update 1-Jan-2008: Some commenters seem to have misunderstood this detail, so let me be more explicit about what the next section includes. On Dell’s Home website, you start by choosing desktops or notebooks. On the landing page for either one, there is a big graphic on the right side of the page that reads “Still looking for Windows XP?” Click that link and you go to this page (if you started out looking for desktops) or this page (for notebooks). Both pages display a huge graphic banner at the top with this label: “THE CHOICE IS YOURS. Windows Vista or Windows XP. You decide.” The following section restricts the results from the Outlet inventory to only machines originally offered via these two links.]

When I restricted the sample to only consumer machines where potential buyers were offered the explicit option to choose between XP and Vista, the proportion opting for XP increased by 5%. Out of a total of 388 desktop and notebook PCs, 49, or 12%, were configured with either XP Home or Pro, compared with 88% that selected Vista. That means that buyers, given the clear choice, are opting for Vista over XP by a ratio of more than 7 to 1.

Two other facts stood out when I looked more closely at the data.

• One is that a staggering 27% of small business customers are opting for either Windows XP Home or Vista Home Basic, even though both are terrible OS choices for any networked business. The implication is that the $100+ difference between the Home and Pro/Business versions is significant for price-conscious business buyers. By contrast, only 13% of buyers in the consumer category are choosing the XP Home/Vista Home Basic option.
• Finally, Vista Home Premium has been a huge hit for Microsoft. More than 72% of all consumer PCs, desktop and notebook, sold in the Dell Outlet system have Vista Home Premium installed. For all the hand-wringing over Microsoft’s decision to squeeze a few extra dollars out of the consumer channel by emphasizing this particular SKU. Looks like that strategy was successful. As for Vista Ultimate, it hasn’t been a runaway winner. In the consumer sample I looked at, it represented just under 5% of sales, and in the small business side it totaled just over 1% of sales.

The bottom line? If these samples represent Dell’s overall business, which in turn serves as a proxy for the PC market as a whole, Microsoft is on target in its mission to convert the consumer market to Vista through new PC sales. Business buyers, however, remain skeptical. I’ll look at these numbers again in early 2008, after SP1 has been officially released and integrated into Dell’s product lines, to see whether it makes a substantial difference in the marketplace.