Printing Pivot Tables in Excel for mac

Highlighted
New Contributor

I recently switched from Office 365 for Windows to Office 365 for Mac. In Excel for windows there was an option in Pivot Table field settings to insert a page break after each item. It would print each item and subtotal for that item on a separate page. In excel for mac that option is not present. In fact, there is no layout / print settings tab in the field settings pane.

 

How can I automatically insert a page break after each item without having to go through the entire table and manually insert a page break?

1 Reply
Highlighted

I contacted MS and that feature is not available on the Mac version of Office. Yet another area where it seems parity between the platforms could be easily advanced.

 

I was able to figure out a VBA workaround so that I don't have to go through the entire table and manually enter page breaks.

 

C'mon MS, if you are going to offer a Mac version of office, don't treat it like a redheaded step-child.