Problem when switching datasource

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.



0
anl (2)
8/26/2003 12:37:56 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
392 Views

Similar Articles

[PageSpeed] 46

Reply:

Similar Artilces: