Question

Locked

MS Excel 2007 vs. 2003 (Graph compatibility)

By rhemraj ·
I have a compatibility question regarding graphs on excel. Our office runs both office 2003 as well as 2007. For some reason, every time the graph title or date is edited on the 07 version and reopened on the 03 version, it disappears.

There are also a few other formatting issues we've come across on the graphs. I was wondering if maybe there was some special preface or setting that needed to be made that I may not be aware of? Any sort of feedback would be helpful.

Thank you.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Re: MS Excel 2007 vs. 2003 (Graph compatibility)

Example:
Excel 2007 with earlier versions of Excel

After you've installed Microsoft Office Excel 2007, you may want to know how you can continue working with workbooks that are created in an earlier version of Excel, how you can keep these workbooks accessible for users who don't have the current version of Excel installed, and how the differences between the versions affect the way that you work.

For backward compatibility and collaboration with earlier versions of Microsoft Office Excel (Excel 97-2003), you can use one of several ways to exchange workbooks between the different versions. In Office Excel 2007, you can open a workbook that was created in an earlier version of Excel and work in Compatibility Mode so that the workbook remains in a file format that can easily be opened again in the earlier version. An Excel 2007 workbook can also be opened in an earlier version of Excel by using file converters that can be downloaded.

And if you decide to convert the workbook to the current file format, you can always check the converted workbook for compatibility with earlier versions of Excel, so that you can make the necessary changes to avoid the loss of data or fidelity that might occur when that workbook is opened in an earlier version of Excel.
Work in compatibility mode in Excel 2007

In Excel 2007, when you open a workbook that was created in an earlier version, it is automatically opened in Compatibility Mode, and you see Compatibility Mode in square brackets next to the file name in the Excel title bar (title bar: A horizontal bar at the top of a window, dialog box, or toolbar that shows the name of the document, program, or toolbar.). In Compatibility Mode, any new or enhanced Excel 2007 features are not available when you work in a workbook, which prevents the loss of data and fidelity when the workbook is opened in an earlier version of Excel. Also, rather than using the current XML-based file format (.xlsx), the workbook is saved in Excel 97-2003 file format (.xls), a binary file format that is easily opened in an earlier version of Excel.

Unlike other 2007 Microsoft Office system programs, such as Microsoft Office Word 2007, you cannot manually turn on Compatibility Mode in Excel, and you don't have the option to include any new features when you work in a workbook in Compatibility Mode.

If you no longer want to work in Compatibility Mode, you can convert the workbook to the current file format
Download and use file converters

1. On the computer that has the earlier version of Excel installed, download the Microsoft Office Compatibility Pack for 2007 Office Word, Excel and PowerPoint File Formats from the Microsoft Office Downloads Web site:
http://office.microsoft.com/en-us/downloads/default.aspx
and install the updates and converters that are needed to open Excel 2007 workbooks.
Convert a workbook to the current file format

1. Open the workbook that you want to convert to the current file format.

Note The workbook is opened in Compatibility Mode.
2. Click the Microsoft Office Button Button image, and then click Convert.
3. If you receive a message about converting workbooks, click OK.

Tip If you don't want to see this message about converting workbooks, select the Do not ask me again about converting workbooks.
4. To work in the current file format, click Yes to close and reopen the workbook.
http://office.microsoft.com/en-us/excel/HA100775611033.aspx

Please post back if you have any more problems or questions.
If this information is useful, please mark as helpful. Thanks.

Related Discussions

Related Forums