Sharing Excel 2007 files with older versions of Excel
Sharing Excel 2007 files with older versions of Excel: If you try to open Excel 2007 files in an older version of Excel, you get the following message as shown in the picture below. How you can overcome this problem so that you can share files with your friends who use an older version of Excel or don't use Excel at all is described in detail below.
Excel uses a
different file format
in Excel 2007 when you save the file. The file format is not compatible
with the earlier versions of Excel including Excel 2003. Therefore
opening a file created in Excel 2007 in earlier versions of Excel is
not possible and your friends will not be able to see the data in your
Excel 2007 files if they use an older version of Excel. Of course, you
will be able to work with their files. You will be able to edit the
older versions and reatin the older format. In fact, using the 'Save
as...' command you can convert the older file formats into Excel 2007
format. But how can you help your friends who are using the older Excel
version to read your Excel 2007 files? Simple: While performing the
'save as...' command, you can select the file to be saved in 'Excel
97....2003' formats! In fact, if some of your friends don't use Excel
at all or use different spreadsheet programs, you can save your Excel
2007 files in the 'CSV' format which can be accessed even with a simple
program like notepad. Watch the training video below to see how this is
accomplished.
|
|