Excel - Excel 2007 column limit

Asked By la

27-Sep-07 10:29 AM

I have both excel 2003 and excel 2007 which is part of MS office enterprise
2007 installed on my computer. I was told that the new excel 2007 can support
column limit 16,384. but I found it still has only 256 column, does someone
knows why?

Thanks!
Lan

27-Sep-07 12:00 PM

You are in 2003 mode.

27-Sep-07 12:25 PM

Are you looking at an Excel 2003 workbook in Excel 2007? If you are you'll
see compatibility mode after the book name in the title bar and the book
name will have an extension of .xls. If you're working with an Excel 2003
workbook in Excel 2007, you'll have 256 columns and 16,384 rows. If you want
to convert your Excel 2003 workbook to an Excel 2007 workbook which has
16,384 columns and 1,048,576 rows, simply save it as an Excel 2007 workbook
(Office button, Save as, Excel workbook). Close the workbook and reopen it.
It will now be in Excel 2007 format and the book name in the title bar will
have an extension of .xlsx.   Excel 2007 allows you to work with both Excel
2007 workbooks and prior release workbooks as well.

27-Sep-07 01:16 PM

I should also point out that if you save an Excel 2003 workbook as an Excel
2007 workbook, you will have both workbooks. The Excel 2003 workbook will
have an extension of .xls and the Excel 2007 workbook will have an extension
of .xlsx.  If the book names are the same, just be careful to open the right
one.