ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   PLEASE allow more than 256 columns in Excel! (https://www.excelbanter.com/excel-discussion-misc-queries/115007-please-allow-more-than-256-columns-excel.html)

apdil

PLEASE allow more than 256 columns in Excel!
 
The 256-column limitation is extremely frustrating! I have to do headstands
to work around this. Why on earth would you limit to 256 columns? Just
because you want to store the column number as a byte? C'mon, this is 2007,
we have 64-bit processors now, bytes and 256 are ancient concepts!

-Paul


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Pete_UK

PLEASE allow more than 256 columns in Excel!
 
Well, it's not quite 2007, but Excel 2007 is available as a beta at the
moment - full release in the first quarter of 2007 I believe.

This version increases both the number of columns (to 16k) and the
number of rows (to 1 million), so you should be able to work within
those limitations.

Pete

apdil wrote:
The 256-column limitation is extremely frustrating! I have to do headstands
to work around this. Why on earth would you limit to 256 columns? Just
because you want to store the column number as a byte? C'mon, this is 2007,
we have 64-bit processors now, bytes and 256 are ancient concepts!

-Paul


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc



smw226 via OfficeKB.com

PLEASE allow more than 256 columns in Excel!
 
Hi Paul,

Office 2007 BETA is now avaliable from microsoft which has over 1,000,000
rows and over 16,000 columns



apdil wrote:
The 256-column limitation is extremely frustrating! I have to do headstands
to work around this. Why on earth would you limit to 256 columns? Just
because you want to store the column number as a byte? C'mon, this is 2007,
we have 64-bit processors now, bytes and 256 are ancient concepts!

-Paul


--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1


apdil

PLEASE allow more than 256 columns in Excel!
 
Thank you, and Pete too!

"smw226 via OfficeKB.com" wrote:

Hi Paul,

Office 2007 BETA is now avaliable from microsoft which has over 1,000,000
rows and over 16,000 columns



apdil wrote:
The 256-column limitation is extremely frustrating! I have to do headstands
to work around this. Why on earth would you limit to 256 columns? Just
because you want to store the column number as a byte? C'mon, this is 2007,
we have 64-bit processors now, bytes and 256 are ancient concepts!

-Paul


--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1



Nick Hodge

PLEASE allow more than 256 columns in Excel!
 
However

Be careful what you ask for... Excel is a spreadsheet analysis tool, Access,
or SQL are databases... put a single 1 in each cell in the new grid in 2007
and the whole thing grinds to a halt! If you put a SUMIF, VLOOKUP or
anything similar in a small proportion of the extra rows and go of and have
a cup of tea... nothing wrong with Excel per se, just sometimes there is a
better tool and generally if you are fighting the tool, you have the wrong
one.

As I say, be careful what you wish for.....

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"apdil" wrote in message
...
Thank you, and Pete too!

"smw226 via OfficeKB.com" wrote:

Hi Paul,

Office 2007 BETA is now avaliable from microsoft which has over 1,000,000
rows and over 16,000 columns



apdil wrote:
The 256-column limitation is extremely frustrating! I have to do
headstands
to work around this. Why on earth would you limit to 256 columns? Just
because you want to store the column number as a byte? C'mon, this is
2007,
we have 64-bit processors now, bytes and 256 are ancient concepts!

-Paul


--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1






All times are GMT +1. The time now is 10:39 AM.

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