Power Query and Load to Table - Refresh All doesn't add updated values

Hi all,
This seems so simple, but I cannot find the solution to this problem I've been encountering for weeks. I cannot post my file for security reasons, but I'll try to explain what's going on.

Here is what I'm trying to do:
- Power Query data from online source
- Load data to a table that is saved in SharePoint (but synced to my desktop)
- Once a day, open the file, click "Refresh All", and any new data is added and old data is updated

Here's what works:
- The Power Query loads the data to a table successfully

Here's what doesn't work:
- If I close the file and go back to it a few days later, click "Refresh All" - nothing happens: the query has changed to "Connection Only"
- OK, so I change it back to "Load to" and try to refresh - this gives me the error: "query results cannot overlap a table or xml mapping".
- I can delete the old table and then load the new one, but doesn't that defeat the purpose of the "Refresh" button? Also, I would like to eventually use this regularly updated dataset in other files, so creating a new table every time will be a pain.


I don't understand why Excel is forgetting the original query-table connection. Does anyone have any thoughts on what could be happening?

The only thing I have in the sheet is the table that I want to refresh.