N
need to exceed 256 columns in Excel
I need more than 256 columns. Is there a version of Excel, or some other
spreadsheet, that will permit me to do this?
spreadsheet, that will permit me to do this?
D
Dante Gagne [MSFT]
Unfortunately, Excel XP has a hard limit of 256 columns by 65,536 rows. If
you're only planning on using 256 rows, you may consider designing your
swapping rows and columns. Sorry, wish I could be of more help.
--
Dante Gagne
Software Design Engineer/Test
Developer Division
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
you're only planning on using 256 rows, you may consider designing your
swapping rows and columns. Sorry, wish I could be of more help.
--
Dante Gagne
Software Design Engineer/Test
Developer Division
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
K
Ken Wright
Version of Excel - No
Other spreadsheet - Quattro Pro with 18K Cols I believe.
Other possibility - maybe transpose the data?
Other possibility - Access and multiple linked tables and then query via Excel
or even within Access.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------
"need to exceed 256 columns in Excel" <need to exceed 256 columns in
[email protected]> wrote in message
Other spreadsheet - Quattro Pro with 18K Cols I believe.
Other possibility - maybe transpose the data?
Other possibility - Access and multiple linked tables and then query via Excel
or even within Access.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------
"need to exceed 256 columns in Excel" <need to exceed 256 columns in
[email protected]> wrote in message
A
Allan S. Warrior
No, at least not in Excel. Is it possible to "turn" your data so that you
can make use of the 65,536 rows?
can make use of the 65,536 rows?
R
reston33
Thanks Ken. I will look for Quattro Pro.
Unfortunately, my rows go into the thousands, so I can't just swap my cols
with my rows.
Unfortunately, my rows go into the thousands, so I can't just swap my cols
with my rows.
K
Ken Wright
If you have thousands upon thousands of rows and hundreds of columns then I
would seriously consider a database. Spreadsheets are far less efficient at
handling data of that magnitude than a database. That doesn't mean the data
can't be queried from within a spreadsheet, but it will be far more robust.
Horses for courses and all that jazz
would seriously consider a database. Spreadsheets are far less efficient at
handling data of that magnitude than a database. That doesn't mean the data
can't be queried from within a spreadsheet, but it will be far more robust.
Horses for courses and all that jazz
H
Harald Staff
Databases have column (=field) limitations too, Access is also limited to
255 (or 256 ?). And they have tons of useful guidelines about why fewer
fields and linked tables is a better solution than endless lists of
duplicate or geographically defined information.
Best wishes Harald
255 (or 256 ?). And they have tons of useful guidelines about why fewer
fields and linked tables is a better solution than endless lists of
duplicate or geographically defined information.
Best wishes Harald
D
David Billigmeier
Excel 12 will have 1,048,576 rows and 16,384 columns