VBA to select filter from pivot tables

[michelle 1]

Dear Excel Forum

I have been using the below code to change the filter on my pivot tables based on the value in another cell and all works fine. However i set up my pivots slightly different in my current file, as i need to see unique values only i have created the pivot table and selected "Add this data to the data model". Using the same code below does not seem to be working on this pivot and i wondered if someone would be able to offer some help.

Please Login or Register  to view this content.

[Eastw00d]

Hi, without seeing the actual worksheet that you use, it is very difficult to determine where the error originates.
My first guess would be that the number of the pivottable has changed.

In order to help, please post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information.

Cheers
Erwin

[michelle 1]

Hi Eastw00d

I have attached the file.

[Eastw00d]

I have rebuild the pivottable as the one present in the workbook didn't work.
Then of course you'll get another Pivottable-name, so effectively that's the only thing that I have changed in the macro and the Worksheet_Calculate sub did the rest.

Cheers
Erwin