Printing Pivot Tables in Excel for mac

[fhchap]

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?

[#2]

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.