| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy / Paste extremely slow | Excel Worksheet Functions | |||
| Copy and paste link in worksheet is extremely slow. What to doÉ | Excel Discussion (Misc queries) | |||
| Why is my scrolling and paging is extremely slow and hesitates? | Excel Discussion (Misc queries) | |||
| Workbook is now Extremely Slow | Excel Worksheet Functions | |||
| Excel extremely slow opening and using | Excel Discussion (Misc queries) | |||
Linear Mode
