When i record a pivot table in order to generate a macro i have this problem, whenever i change the data source the pivot table it reduces the range from which the pivot table its created by a few columns short, and when i tried to filter some items from a field it makes a code like this:
.PivotFields("VendoLoc").PivotItems("x1").Visible = False
.PivotFields("VendoLoc").PivotItems("x3").Visible = False
.PivotFields("VendoLoc").PivotItems("x5").Visible = False
When i really want to see only the X2 and X4 values in the pivot table, so when i change the data the items i still wanna see the X2 & X4 values but now i also got new X6 values and so on to filter, i don't know how to use this code that excel creates in order to filter only the values i wanna see,not the one i dont wan't want to see.
Ideas to solve this 2 issues?
Thanks in advanced.
Bookmarks