excel vba - Repeat Labels in Pivot Tables (VBA) -


currently, working on code iterates through 3 sheets of data identical in formatting , creates 3 pivot tables (one each sheet) has identical format. want toggle repeat labels format on within vba code, cannot seem it. following link 1 found have tried, no success: http://excelpivots.com/pivot/repeat_item_labels/

i paste code, rather long. gist of tried putting:

for each pfield in ptable      if pfield.orientation = xlrowfield pfield.repeatlabels = true  next pfield 

within loop creates 3 pivot tables. however, throws error 438.

i did further research , found (https://msdn.microsoft.com/en-us/library/office/ff198076.aspx), not sure how use it.


Comments

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -