Excel needs to allow infinite rows and columns.
 

At work I use some information sheets that use more rows than the 65,000 or
what ever that Excel presently will allow. It would be very useful if you
could have a more unlimitied number of rows to use.
Has anyone experienced the need for this and if so how did you resolve the
issue?
Excel is a great application but that one limitation is frustrating.

----------------
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...et.f unctions

Excel needs to allow infinite rows and columns.
 

Excel 2007 will have 1M+ rows, and 16K columns.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Removing multiple hyperlinks at once"
osoft.com wrote in
message ...
At work I use some information sheets that use more rows than the 65,000
or
what ever that Excel presently will allow. It would be very useful if you
could have a more unlimitied number of rows to use.
Has anyone experienced the need for this and if so how did you resolve the
issue?
Excel is a great application but that one limitation is frustrating.

----------------
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...et.f unctions

Excel needs to allow infinite rows and columns.
 

Bob Phillips wrote:
Excel 2007 will have 1M+ rows, and 16K columns.

Is this expected to affect the 5461 element limit on some worksheet
functions and transferring between arrays and the worksheet?

Alan Beban

Excel needs to allow infinite rows and columns.
 

I think we're going to need a bigger computer.

16K * 1M = 16GB just to hold one sheet full of nothing but a single
character in each cell. That's besides overhead to define the sheet and
addresses involved.

But the addition of more rows was needed, and there have been situations in
the past when 256 columns wasn't enough - mostly due to lack of foresight on
my part, and having to transform all the data on a sheet because changes made
long after the initial design ran me out of columns.

One thing I've been wondering about is how the extended row numbers will
affect 'standard practice' functions like =Range("A65536").End(xlUp) - are
all of those going to have to change to Range("A1000000").End(xlUp) or I'm
hoping they will provide a constant that is Excel version-conscious to use to
reference the highest numbered row on a sheet, maybe like Range(A &
xlLastPossibleRow).End(xlUp), where value of xlLastPossibleRow is determined
by version of Excel.

"Bob Phillips" wrote:

Excel 2007 will have 1M+ rows, and 16K columns.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Removing multiple hyperlinks at once"
osoft.com wrote in
message ...
At work I use some information sheets that use more rows than the 65,000
or
what ever that Excel presently will allow. It would be very useful if you
could have a more unlimitied number of rows to use.
Has anyone experienced the need for this and if so how did you resolve the
issue?
Excel is a great application but that one limitation is frustrating.

----------------
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...et.f unctions

Excel needs to allow infinite rows and columns.
 

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
I think we're going to need a bigger computer.

16K * 1M = 16GB just to hold one sheet full of nothing but a single
character in each cell. That's besides overhead to define the sheet and
addresses involved.


Bad practices will create problems in the future just as they always have.


But the addition of more rows was needed, and there have been situations
in
the past when 256 columns wasn't enough - mostly due to lack of foresight
on
my part, and having to transform all the data on a sheet because changes
made
long after the initial design ran me out of columns.

Yes, especially for a whole years of daily data, but did we really need 16K
and 1M?


One thing I've been wondering about is how the extended row numbers will
affect 'standard practice' functions like =Range("A65536").End(xlUp) - are
all of those going to have to change to Range("A1000000").End(xlUp) or I'm
hoping they will provide a constant that is Excel version-conscious to use
to
reference the highest numbered row on a sheet, maybe like Range(A &
xlLastPossibleRow).End(xlUp), where value of xlLastPossibleRow is
determined
by version of Excel.


If you had coded well, you would not have a problem. There has always been a
constant

Range("A" & Rows.Count).End(xlUp)

is future-proof.

Or you could use SpecialCells(xlCellTypeLastCell), now and in future.

Excel needs to allow infinite rows and columns.
 

Ok, Bob. so what you are saying is that I am out of luck until Microsoft
comes out with the 07 version, right?

Guess that will have to do until then. When do you expect it out?

Thanks

"Bob Phillips" wrote:

Excel 2007 will have 1M+ rows, and 16K columns.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Removing multiple hyperlinks at once"
osoft.com wrote in
message ...
At work I use some information sheets that use more rows than the 65,000
or
what ever that Excel presently will allow. It would be very useful if you
could have a more unlimitied number of rows to use.
Has anyone experienced the need for this and if so how did you resolve the
issue?
Excel is a great application but that one limitation is frustrating.

----------------
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...et.f unctions

Excel needs to allow infinite rows and columns.
 

It's out now in a beta release. Check the Microsoft website for further info.

--
Regards,
Fred


"Removing multiple hyperlinks at once"
osoft.com wrote in message
...
Ok, Bob. so what you are saying is that I am out of luck until Microsoft
comes out with the 07 version, right?

Guess that will have to do until then. When do you expect it out?

Thanks

"Bob Phillips" wrote:

Excel 2007 will have 1M+ rows, and 16K columns.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Removing multiple hyperlinks at once"
osoft.com wrote in
message ...
At work I use some information sheets that use more rows than the 65,000
or
what ever that Excel presently will allow. It would be very useful if you
could have a more unlimitied number of rows to use.
Has anyone experienced the need for this and if so how did you resolve the
issue?
Excel is a great application but that one limitation is frustrating.

----------------
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...et.f unctions

Excel needs to allow infinite rows and columns.
 

Bob,
Thanks a TON! for that - actually I hadn't ever used .End all that much at
all until stumbling into the forums here and found it being used as I
referenced it earlier, I actually cannot recall an instance of seeing it used
with the constant. What I learned about it I learned in these forums and I
won't mention any names (although I doubt the list would include yours). I
very much appreciate your response to this.

I concur: program it right and it'll last longer. I also say - teach it
right and fewer bad habits will get passed along to future generations.

"Bob Phillips" wrote:


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
I think we're going to need a bigger computer.

16K * 1M = 16GB just to hold one sheet full of nothing but a single
character in each cell. That's besides overhead to define the sheet and
addresses involved.


Bad practices will create problems in the future just as they always have.


But the addition of more rows was needed, and there have been situations
in
the past when 256 columns wasn't enough - mostly due to lack of foresight
on
my part, and having to transform all the data on a sheet because changes
made
long after the initial design ran me out of columns.

Yes, especially for a whole years of daily data, but did we really need 16K
and 1M?


One thing I've been wondering about is how the extended row numbers will
affect 'standard practice' functions like =Range("A65536").End(xlUp) - are
all of those going to have to change to Range("A1000000").End(xlUp) or I'm
hoping they will provide a constant that is Excel version-conscious to use
to
reference the highest numbered row on a sheet, maybe like Range(A &
xlLastPossibleRow).End(xlUp), where value of xlLastPossibleRow is
determined
by version of Excel.


If you had coded well, you would not have a problem. There has always been a
constant

Range("A" & Rows.Count).End(xlUp)

is future-proof.

Or you could use SpecialCells(xlCellTypeLastCell), now and in future.

Excel needs to allow infinite rows and columns.
 

A small footnote, Rows.Count will refer to the activesheet, which is not a
problem unless your project includes chart sheets. Then you'll want to
qualify it

Sheet1.Range("A" & Sheet1.Rows.Count).End(xlUp)



"JLatham" wrote:

Bob,
Thanks a TON! for that - actually I hadn't ever used .End all that much at
all until stumbling into the forums here and found it being used as I
referenced it earlier, I actually cannot recall an instance of seeing it used
with the constant. What I learned about it I learned in these forums and I
won't mention any names (although I doubt the list would include yours). I
very much appreciate your response to this.

I concur: program it right and it'll last longer. I also say - teach it
right and fewer bad habits will get passed along to future generations.

"Bob Phillips" wrote:


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
I think we're going to need a bigger computer.

16K * 1M = 16GB just to hold one sheet full of nothing but a single
character in each cell. That's besides overhead to define the sheet and
addresses involved.


Bad practices will create problems in the future just as they always have.


But the addition of more rows was needed, and there have been situations
in
the past when 256 columns wasn't enough - mostly due to lack of foresight
on
my part, and having to transform all the data on a sheet because changes
made
long after the initial design ran me out of columns.

Yes, especially for a whole years of daily data, but did we really need 16K
and 1M?


One thing I've been wondering about is how the extended row numbers will
affect 'standard practice' functions like =Range("A65536").End(xlUp) - are
all of those going to have to change to Range("A1000000").End(xlUp) or I'm
hoping they will provide a constant that is Excel version-conscious to use
to
reference the highest numbered row on a sheet, maybe like Range(A &
xlLastPossibleRow).End(xlUp), where value of xlLastPossibleRow is
determined
by version of Excel.


If you had coded well, you would not have a problem. There has always been a
constant

Range("A" & Rows.Count).End(xlUp)

is future-proof.

Or you could use SpecialCells(xlCellTypeLastCell), now and in future.