excel's speed - too many rows?

I

Iain King

Hi there. I have a sheet with approx 26000 rows on it. Each row has five
non-iterative calculations which reference only that row or the row above.
Sometimes excel will take a very long time to update - this can happen when
I modify the autofilter, but can also happen on saving, or even loading.
Excel goes into 'not responding', but will eventually come around, after at
least half an hour. This is a 1.8 Ghz machine. Is this the expected
performance of excel with this many rows, or do you think there's a problem
somewhere in the sheet generating lots of calculations?

Thanks, Iain King
 
D

Don Guillett

Unless your formulas must update often why not have a macro create the
values of the formulas.
 
I

Iain King

the formulas are for conditional formating (colour banding the rows to make
it easier to read)
should it be going this slow?

Iain King
 
D

David McRitchie

Hi Iain,
Color banding for use without filters should go very fast.

Normally color banding uses a formula like
=MOD(ROW(),2)=0 for alternate row banding
=MOD(ROW(),3)=0 for every 3rd row colored
for more information on this form of color banding and adjusting
which lines will be banded see Chip Pearson’s page on banding.
http://www.cpearson.com/excel/banding.htm

The formula evaluates to True or False
which is what Conditional Formatting is looking for
http://www.mvps.org/dmcritchie/excel/condfmt.htm
 
Top