Sloooooow Scrolling?

[Ken]

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

 

[broro183]

hi,

Can you please provide more details about your file, for example...
Do you have many volatile, repeated or calculation-intensive formula
in your spreadsheet?
(eg indirect, offset or large blocks of sumproducts or array (CS
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)

hth
Rob

 

[Bruce Sinclair]

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.