Refresh all with Sharepoint data query

[alex steigerwalt]

Hello,
I have an excel spreadsheet that I use to manipulate data that is entered through a sharepoint site. I have a query for the database. I have formulas referencing the tab that the query data exists. When I refresh all, and get new data from the query, it seems to change the formulas. For example, if I have 3 new data sets entered into the sharepoint site, and I click fresh all, the formulas that reference that log update to the last row of the data. Not sure if any of this makes sense so I took a video of what is happening, I apologize for the poor quality.

I can answer any questions that you have but I would appreciate any help on this issue.

Here is the link to the video Google Drive Video