5 ms·

I'm pretty disappointed with google sheet at the moment. I built some mildly complex spreadsheets for time tracking, nutrition, planning and such. They worked f

I'm pretty disappointed with google sheet at the moment. I built some mildly complex spreadsheets for time tracking, nutrition, planning and such. They worked fine a year ago but I have experienced a massive drop in performance over the past few months. They take a minute to open and awfully slow to update calculations and no longer work reliably offline either. This is on an quad core desktop ffs. This will kill cloud office apps if what works today doesn't work tomorrow. Cloud should not mean total loss of control of the version of the application. Something like gdocs should be offering frozen past versions of the app to avoid this type of thing being possible. Its not like frozen versions would actually add any maintenance cost to google. These sheets are small and just have a few array forumulae. Nothing excel 20 years would have broken a sweat over.

imjared 12y ago
Have you upgraded to the newest version of google spreadsheets? We were having some performance issues that sound just like what you're experiencing and as soon as we made the switch, our sheets were super fast.
- duncanawoods 12y ago
  I upgraded a couple when it was first released but a few basic features not supported so had to abandon the attempt. I've tried copying a problem sheet to a new file and first impressions are positive. Thanks.
  - hakanu 12y ago
    As far as I observed, latest big update improved the performance of large sheets a lot. Plus, using chrome is also making some positive difference. However, copying and pasting large data is still a problem. Instead I recommend to use copy to option within google drive.
- kertof 12y ago
  The best was definitely the remove of cell limits and row limits. If I remember correctly, it used to be at 50k linrs , which you reach in no time. The new spreadsheets are way faster indeed!
  - hakanu 12y ago
    New limits are here: https://support.google.com/drive/answer/37603?hl=en https://support.google.com/drive/answer/37603?hl=en Number of cells: 400,000 total cells across all sheets - this is the one i don't like. If you log substantial amount of columns, it fills up pretty quickly Number of columns: 256 columns per sheet Number of formulas: 40,000 cells containing formulas across all sheets Number of tabs: 200 sheets per workbook GoogleFinance formulas: 1,000 GoogleFinance formulas
    - marrone12 12y ago
      You needed to read one more paragraph, "All spreadsheet limits mentioned above have been removed in the new version of Google Sheets. The new version of Google Sheets should support 2 million cells of data, though please note that extremely large spreadsheets may have slower performance. Learn more about switching to the new version of Google Sheets."

imjared 12y ago

Have you upgraded to the newest version of google spreadsheets? We were having some performance issues that sound just like what you're experiencing and as soon as we made the switch, our sheets were super fast.

duncanawoods 12y ago
I upgraded a couple when it was first released but a few basic features not supported so had to abandon the attempt. I've tried copying a problem sheet to a new file and first impressions are positive. Thanks.
- hakanu 12y ago
  As far as I observed, latest big update improved the performance of large sheets a lot. Plus, using chrome is also making some positive difference. However, copying and pasting large data is still a problem. Instead I recommend to use copy to option within google drive.
kertof 12y ago
The best was definitely the remove of cell limits and row limits. If I remember correctly, it used to be at 50k linrs , which you reach in no time. The new spreadsheets are way faster indeed!
- hakanu 12y ago
  New limits are here: https://support.google.com/drive/answer/37603?hl=en https://support.google.com/drive/answer/37603?hl=en Number of cells: 400,000 total cells across all sheets - this is the one i don't like. If you log substantial amount of columns, it fills up pretty quickly Number of columns: 256 columns per sheet Number of formulas: 40,000 cells containing formulas across all sheets Number of tabs: 200 sheets per workbook GoogleFinance formulas: 1,000 GoogleFinance formulas
  - marrone12 12y ago
    You needed to read one more paragraph, "All spreadsheet limits mentioned above have been removed in the new version of Google Sheets. The new version of Google Sheets should support 2 million cells of data, though please note that extremely large spreadsheets may have slower performance. Learn more about switching to the new version of Google Sheets."