If you are working too much on the Google Sheet.

You will often find it working really slow. It is true pain to watch the numbers taking hours to appear on the sheet.

I’m probably exaggerating a bit. But, it does get a lot slower.

And you can get Google Sheet working a little better by clearing the stored cache. You clear the cache via following one of the given below methods:

How to Clear Cache for Google Sheet via Desktop?

Step 1: Open up the Google Sheets apps in Google Chrome.

Step 2: Next, tap the padlock icon.

Step 3: A drop down menu will appear in front of your screen, from the menu select, ‘Settings”.

Step 4:  Now, you will find yourself on a new “Settings” page, here go to the “Usage” section.

Step 5: Hit, “Clear data”.

How to Clear Cache on an Android phone?

Step 1: Launch the Settings app of your Android device.

Step 2: Select, “Apps”.

Step 3: Again, select “Apps”.

Step 4: Then, select ‘Google Sheets”.

Step 5: Hit, “Storage”.

Step 6: Select “Clear Cache”.

How to delete the Cache from the Google Sheet App?

Step 1: Open up the Google Sheets app.

Step 2: Click the hamburger menu to open up the drop down menu.

Step 3: Select, “Settings”.

Step 4: Go to the “Documents Cache” section.

Step 5: Hit, “Clear Cache”.

Step 6: Hit, “OK” button.

How to Clear Cache on iPhone?

Step 1: Hit the three dots, to open up a drop down menu.

Step 2: Select, “History”.

Step 3: Select, “Clear browsing data”.

Step 4: Tick “Cached images and files”, and select the “Clear data” button.

Step 5: Select the sites for which you want your Cache data to be deleted. Hit the “Clear” button.

Source: https://support.google.com/docs/thread/32416199/google-sheets-not-loading-in-chrome-even-after-clearing-cookies-and-cache-but-works-in-ie?hl=en