Can I use & export data & sheets between Excel 2003 & 2007

[SDinSD]

I have excel 2003 on the office computer - I want to interchange & work on my
workbooks on my new laptop - do I need to install 2003 on the laptop to
insure interchange or can I put 2007 on the laptop and have them interchange ?

 

[JLatham]

Get the Office 2007 Compatibility Pack and install it on the laptop with
Office 2003 on it. Then 2003 can work with 2007 files
http://www.microsoft.com/downloads/...70-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en

Another option is to set the default File Save format to one that is
compatible with 2003.

None of these options will allow you to use 2007 unique features within
Excel 2003 (such as SUMIFS() or going beyond column IV or below row 65536).

 

[Chip Pearson]

Excel 2007 can open, edit, and save files in the 2003 file format.
Also, there is a compatibility pack for Excel 2003 that lets you edit
and save 2007 files.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]

 

[Dave Peterson]

MS has a conversion/compatibility program for reading the native xl2007 file
formats in xl2003.

http://www.microsoft.com/downloads/...70-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en

Personally, I've changed the default fileformat for xl2007 to the old
(xl97-xl2003) .xls fileformat. Then I don't have to worry about fileformat
version differences.