How Can I convert Excel 2007 to Excel 2003 and preserve calculations using array
Posted on 2010-09-02
I have a large spreadsheet created in Excel 2007, I am told this needs to be in excel 2003 I am met with a few errors. Please see the Compatibility report.
Is it possible to convert without losing cell reference?
Compatibility Report for GM_WorkingCurrent2.xls
Run on 9/2/2010 9:26
The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.
Significant loss of functionality # of occurrences
This workbook contains data in cells outside of the row and column limit of the selected file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will return a #REF! error. 1
'Missing Router Only'!A1:XFA36
One or more functions in this workbook are not available in earlier versions of Excel. When recalculated in earlier versions, these functions will return a #NAME? error instead of their current results. 1000
Minor loss of fidelity
Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available. 50