I have a query that reads a few csv files.  It’s a simple query.  There are a couple thousand rows, but it’s not complicated.
That data is loaded into a table.

I then added columns in excel, adjacent to the table with formula.  Fairly straight forward.

Problem: When I update the query, new data comes in as expected, but the adjascent cells do not autofill down UNTIL you get to the last row of the new data where (somehow) the formula are filled across that row in all the adjascent columns. There’s litterally a gap between the last previous row of formula and the newly minted last row in the table.

I’ve tried several fixes, none have worked. Hoping someone can point me in the right direction.  One thing I’m wondering is the whether the formula structure is causing an issue.  I am not using structured formlas, rather simply referencing cells.

​I have a query that reads a few csv files.  It’s a simple query.  There are a couple thousand rows, but it’s not complicated.That data is loaded into a table.I then added columns in excel, adjacent to the table with formula.  Fairly straight forward.Problem: When I update the query, new data comes in as expected, but the adjascent cells do not autofill down UNTIL you get to the last row of the new data where (somehow) the formula are filled across that row in all the adjascent columns. There’s litterally a gap between the last previous row of formula and the newly minted last row in the table. I’ve tried several fixes, none have worked. Hoping someone can point me in the right direction.  One thing I’m wondering is the whether the formula structure is causing an issue.  I am not using structured formlas, rather simply referencing cells.  Read More

​