Extremely Slow Scrolling WorkSheet

[Guest]

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

 

[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

 

[Guest]

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

 

[Dave Peterson]

There are trade-offs for everything.

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

 

[Guest]

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

There are trade-offs for everything.

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

 

[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$22) 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

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