A
Annica Lilienberg
Help please 
I have created an excel report, that retrieves its data from a view. From
that data i have created several sheets with different pivottables. The view
is based per country, so each country has to connect to their own view. So I
use the same file and change the datasource. It looks fine when i have
updated. BUT when I use the dropdown on a field, the old values from the
last data are still visible, however they dont show anything if you choose
them. For example France has sales men a +b and Sweden c+d. when switching
datasource from france to sweden, only c+d should be visible in the pivot,
but in the dropdown a+b is visible. Even if a+b isnt visible in the
datarange.
I have created an excel report, that retrieves its data from a view. From
that data i have created several sheets with different pivottables. The view
is based per country, so each country has to connect to their own view. So I
use the same file and change the datasource. It looks fine when i have
updated. BUT when I use the dropdown on a field, the old values from the
last data are still visible, however they dont show anything if you choose
them. For example France has sales men a +b and Sweden c+d. when switching
datasource from france to sweden, only c+d should be visible in the pivot,
but in the dropdown a+b is visible. Even if a+b isnt visible in the
datarange.