Variable don't filter all the workbook queries

[Former Member]

Hello all,

My problem is that in my workbook the variables aren't filtering the data in all the queries where they are used.

If you know something about it please inform me.

Regards,

Ana

[Former Member]

Hi Ana.

Also make sure that you are using the same variables in all the queries.

You could also try to remove the queries where the variables are not being used and insert them again by choosing tools -> remove query and afterwards tools -> insert query. Finally save the workbook again.

Hope it helps.

BR

Stefan

[Former Member]

Ana,

In the properties of the workbook, select the option refresh all the queries in the workbook when opened. It should solve your problem.

[Former Member]

Hello,

Sorry but it didn't work.

Would my problem be related with the fact that the variables are defined as "Changeable with Query Navigation"?

Regards,

Ana