I am using Excel as Second data provider with 2 columns. In the main query, I am using one column as a query filter. I had 7000 VINs to pull so I was using OR clauses and filtering it 1000 At a time. When I modified the excel sheet, I had to remove all the 7 different sheets and replace them all. Basically I had to re-create the whole report again.
Is there a way that I am missing when I modify the excel, to replace it and run the query as normal?
Please keep me posted.