Skip to Content
0
Former Member
Oct 03, 2008 at 12:10 PM

Refresh queries in workbook not working

880 Views

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