Dependent Pivot Tables

Hi,

I'm new to this forum, so am hoping someone can help.

I have a problem which really has me stumped. I have a worksheet containing several pivot tables. I would like all the pivots to automatically update the items within the colum fields (columnfields.Pivotitems) when I update the one "masterpivot".

In other words if the column header is animals, and I only want to see dogs, and cats, that should automatically update all pivots with those choices.

Using VBA Code I have come up with a "sort-of" solution, but I am not happy with it. One problem is that in order to reset each pivot before re-populating the column items I tried to set pivotitems.visible = false. This doesn't work as you have to always have at least one item selected.

I hope I am making sense.

Here is my code (I know it's a mess, I'm ust a beginner)

Thanks in advance

Please Login or Register  to view this content.