At least on my spreadsheets, it appears when you're in a table in another sheet to show you where the data is coming from. E.g. I have a couple of pivot tables in separate sheets: when I click in one of them, the green dot appears on the sheet where the base table is stored. If I click outside the pivot table, the green dot disappears.
Could that be the same for you?