3 ms·

I haven't used Google sheets for maybe 2 years, didn't have the need, but week ago I needed to send customer a table that will be updated every couple of days.

by dvh 1y ago

I haven't used Google sheets for maybe 2 years, didn't have the need, but week ago I needed to send customer a table that will be updated every couple of days. I was surprised how slow it is. Table has 40 lines and 8 columns, static text only, and it takes 12s until I can edit it. For what it is (adding sentence every 3 day) it's ok but if I had to actually use it for myself on a daily basis it would drive me mad.

_zoltan_ 1y ago
I use it daily and have never had this problem.
maccard 1y ago
I run my household budgetting off google sheets - a clean load of 8 sheets, wth 20-200 rows and 20-50 columns including some simple cross-sheet formulas is fully loaded and interactive in less than 2 seconds. My work's sharepoint based Excel roadmap doc is 40 rows of 8 columns and takes about 15 seconds from clicking the link to actually being readable, for comparison.
crazygringo 1y ago
It should be lightning fast for what you're describing. All I can guess is you have some browser extension interfering? Maybe one that is blocking certain calls Google uses and the sheet doesn't load until they time out? If you're running an adblocker or blocking trackers or anything like that, try disabling those to see if that makes a difference. Otherwise check the network tab of the dev console to see what seems to be slow.
bdcravens 1y ago
Definitely something more going on, like some deeply nested functions.
jeffbee 1y ago
I manage all the information for every parcel in my city in Google Sheets. It is > 29k rows x dozens of columns and it is instantly interactive when I visit the bookmarked URL.
- actuallyalys 1y ago
  Do you work for local government? I’ve heard of cities using Excel for this but not Sheets (although I’m not surprised).
- sidrag22 1y ago
  ya there is no way this isn't some local issue for something that small to take 12 seconds. my last job i force updated sheets with thousands of rows every 5 mins and it would just be like a quick 1 second blink to totally clear and replace all those rows with fresh data.

by dvh 1y ago

_zoltan_ 1y ago

I use it daily and have never had this problem.

maccard 1y ago

I run my household budgetting off google sheets - a clean load of 8 sheets, wth 20-200 rows and 20-50 columns including some simple cross-sheet formulas is fully loaded and interactive in less than 2 seconds. My work's sharepoint based Excel roadmap doc is 40 rows of 8 columns and takes about 15 seconds from clicking the link to actually being readable, for comparison.

crazygringo 1y ago

It should be lightning fast for what you're describing. All I can guess is you have some browser extension interfering? Maybe one that is blocking certain calls Google uses and the sheet doesn't load until they time out? If you're running an adblocker or blocking trackers or anything like that, try disabling those to see if that makes a difference. Otherwise check the network tab of the dev console to see what seems to be slow.

bdcravens 1y ago

Definitely something more going on, like some deeply nested functions.

jeffbee 1y ago

I manage all the information for every parcel in my city in Google Sheets. It is > 29k rows x dozens of columns and it is instantly interactive when I visit the bookmarked URL.

actuallyalys 1y ago
Do you work for local government? I’ve heard of cities using Excel for this but not Sheets (although I’m not surprised).
sidrag22 1y ago
ya there is no way this isn't some local issue for something that small to take 12 seconds. my last job i force updated sheets with thousands of rows every 5 mins and it would just be like a quick 1 second blink to totally clear and replace all those rows with fresh data.