Excel gets more Rows and Columns

[TonyJollans]

Just thought some of you might like to know this: Excel 12

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[SilentAiche]

Tony,

Thanks for the info on Excel 12 - that's an exponential leap from current capabilities. Why the "Great Leap?" (not that I mind, mind you).

Are Excel and Access about to become "one?"???? For "Little Users," will AccCel become prohibitively expensive?

Tim

[blue]______________________________________________________________
I love logging onto Tek-Tips. It's always so exciting to see what the hell I
said yesterday. [/blue]

 

[SkipVought]

Yes, it has been a column bind and the bloom has been off the rose.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[TonyJollans]

Hi Tim,

Why they've made the change is obviously down to overwhelming user demand. Why they've chosen those particular dimensions I don't know. It's still less rows than an Access Table can have, but more columns. I haven't yet seen anything about Access 12 but I don't think the Jet engine is likely to be updated so it could be interesting.

At the moment it raises a lot of questions. I guess information is going to keep on coming out over the next few months.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[AnotherHiggins]

Thanks for the link, Tony. I can't wait to have over a million rows to play with. I wonder how slow it will run with 1 million rows....

Increasing from 2¹⁶ to 2²⁰ rows and from 2⁸ to 2¹⁴ columns is indeed a huge leap!

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[xlbo]

personally, whilst I welcome the added functionality, I fail to see how adding extra rows will benefit when excel can't really deal with >30,000 rows anyway (for functioning manipulation) - I know it can but really - would you use an excel worksheet that crawls with 30,000 rows or would you just export it to Access and work with it much quicker there....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[TonyJollans]

Hi Geoff,

I can't really see people using the extra rows AND the extra columns at the same time but, if there are going to be constraints at all it makes sense to allow more of both.

Real world usage of spreadsheets is often little to do with the original intention. Often only one or two columns of many rows are used - and vice-versa. Even if only temporary, imports have in the past been constrained by the 64K row limit. Of course the big gain is the column one - the ability to have a column for every day (of forty-odd years) is going to be beneficial for many people.

Performance is an interesting issue. Office 12 is coming out sometime next year and, before the end of its life, hardware is likely going to be ten times more powerful than it is now. Bigger worksheets should become manageable - and there will no longer be so many (complex) multi-sheet workarounds.

I may be alone in this but I don't think Excel and Access are interchangeable just because both are loosely grid-based. In the past some people have used Excel for what should have been done in Access because they didn't want to pay for Access licences. This may or may not have been a sensible business decision but was probably never a good technical decision; just because something is possible doesn't make it sensible. I'm not sure the converse is true - large spreadsheets do not necessarily transfer easily to databases, even if the software is available. It's horses for courses and if people use the wrong horse they deserve a rough ride.

Skip

LOL. I had to read it a couple of times - I'm getting slow in my old age!

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[xlbo]

Very true Tony - many good points. To me, this will just make people even more likely to stick with Excel even when it is not a good idea - and I agree with the Access / Excel not being interchangeable - just because 1 table looks like it could be part of a spreadsheet is neither here nor there - Access works on columsn and fields, excel works on cells - Access has no idea what a cell would be - that plus the vast difference in object models makes me think that the twain shall never meet.

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[TonyJollans]

Agreed - the twain shall probably never meet, and I'm sure you're right that the bigger grid will encourage more abuse - unless there is something else in the pipeline to counteract the possibility.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[TonyJollans]

I see the link now has a new entry with a heap more info about limits being lifted. One to watch.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[