Roger
It was inevitable, what worries me is that with 65,000 rows and 256 columns,
any SUMIFs, VLOOKUPs, etc grind the workbook to a halt. Granted, XL2007 has
a new multi-threaded calculation engine, which will help, but that much data
just shouldn't be in Excel, it's highly inefficient and cries out for a
normalised database, with Excel as a front-end to do the summary reporting.
In my eyes, we will come to regret the bigger grid!
My £0.02
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT_at_zen.co.uk.ANDTHIS
"Roger Govier" <roger_at_technologyNOSPAM4u.co.uk> wrote in message
news:eqbZ6aCnGHA.4636_at_TK2MSFTNGP03.phx.gbl...
> And how long did we all think it would be before someone asked for the new
> limit of 1 million rows in Excel 2007 to be increased<vbg>
>
> wise_man the new version of Excel has had the limits increased to 1
> million rows and 16,000 columns.
> At present it is not released as a final product, but is available as a
> Beta download from the Microsoft website.
> Maybe you could try it out to see if it is of help to you, but be aware
> that it is still a BETA version.
>
> --
> Regards
>
> Roger Govier
>
>
> "wise_man" <wise_man_at_discussions.microsoft.com> wrote in message
> news:7EC1FA81-FE50-4C67-A897-D8E88B6AC267_at_microsoft.com...
>> I'm working in Telecom industry, where I'm using Excel almost 90% of my
>> duties, I am facing the problem when I want to transport the information
>> from the billing system to Excel, I am talking about 1,000,000 + entries
>> (rows), where excel it only have 65,000 rows, it is very difficult to
>> split
>> the data into different sheet, it is also a time consume to run the quiry
>> in
>> the billing by considering the limitation of excel, to carry all the rows
>> extracted from billing. i.e. I f i want the data from 1st to 31st, then I
>> have split them in 3 group ( ten days each) I would suggest to increase
>> number of rows atleast to 2,000,000 rows. in addition to that CDR
>> extracted
>> from billing system contains more then 2,000,0000 entries.
>>
>> ----------------
>> 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/community/en-us/default.mspx?mid=7ec1fa81-fe50-4c67-a897-d8e88b6ac267&dg=microsoft.public.excel.misc
>
>
Received on Sat Jul 01 2006 - 04:49:28 PDT