There should be an image here!I currently use Office 2007 and always forget that many of my co-workers still run Office 2003. What is the issue? When I save my documents, such as spreadsheets, I forget to save in Office 2003 format and as a result, some of my co-workers can’t open the documents.

If only I could remember to change the format each time I save a document. As a workaround, I can force an Office 2007 application, such as Excel, to always save in 2003 format. You can accomplish this using the steps described below:

  1. With Excel, click the Microsoft Office button.
  2. Click Excel Options.
  3. Click the Save tab.
  4. Click the dropdown arrow beside the Safe files in this format option and click Excel 97-2003 Workbook.
  5. Click OK.

Now when I save an Excel document, it’s automatically saved in Excel 97 — 2003 format and my co-workers running older versions of Office can open it.

[Photo above by konradfoerstner / CC BY-ND 2.0]

[awsbullet:Christina H. Tarnopolsky]