Stop new possible values being auto added to Pivot Table Filters

[Wolfsbane2k]

HI.

I'm currently running a number of pivot tables that are used to extract data for the generation of graphs showing daily progress.

To do this, i have a report filter that is used to limit the scope of the pivot table.

However, i'm finding that i have to re-apply the filter whenever a new possible value is added, meaning for my 40+ pivot tables i have to manually intervene each day, which is very annoying!

How can i stop new values automatically contributing to the table, (This is assuming PT covers a larger range than just the data to allow expansion)

Example:
First Data point:

Raw Data:                   PT:
                                 Report Filter: L  Multiselect, A, C
 N,L, Country,               Count Number of Instance:
1, A, France                 France: 2
2, A, France                 England: 1
3, B, France                 Grand Total: 3
4, B, Germany 
5, C, England

Add a new data point 6 , don't change the PT;

Raw Data:                   PT:
                                 Report Filter: L  Multiselect, A, C [D] <- WHY! I didn't select this!
 N,L, Country,               Count Number of Instance:
1, A, France                 France: 3
2, A, France                 England: 1
3, B, France                 Grand Total: 4
4, B, Germany 
5, C, England
6, D, France

Since D wasn't explicitly included in the original multi select, it shouldn't now be added to the France Total, but it is :grr:
I know i can VBA it, but is there an easier way rather than write more code to refresh each PT seperately each and every day?

Ta