# Google Sheets question - progress bar for autosave or loading **URL:** \ **Category:** Ask for Help\ **Created:** [September 14, 2021, 11:10pm UTC](https://community.glideapps.com/t/google-sheets-question-progress-bar-for-autosave-or-loading/31798 "2021-09-14T23:10:51Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![BlakeWS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blakews/32/24377_2.png) [@BlakeWS](https://community.glideapps.com/u/BlakeWS)\ **Post date:** [September 14, 2021, 11:10pm UTC](https://community.glideapps.com/t/google-sheets-question-progress-bar-for-autosave-or-loading/31798/1 "2021-09-14T23:10:51Z")
Do any of you Sheets experts know the deal with this progress bar in the top right corner of my Sheets? It seems to be a newer feature and I’m not sure exactly what it’s supposed to tell me. It seems to be cycling far too often, and slowing Sheet loads(?) as it’s cycling multiple times in succession. It’s cycling even when the Sheet is fully loaded and I haven’t modified any cells. Autosave used to be after keystrokes to my knowledge. ![sheets-progress-bar](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e2f49974cd212b16ea02ed2a9653d5b07330cced.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 14, 2021, 11:25pm UTC](https://community.glideapps.com/t/google-sheets-question-progress-bar-for-autosave-or-loading/31798/2 "2021-09-14T23:25:48Z")
I believe it’s the progress bar showing when your Sheet is calculating something. If the bar isn’t fully loaded then there maybe calculations still not finished somewhere. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 15, 2021, 12:53am UTC](https://community.glideapps.com/t/google-sheets-question-progress-bar-for-autosave-or-loading/31798/3 "2021-09-15T00:53:51Z")
It’s not new. It’s been there for as long as I can remember. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 15, 2021, 1:23am UTC](https://community.glideapps.com/t/google-sheets-question-progress-bar-for-autosave-or-loading/31798/4 "2021-09-15T01:23:45Z")
I’ve had that. Used to have really heavy calculations in my sheet and it would take several minutes to run through all of the calculations. Have since made a lot of improvements to make my sheet more efficient and moved a lot of the calculations into glide columns. Now I only see the progress bar for a few seconds whenever it’s calculating something. ---
**Author:** ![BlakeWS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blakews/32/24377_2.png) [@BlakeWS](https://community.glideapps.com/u/BlakeWS)\ **Post date:** [September 15, 2021, 2:05am UTC](https://community.glideapps.com/t/google-sheets-question-progress-bar-for-autosave-or-loading/31798/5 "2021-09-15T02:05:53Z")
I did some poking around and some testing… > [@ThinhDinh](#): > > I believe it’s the progress bar showing when your Sheet is calculating something. If the bar isn’t fully loaded then there maybe calculations still not finished somewhere. It seems that some random number generators that I was using on one sheet are updating even when I’m not on that sheet. Why, why?? > [@Darren\_Murphy](#): > > It’s not new. It’s been there for as long as I can remember. I guess it was new to me because I hadn’t been using these random number generators before. > [@Jeff\_Hager](#): > > Have since made a lot of improvements to make my sheet more efficient and moved a lot of the calculations into glide columns. I’m trying to use tables as much as possible, that’s for sure! The worst part of using tables is just getting the initial app info typed in - the UX is still cringy at times. Thanks guys! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 15, 2021, 2:18am UTC](https://community.glideapps.com/t/google-sheets-question-progress-bar-for-autosave-or-loading/31798/6 "2021-09-15T02:18:25Z")
> [@BlakeWS](#): > > It seems that some random number generators that I was using on one sheet are updating even when I’m not on that sheet. Why, why?? Are you using any volatile functions in your formulas? (specifically now(), today(), rand() or randbetween())? If you are, check how they are recalculated. File → Spreadsheet Settings → Calculation ![Screen Shot 2021-09-15 at 10.17.48 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/c/3c64730eb4c1dbb4ea380c0ca07760462ae11702.png) ---
**Author:** ![BlakeWS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blakews/32/24377_2.png) [@BlakeWS](https://community.glideapps.com/u/BlakeWS)\ **Post date:** [September 15, 2021, 2:59am UTC](https://community.glideapps.com/t/google-sheets-question-progress-bar-for-autosave-or-loading/31798/7 "2021-09-15T02:59:12Z")
Thanks for this, I am using rand and randbetween. The setting was “on change and every hour”, I changed it to “on change” and now it’s seemed to settle down, although I’m not sure why that would make the difference. 🤷‍♂️