Originally posted by: jhayx7
Originally posted by: DVK916
According to M$ it is 100% backwards compatible if you save docs in compatibility mode, any older version of office should open it perfectly. What a bunch of crap, I made a bunch of spreadsheets in excel and saved them in compatibility mode, and they don?t open right in office 2003 or Mac Office. The borders are and sizes of the fields are all wrong. Damn M$, they claim 100% backwards compatible, and it isn?t.
Some of the exclusive formating features of Office 2007 are NOT backwards compatible.
From MS Help:
To ensure that a Excel 2007 workbook does not have compatibility issues that cause a significant loss of functionality or a minor loss of fidelity in an earlier version of Excel, you can run the Compatibility Checker. The Compatibility Checker finds any potential compatibility issues and helps you create a report so that you can resolve them.
Important When you work on a workbook in Compatibility Mode, where the workbook is in Excel 97-2003 file format (.xls) instead of the new Excel 2007 XML-based file format (.xlsx) or binary file format (.xlsb), the Compatibility Checker runs automatically when you save a workbook.
In Excel 2007, open the workbook that you want to check for compatibility.
Click Microsoft Office Button , click Prepare, and then click Run Compatibility Checker.
To check the workbook for compatibility every time that you save it, select the Check compatibility when saving workbook check box.
To create a report in a separate worksheet of all the issues that are listed in the Summary box, click Copy to New Sheet.