Hi Rick,

AFAIK there is nothing in Excel's calculation engine that slows down beyond
32000 rows,
although the Google office desktop com addin does tend to slow Excel down
the further down and further across you go.

What was the formulae that you were using in the 5th column?

regards
Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"rcl2884" wrote in message
...
Did microsoft not expect anyone to use the bottom rows of a
spreadsheet? I was given a file with about 120,000 records. Normally I
would load this into Access for analysis, but I was giving this data
to someone not familiar with Access and so I loaded them into Excel
2003.

There were only four columns of data and I added a fifth column that
included a very simply calculation. Since I am limited by 64K rows, I
pasted the rows into two adjacent sets of columns with about 60,000
each.

The problem... recalculation takes forever. (20 minutes).

I have run into this problem before and suspect that things bog down
if you use more than 32K rows. (something to do with memory?)

I pasted the data into four sets of adjacent columns and things were
much better. Here are some specific times. (Nothing else running on
my computer)

Recalc with 2 sets of 60K rows: 1240 seconds
Recalc with 4 sets of 30K rows: 0.3 seconds
VBA macro that does the calc on cell at a time: 9 seconds

What gives? Does anyone have an explantion? Are there any way around
this log jam, if you actually want to use 60K rows? What happens on
Excel 2007 with 1,000K rows?

...Rick