I am using Excel 2003. I have a pivot table with COUNTRY in the page field. After I've selected (ALL) in the page field, I want to print the entire pivot table on 1 page wide by 25 pages tall. So I highlight the entire cell range, select file-print area-set print area. All is good.
But then I select a different value in the page field, say "GER", and the pivot table is only 2 pages tall. But if I decide to print, it will print all 25 pages, 23 blank ones (because of the set print area).
Is there a way to automatically print only the active table and not rely on having to set print area each time a different value in the page field is selected?
But then I select a different value in the page field, say "GER", and the pivot table is only 2 pages tall. But if I decide to print, it will print all 25 pages, 23 blank ones (because of the set print area).
Is there a way to automatically print only the active table and not rely on having to set print area each time a different value in the page field is selected?