To stop the worksheet name from coming automatically while referring a cell or range of cells

arunmukherjee 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.