SQL Query table, as new rows added, helper formulas will not autofill

I've been wrestling with this for years, and I finally want to fix it. I've searched here thoroughly but nothing seems to fix it, I tried cortana this morning and its braindead, keeps telling me to convert it to a table when it already is, Ctrl-T just dings no pop up, I have table design tab in excel when I choose it, so useless. Anyway my situation:

I have several files that import large amounts of data from our snowflake database via a connection. It imports it into a table on an excel sheet with 3 formula driven helper columns over to the far right. Whenever I do a data refresh and new rows are added the formulas in those helper columns will not auto fill. Typically what happens, say my data goes to row 100 and I refresh and there are 10 new rows so the table now goes down to row 110, there are formulas down to row 99 as they were previously then blanks down to 110 and there are formulas on row 110.

I then manually copy paste my formulas into the blanks and all is well. I've tried all the suggestions, all the auto fill and table options in excel are checked that are recommended, I've deleted these 3 helper columns entirely and rebuilt fresh making sure there are only consistent formulas all the way down. I tried making the whole table a range with the hopes of making it a table again per one suggestion, but that eliminates my query connection.

Things would work so well if it would just automatically autofill and I did not have to worry with manually fixing the table with every data update, any further suggestions?

I have a feeling it has something to do with the query and table updating rows in the middle, but I've changed table properties to "Insert entire rows for new data" which then puts the blanks at the bottom instead of 1 above the bottom, but it still will not autofill the new rows.