Sloooooow Scrolling?

K

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
 
B

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
 
B

Bruce Sinclair

broro183 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top