J
Johannes Dobler
Hello,
maybe someone can help me with my problem.
I do have several pivot tables in Excel. The data are coming from an Access
database. All pivot tables are using the same Access DB, but the filtering
is different for them.
I created an overview sheet, which displays several numbers from the
different EXCEL sheets. The problem I do have is that at the end, if I want
to filter for a country, I do have to select this for each Pivot table and
cannot change the countries for all the pivot tables in one go. I do not
want to use macros, because I have to send this out and the macro security
is set to high for the users (macros are not executed).
Thanks in advance.
maybe someone can help me with my problem.
I do have several pivot tables in Excel. The data are coming from an Access
database. All pivot tables are using the same Access DB, but the filtering
is different for them.
I created an overview sheet, which displays several numbers from the
different EXCEL sheets. The problem I do have is that at the end, if I want
to filter for a country, I do have to select this for each Pivot table and
cannot change the countries for all the pivot tables in one go. I do not
want to use macros, because I have to send this out and the macro security
is set to high for the users (macros are not executed).
Thanks in advance.