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:
- With Excel, click the Microsoft Office button.
- Click Excel Options.
- Click the Save tab.
- Click the dropdown arrow beside the Safe files in this format option and click Excel 97-2003 Workbook.
- 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.