ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Number of Columns (https://www.excelbanter.com/excel-discussion-misc-queries/51365-number-columns.html)

Pedro Mestre

Number of Columns
 
Dear all,

We are using Excel 97, and we need to know if there is possible add more
columns than the 256 that already are available from A - IV.

We need that because we are exporting data from one aplication to Excel.

Thanks a lot.
Regards,
Pedro Mestre

philc

Number of Columns
 
no, 256 is the limit.

you may be able to use ms query to 'query' the data source and select
only the colums you need, or to build separate queries that return the
data over multiple sheets


Alan

Number of Columns
 
No, 256 is all there are,
Regards,
Alan.
"Pedro Mestre" wrote in message
...
Dear all,

We are using Excel 97, and we need to know if there is possible add more
columns than the 256 that already are available from A - IV.

We need that because we are exporting data from one aplication to Excel.

Thanks a lot.
Regards,
Pedro Mestre





All times are GMT +1. The time now is 11:07 PM.

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