Excel 2007 backward compatability?

R

Reggie D.

My old EXCEL spreadsheets are being saved as .xlsx which cannot be openened
when emailed to another PC using an earlier edition of Office. As there are
no help files in the new 2007 Office suite I am at a loss to solve the
problem myself. Can anyone help please?
 
R

Reggie D.

Shane,
Thx the quick response. Pardon my ignorance but are there ant Office edition
between 2003 and 2007 that might not be solved by the converter you suggest
nas what does the xlsx signify as opposed to the simple xls?

Reggie D.
 
B

Bob Phillips

There are no versions between 2003 and 2007,

Excel 2007 uses a different file format, they are zipped files of various
components, and because of this, MS use a different file extension to
signify 2007 files. xlsx are the 2007 equivalent to xls, files, are there
are also xlsm (macro enabled files) and xlam, equivalent to xla files. As
Shane said, anyone can download the free compatibility pack so that 2003
users can open the new file formats. The compatibility packs work well, but
if the 2007 files contain any of the new features of 2007, they will be
stripped out when opened in 2003 as that version knows nothing about them.

It is also possible to save a file in Excel 2007 in 97-2003 format. Such
files will have 65536 rows, 256 columns as Excel 2003 has, and when saved
new functionality is lost, but they can be easily opened in Excel 2003 with
or without the compatibility packs.
 
G

gls858

Bob said:
There are no versions between 2003 and 2007,

Excel 2007 uses a different file format, they are zipped files of various
components, and because of this, MS use a different file extension to
signify 2007 files. xlsx are the 2007 equivalent to xls, files, are there
are also xlsm (macro enabled files) and xlam, equivalent to xla files. As
Shane said, anyone can download the free compatibility pack so that 2003
users can open the new file formats. The compatibility packs work well, but
if the 2007 files contain any of the new features of 2007, they will be
stripped out when opened in 2003 as that version knows nothing about them.

It is also possible to save a file in Excel 2007 in 97-2003 format. Such
files will have 65536 rows, 256 columns as Excel 2003 has, and when saved
new functionality is lost, but they can be easily opened in Excel 2003 with
or without the compatibility packs.

And if you wish to save in the 97-2003 format by default, you can click
the Office button > Excel options at the bottom of the drop down and
then select save and set the default format there.

gls858
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top