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