Pivot Table Print Areas

Hi
I have a huge pivot table approx 100 pages long, with slicers across the top,
when the slicers are selected the print area remains at 100 pages, rather than the cut down selection.

Is there an option i'm missing, that isnt changing the print area to the smaller range?

any ideas!!?

Adi

I did figure out the solution and in the end it was a simple one,
on the page set up menu, where you have the choice of "adjust to" and "Fit To", select one page wide, and leave the tall section blank.

Very simple solution, that has been bugging me for a while!