software

I have a large data set the needs about 800-900 columns in a worksheet. I
limit for columns in excel is a about 200-300. i dont need any more rows
added, just columns.

Not possible in one worksheet.
Use a second worksheet to continue.
Next version of Excel (due Fall this year) will have many more columns.

--
Kind regards,

Niek Otten

quot;mybicycleisgreatquot; gt; wrote in
message ...
gt;I have a large data set the needs about 800-900 columns in a worksheet. I
gt; limit for columns in excel is a about 200-300. i dont need any more rows
gt; added, just columns.
Current versions of Excel are limited to 256 columns.

quot;mybicycleisgreatquot; wrote:

gt; I have a large data set the needs about 800-900 columns in a worksheet. I
gt; limit for columns in excel is a about 200-300. i dont need any more rows
gt; added, just columns.

Can you transpose your data set, or do you already have more than 256 rows
of data as well.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------quot;mybicycleisgreatquot; gt; wrote in
message ...
gt;I have a large data set the needs about 800-900 columns in a worksheet. I
gt; limit for columns in excel is a about 200-300. i dont need any more rows
gt; added, just columns.
My original question came out broken up so..---the data i have takes up
800-900 columns BUT only 22 rows. the data needs to be set up like this to
be imported to a program called primer. to transpose this data, the program
does not like it. any suggestions?

quot;Ken Wrightquot; wrote:

gt; Can you transpose your data set, or do you already have more than 256 rows
gt; of data as well.
gt;
gt; --
gt; Regards
gt; Ken....................... Microsoft MVP - Excel
gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt;
gt; ------------------------------Â*------------------------------Â*----------------
gt; It's easier to beg forgiveness than ask permission :-)
gt; ------------------------------Â*------------------------------Â*----------------
gt;
gt;
gt; quot;mybicycleisgreatquot; gt; wrote in
gt; message ...
gt; gt;I have a large data set the needs about 800-900 columns in a worksheet. I
gt; gt; limit for columns in excel is a about 200-300. i dont need any more rows
gt; gt; added, just columns.
gt;
gt;
gt;