Extremely Slow Scrolling WorkSheet

K

Ken

Excel2003 ...

Approx 15 Cols by 35000 Rows ... Cols A & B have Conditional Formatting (1
Condition each) ... Col H has a simple Sum formula ...

Issue ...

Up/Down Scroll extremely slow (often jerks (blinks) page to page like
records are trying to catch up) ... I changed Calcuation from Auto to Manual,
but makes no difference ... Looking for suggestions ... Thanks ... Kha
 
D

Dave Peterson

Remove the Format|Conditional formatting???


Excel2003 ...

Approx 15 Cols by 35000 Rows ... Cols A & B have Conditional Formatting (1
Condition each) ... Col H has a simple Sum formula ...

Issue ...

Up/Down Scroll extremely slow (often jerks (blinks) page to page like
records are trying to catch up) ... I changed Calcuation from Auto to Manual,
but makes no difference ... Looking for suggestions ... Thanks ... Kha
Click to expand...
 
K

Ken

Dave ... (Good morning)

Yeah ... AWESOME ... Yes you are correct ... Only problem is ... It is the
Conditional Formatting on this file that I need the most ... :)

Thanks for all the support on this board ... Kha
 
D

Dave Peterson

There are trade-offs for everything.

I think you're going to have to choose which is more important.
 
K

Ken

Yes Sir ... I do understand ... Thanks ... Kha

Dave Peterson said:
There are trade-offs for everything.

I think you're going to have to choose which is more important.
Click to expand...
 
D

David McRitchie

If you have a simple SUM statement that referring to an increasing
range on every row, instead of simply using the value on the previous
row, you could have one very inefficient worksheet.
Look for =SUM(D$2:D2) in
http://www.mvps.org/dmcritchie/excel/slowresp.htm

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Ken said:
Yes Sir ... I do understand ... Thanks ... Kha
Click to expand...
 
Top