Hi,

I'm having a issue with an INDEX function used against the output of a data connection in Excel 2007 (an ODBC query on the workbook itself).

The data connection is used to perform an inner join on three data input sheets and output key fields and the row numbers of the input data. As far as I can tell the query is working fine and is producing the expected results.

On the same sheet as the output from the query, I am using a series of INDEX functions to retrieve data from the input sheets using the row number returned by the query. Again this all works as expected.

/ The issue /

When the data connection is refreshed and rows are removed from the result set , for those rows that have been removed, the INDEX functions continue to operate as if the data in the deleted rows is still present. So in the image below, the formula in INDEX formula in BA38, is using the row number in G38.

Issue.JPG

It has the appearance that the INDEX function is referencing a cached or older version of the result set.

I've tried all of the usual methods to resolve, making sure calculations are on automatic, manually refreshing, reapplying the formulas, evaluating formulas, but without success.

Any direction or suggestions to resolve would be much appreciated.

Many thanks,
Mark