I'm referring to a huge pivot table and double clicking each number to expand
into the data behind it. It creates a new page each time and I have to set
the print layout for each page.
Is there any way of setting a default print layout for a workbook, or even
Excel as a whole, which will apply to each new page as it is added?

--
Thanks,
Dave