excel's speed - too many rows?

  • Thread starter Thread starter Iain King
  • Start date Start date
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
 
Unless your formulas must update often why not have a macro create the
values of the formulas.
 
the formulas are for conditional formating (colour banding the rows to make
it easier to read)
should it be going this slow?

Iain King
 
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
 
Back
Top