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.