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

RockandGrohl

Well-known Member
Joined
Aug 1, 2018
Messages
671
Office Version
  1. 2010
Platform
  1. Windows
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.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,147,452
Messages
5,741,209
Members
423,649
Latest member
steel1968

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top