View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bruce Sinclair Bruce Sinclair is offline
external usenet poster
 
Posts: 169
Default 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.