Slow scrolling on large sheet

[SilverChewy]

I currently have a workbook with 6 sheets, the main worksheet has roughly 10000 rows rows (with is the one Im having trouble with) up until a few days ago scrolling wasnt to bad but just recently it is really struggling to scroll (no changes to workbook)

I have a quad core Q6600
4GB ram
plenty of HDD space

the excel doc size is 2.8MB

is there anything I can do to improve scrolling on large spreadsheets?

 

[Stormseed]

Scrolling on worksheets should not be a problem, does not matter whatever size is the workbook or file. What is it that you are trying to do and what do you mean by "slow scrolling" ? Also, have you checked your "mouse options" in the Control Panel of Windows ?

 

[RoryA]

Do you have a lot of conditional formatting or shapes on the sheet? (last time I saw that behaviour, the sheet had over 800 invisible shapes on it!)

 

[SilverChewy]

yeah it does have some conditional formatting aswell as a lot of vlookups and if statments

the main worksheet pulls data from various values from worksheets in the workbook, it has been working fine however last night when I was using it (as well as today) it scrolls baddly, when I say scrolls badly it does not seem to refresh the screen correctly and lags or lumbers through the process.

Is there a way of clearing conditional formatting from certain columns?

 

[SilverChewy]

cheers Rorya,

i figured out the conditional formatting and once I cleared it it became much more responsive.

Cheers for the idea

 

[Peter_SSs]

Sounds like you might be sorted now, but one other cause of this sort of behaviour I have seen at times is when the Print Area has been set to a number of whole columns - particularly in sheets with a large amount of data.

 

[herbert]

To Peter:

Thank you for your tip/help. I never would have guessed that if I select entire columns when I set the "print area," this would affect and slow the scrolling. And my data was not complex or large at all, no formulas, just around 300 rows of numbers and data.

 

[Peter_SSs]

To Peter:

Thank you for your tip/help. I never would have guessed that if I select entire columns when I set the "print area," this would affect and slow the scrolling. And my data was not complex or large at all, no formulas, just around 300 rows of numbers and data.

Welcome to the MrExcel board!

Glad to help, and if you signed up especially to make this post, a special "thanks".