If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sloooooow Scrolling?
Excel2003 ... I have 1 WorkSheet that Scrolls ever so slow ... Up/Down Scroll
will not move when you drag it ... the Screen Flickers in Stages & Scroll Bar eventually moves ... This is killing me ... Page Breaks are unchecked No Conditional Formatting Zoom is @ 100% File is 40,000 records What next? Thanks ... Kha -- Kha |
#2
|
|||
|
|||
Sloooooow Scrolling?
In article , broro183
wrote: hi, Can you please provide more details about your file, for example... Do you have many volatile, repeated or calculation-intensive formulae in your spreadsheet? (eg indirect, offset or large blocks of sumproducts or array (CSE formulae) ) Are there a lot of links to closed workbooks? You may find some useful information in the below pages or the links: 'Slow Response, Memory Problems, and Speeding up Excel' (http://www.mvps.org/dmcritchie/excel/slowresp.htm) 'How the Excel Smart Recalculation Engine works - Decision Models' (http://www.decisionmodels.com/calcsecrets.htm) Another possibility ... are there a lot of charts ? These can slow down many things, and I think scrolling is one of them. |
Thread Tools | |
Display Modes | |
|
|