Hi! I am trying to edit multiple Pivot Tables in excel in several tabs in one workbook. The issue I have is, I have two pivots on each spreadsheet. I have named each pivot RMAPvt and CROMPvt. Each sheet contains one of each. I want to updated the RMAPvt's together and the CROMPvt's together. I found some code that will allow me to filter ALL of the pivot tables together, but I need to be able to exlude some. Does anyone know how to do that in Excel 2007? I see you can use Slice in the new version, but unfortunately I do not have that version.

I appreciate any help you can give.