Changing specific pivot tables at once Excel 2010

have you tried attaching a slicer to just the tables you want filtered?

how are you doing it currently? assuming you are using code, why not post it-it can then most likely be altered to only affect specific pivot tables

The code I currently use to change all pivots in the selected sheet is this :

Please Login or Register  to view this content.

the code would be basically the same except rather than

Please Login or Register  to view this content.

you would need to test the pivot table name

Please Login or Register  to view this content.

what is your current code? you have presumably left in the End If line for the If... clause that was replaced by the Select Case

The code is :

Please Login or Register  to view this content.

If I remove the End If it then provides an error for the "Next" underneath.

Please Login or Register  to view this content.

oughta be

Please Login or Register  to view this content.

don't put your pivot tables so close together ;-)

you would only get the error if the pivot table tries to expand to overlap another pivot table. without your workbook I can't see why one code would cause that if the other did not

I believe that the issue lies in the data, I need it to change only a key field in all of the pivots, this being the date. When I change the current data it turns the pivot to all and that is why it overlaps. Is there a way to isolate the other fields from changing? apart from the date?

Moderator Note:

Pls use code tags around your code next time as per forum rules.

if you only want to change one page field there is no need to loop through all of them

Please Login or Register  to view this content.