Skip to Content

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

Refresh queries in workbook not working

Hello,

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,

Cerillo

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