ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i use spreadsheets wider than 256 columns? (https://www.excelbanter.com/excel-worksheet-functions/36122-how-do-i-use-spreadsheets-wider-than-256-columns.html)

Fredo

how do i use spreadsheets wider than 256 columns?
 
I'm lookiing for an add in or plugin that will enable me to use .csv files
created by a sql database query of up to 512 variables. I'd also like to be
able to increase the number of rows beyond the current limit.

Gordon

"Fredo" wrote in message
...
I'm lookiing for an add in or plugin that will enable me to use .csv files
created by a sql database query of up to 512 variables. I'd also like to
be
able to increase the number of rows beyond the current limit.


Fraid not. Excel is well and truly fixed at 256 columns and 65536 rows.
Quattro Pro I believe has many more columns and rows. You might try that.



Fredo

Thanks, I was afraid of that but wanted verification.

"Gordon" wrote:

"Fredo" wrote in message
...
I'm lookiing for an add in or plugin that will enable me to use .csv files
created by a sql database query of up to 512 variables. I'd also like to
be
able to increase the number of rows beyond the current limit.


Fraid not. Excel is well and truly fixed at 256 columns and 65536 rows.
Quattro Pro I believe has many more columns and rows. You might try that.





All times are GMT +1. The time now is 06:20 PM.

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