Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Many thanks,


Not what you were looking for? View more on this topic or Ask a question