Michael1974
New member
- Joined
- Mar 31, 2015
- Messages
- 49
- Reaction score
- 0
- Points
- 0
Hello,
I have this attached pivot table where the Data Source content is quite large. More data the pivot table pulled out, more difficult it is to print the pivot table on the same page.
The question is how to set up the print out area to get automatically updated with the amount of data that the Pivot Table pulled out.
In order word I want the print out area to be flexible. I want a way to set up the print out area only once, to be automatically flexible. All the data must be printed on the sheet.
Thanks in advance for your help!
I have this attached pivot table where the Data Source content is quite large. More data the pivot table pulled out, more difficult it is to print the pivot table on the same page.
The question is how to set up the print out area to get automatically updated with the amount of data that the Pivot Table pulled out.
In order word I want the print out area to be flexible. I want a way to set up the print out area only once, to be automatically flexible. All the data must be printed on the sheet.
Thanks in advance for your help!