Pivot Table - Repeat Item Labels (Mac User)

[MJT83]

Hi All,

I want to repeat item labels on a pivot table. I have recently moved companies and they all use Mac's and so I have a 2021 365 subscription. When I go (like I would on non mac devices) to the pivot table options, there is no repeat item label to tick.

Does Mac's even have this functionality? If no, why not!

Cheers All.
Matt

 

[Jim Gordon]

Hi Matt,

I presume you're talking repeat row labels at the top of each sheet. That option does not display in the Excel for Mac interface, but it is in the object model.

You can toggle the setting with this line of code in VBA, but I did not test to see if it actually works.

ActiveSheet.PivotTables("PivotTable1").RepeatItemsOnEachPrintedPage = False

 

[Alex Blakenburg]

I don't have a Mac to test it on but shouldn't it be:-

ActiveSheet.PivotTables("PivotTable1").RepeatAllLabels (xlRepeatLabels)

 

[Alex Blakenburg]

Not having a Mac I can't test this but the post here indicatest you should be able to do it by
Excel For Mac Pivot Table Repeat Item Labels

• Selecting the field
• Field Settings > Layout & Print
• Select -> Show Items in Tabular form
• AND Select -> Repeat Item Labels

 

[Jim Gordon]

Alex, yes, that option is available. I'm just not sure which label instructions option MJT83 was referring to.

 

[jacobm00]

View attachment 55349

Alex, yes, that option is available. I'm just not sure which label instructions option MJT83 was referring toT

View attachment 55349

Alex, yes, that option is available. I'm just not sure which label instructions option MJT83 was referring to.

This was very helpful. Thank you for protecting Gotham, Commissioner.