Hello all,
It seems that a sheet will automatically refresh after a fixed period of time, assuming you have no unsaved changes, when someone else has made a change to the same sheet. It'll give you a pop-up message and then display the refresh icon next to the sheet title.
Does this happen after a specific period of time?
I also notice, sometimes a sheet doesn't seem to entirely refresh. Actually, only the cell that was changed is highlighted blue and it changes without refreshing the entire sheet. Is there a reason why it triggers and whole-sheet refresh sometimes versus the individual cell refresh?
Thank you!