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
Post a Comment