Fun times! One of our users upgraded to Office 2007 and we already have bunch of un-openable xlsx and docx files floating around. Oh what a joy!
Good news is that I figured a quick fix for this in Word:
- Open new word document and hit Save
- On the save dialog expand the Tools combo box
- Choose Options
- The first combo box lets you choose the default save format
Excel fix should be similar – and this should be something users can apply themselves on individual basis. Unfortunately if you have bunch whiny babies who can’t be bother to click through a menu or two there is an easy way to fix on a global scale. And by easy, I mean annoying, difficult, drawn out process involving the Group Policy editor. You know, the usual Microsoft thing. Here is what you do:
- Download the Office 2007 Group Policy Templates and extract them somewhere
- Open the Group Policy editor by running: gpedit.msc
- Add the administrative templates you extracted to your group policy.
- Follow the TechNet instructions on how to set the default file types for selected Office programs
You might also want to check out this overview with screenshots. If you follow these instructions you should have Office 2007 saving in standard 2003 compatible binary files.
And no, rolling out compatibility packs is not an option. Out clients need to be able to open the files we send them, and most of them are still on Office 2003 or lower. It’s better to cripple the one or two Office 2007 installations by making them save in the old format, than to force our customers to adjust at this point.
[tags]office 2007, office 2003, doc, xls, docx, xlsx, adm, administration templates, group policy[/tags]