ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I use & export data & sheets between Excel 2003 & 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/252528-can-i-use-export-data-sheets-between-excel-2003-2007-a.html)

SDinSD

Can I use & export data & sheets between Excel 2003 & 2007
 
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

Can I use & export data & sheets between Excel 2003 & 2007
 
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/d...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).


"SDinSD" wrote:

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 ?


Chip Pearson

Can I use & export data & sheets between Excel 2003 & 2007
 
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]



On Tue, 5 Jan 2010 14:39:01 -0800, SDinSD
wrote:

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 ?


Dave Peterson

Can I use & export data & sheets between Excel 2003 & 2007
 
MS has a conversion/compatibility program for reading the native xl2007 file
formats in xl2003.

http://www.microsoft.com/downloads/d...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.




SDinSD wrote:

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 ?


--

Dave Peterson


All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com