What happens if a user with Excel 2003 opens an Excel 2007 file that has more
than the max number of columns as permitted by 2003? (up to column IV)

Do they just not see the extra columns, or can't they open it in the first
place?

Al

Yes, we can open Excel 2007 file in 2003 version but it will not display the data the exist more than 65K rows.

The advanced functions of 2007 version like AVERAGEIF etc not work in excel 2003

Excel 2003 cann't read 2007 format normaly but with special converter it
can. if you get converter form MS then data get cut off when looded in excel
2003.

"Al" wrote in message
...
| What happens if a user with Excel 2003 opens an Excel 2007 file that has
more
| than the max number of columns as permitted by 2003? (up to column IV)
|
| Do they just not see the extra columns, or can't they open it in the first
| place?
|
| Al

Excel 2003 users can download and install the Compatibility Pack so's they
can open 2007 files in 2003.

http://support.microsoft.com/kb/923505

Just note that 2007 files opened in 2003 will have the columns and rows
limits of 2003.


Gord Dibben MS Excel MVP

On Wed, 5 May 2010 23:50:01 -0700, Al wrote:

What happens if a user with Excel 2003 opens an Excel 2007 file that has more
than the max number of columns as permitted by 2003? (up to column IV)

Do they just not see the extra columns, or can't they open it in the first
place?

Al