Refresh queries in workbook not working
I have an Excel workbook with 12 sheets, every sheet contains 1 single query, with VB macro's the first sheet collects data from the queries and adjusts the formatting.
I gave ALL queries the same variables so the input screen should only be filled in once. Also all properties settings of the queries are the same.Now i run into the following issue.
When i refresh the queries, all queries are refreshed and filtered on the entered variables except for 1. This 1 querie is refreshed, but without filters, it contains all data. I tried to remove the query and insert it again. After this the 1 query is correct but the issue appears for another query.
Does anyone have an idea?