This is my first post in this forum though I have found many solutions here over the years. I hope I have my thread titled properly.

I have Office 2010 and have a table linked to an external ODBC connection. I have 3 calculated columns included in the table to the right of the data rows returned by the query but when the query is refreshed the formulas do not automatically extend. Only the last row has the formula and there's a big gap with no formulas. "Fill formulas in tables to create calculated columns" is checked in options - auto correct.

I've searched the web and this site and tried deleting and recreating the columns as suggested but it doesn't work. Is there a way to resolve this either in Excel or using VBA? It makes tables worthless if you can't count on this feature to be consistent. I miss the check box for "Fill down formulas in columns adjacent to data" that you get on non-table data sets returned from ODBC.