In Excel, I have a querytable linked to an SQL table. Formulas inside of my spreadsheet contain references to the cells inside the table, using absolute references such as
I use vba to update the SQL query for the table. The trouble starts when I change the column that I pull from SQL. The cell references break, even though the data I am interested in is in the same cell.
I obviously run into the same problem if using the
=Table1[Column1] reference methodology because the column name changes. Is there a way to change a column in a querytable without breaking sheet formula references to that column?