Forum Discussion
Sheet Reference Issue
I often construct formulas by typing "=function..." and selecting the cell ranges by mouse or cursor. When a formula refers to a cell on the same sheet, the sheet name is not needed in the reference...
I was able to solve this last year by changing a setting in Google Drive File Stream, which is installed on my computer. Previously the option 'Show who is editing Office files, and share with other editors if I am editing' was checked. After unchecking this, it seems like this fixed the issue.
Since then, the google application has changed and the option looks different. But might be worth checking if it's a file-sync interaction across google drive / box / dropbox / onedrive / etc by disabling them and see if it fixes the issue.
I agree, it is super annoying that excel references the active sheet as if it were an external sheet. It makes the data unsortable and prone to errors.
Since then, the google application has changed and the option looks different. But might be worth checking if it's a file-sync interaction across google drive / box / dropbox / onedrive / etc by disabling them and see if it fixes the issue.
I agree, it is super annoying that excel references the active sheet as if it were an external sheet. It makes the data unsortable and prone to errors.