This content has been marked as final. Show 2 replies
There is only so much information you can fit into a page. If your table is too big to print onto one page (whether it's due to the width or height), then you're going to have to make some compromise.
I believe your options are:
- Allow it to print onto multiple pages (or any many pages as is needed)
- Use Fill / Fill with aspect to squeeze the table onto one page, but you might not be able to read the text, unless you print it on an A3 paper
- Reduce the number of columns (to reduce the width) and let the height be dynamic
- Split the PivotTable into many smaller tables to make it more manageable for printing