Extremely Slow Scrolling WorkSheet
 

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

Extremely Slow Scrolling WorkSheet
 

Remove the Format|Conditional formatting???



Ken wrote:

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

Extremely Slow Scrolling WorkSheet
 

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" wrote:

Remove the Format|Conditional formatting???



Ken wrote:

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

Extremely Slow Scrolling WorkSheet
 

There are trade-offs for everything.

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

Ken wrote:

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" wrote:

Remove the Format|Conditional formatting???



Ken wrote:

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


--

Dave Peterson

Extremely Slow Scrolling WorkSheet
 

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

"Dave Peterson" wrote:

There are trade-offs for everything.

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

Ken wrote:

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" wrote:

Remove the Format|Conditional formatting???



Ken wrote:

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


--

Dave Peterson

Extremely Slow Scrolling WorkSheet
 

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" wrote in message ...
Yes Sir ... I do understand ... Thanks ... Kha

"Dave Peterson" wrote:

There are trade-offs for everything.

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

Ken wrote:

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" wrote:

Remove the Format|Conditional formatting???



Ken wrote:

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


--

Dave Peterson