Why does this Googlesheets workbook take so long to update?

azairvine

New Member
Joined
Nov 17, 2018
Messages
17
https://docs.google.com/spreadsheets/d/1mrmVxKVgG1JWtIpXi6pca2mck8WJhbFQACsxtCqXCOQ/edit?usp=sharing

I've got a tonne of VLOOKUP references - and maybe the conditional formatting isn't as efficient as it could be (it was the only way I could figure it out).

Everything does what it needs to do, but it can take 10-20min to populate the cells and format the cells colours etc when I enter new data. It's not a big drama as nothing is really time dependant, I'm just interested to know what's causing the bottleneck. From what I've read sheets need to be gargantuan in theory to slow the processing down.

I'm using an i5 with 16GB RAM - the browser (Firefox) doesn't go over 4GB RAM and about 40% CPU while the sheets are updating.

I'm assuming that anyone who loads the workbook will see the lag if they click on the "Pack Opening" tab - it's supposed to look something like this:

TH59JVH.jpg
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
The sheet that I linked may not demonstrate the delays I'm experiencing as it's a stripped down template with fewer sheets. The lag seems to be most significant with the cell colours - conditional formatting in other words.
 
Upvote 0

Forum statistics

Threads
1,223,886
Messages
6,175,194
Members
452,616
Latest member
intern444

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
Back
Top