We have a workbook at work that takes about 30 seconds to calculate in 2003
and about 20seconds in 2007, which is great, but this is inter-worksheet
linking and not at all using a lot of rows and columns.

There's a huge difference between 16777216 cells (972003) and 17179869184
cells (2007). I'm not even sure if you can enter a 1 in each without hitting
the memory limit...off to try!

3 minutes so far and showing as (not responding)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Roger Govier" wrote in message
...
Hi Nick

I quite agree.
It was perhaps foolish of me not to point out in my post that a database
solution would be far preferable.

I still haven't loaded my copy of XL2007 yet to even look at what a
calculation on a single column of 1m rows behaves like - just for the hell
of it, not because I would contemplate using it in this way.

--
Regards

Roger Govier


"Nick Hodge" wrote in message
...
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
HIS


"Roger Govier" wrote in message
...
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" wrote in message
...
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/comm...lic.excel.misc