I have built a couple of SQL queries that pull directly into a table using the Power Query feature in Excel 2013. I added a couple of non-queried columns to my table (a couple of VLOOKUP formulas and a Week of column). The problem is that when my query runs, my formulas don't autofill for the new data. I have to go in and pull the formulas down to the new rows every time the query runs which, as you can imagine, is less than ideal.

So my question is this: is there a setting somewhere that makes it so that when I run the query my non-query formulas will autofill down to the new rows?

Thanks for the help.