Tips to speed up navigation and usage of a data and formatting heavy xlsm

[RockandGrohl]

Hi guys,

We have several data files that grow each week and they are starting to get out of hand.

One such file is 13,376 rows long by 35 columns wide, and most fields are filled with data and formatted in a block of colour (without conditional formatting).

There are no live formulas, or pivot tables, or anything really. As far as I can see it's just a large block of data with a couple extra tabs with a very small amount of different information (just values held in some other cells)

Nevertheless, this sheet is now extremely sluggish - We are running on quad core, 8 thread PC's with SSD's and 16GB RAM, running Office 2010 64bit, and clicking on other cells gives a 1 second lag. Using the scroll wheel on the mouse is impossible and the sheet is generally just a chore to navigate around.

Are there any techniques to speed up navigation of this sheet? Thank you.

 

[RockandGrohl]

Just found this from the excellent Peter_Ss

Slow scrolling on large sheet

If you clear print area, it immediately solves how slow the scrolling is.

Cheers, Peter!