i have a query from sql server dbase application that i created in excel via odbc
the query contains 4 column from a to d
i add vlooup functioc in column E .
when i refresh the query after adding new records to the database
the function is not auto fill
for example if befor records adding i had 4 rows and i added 5 records
i recived 9 rows but row 5-8 are empty in e column

any one have idea why ?