Printing pages from Pivot Tables automatically

[saltnsnails]

I have created a Pivot table tracking expenses and quanities of items that
each dept in our company has purchased for a given month. I want a new sheet
to print for each dept. I know how to filter by dragging the dept number
into the page area of the Pivot Table but I have to select each dept
individually and print. Isnt there a way I can have excel automatically
choose each individual dept and print their expenses on separate sheets?
Thanks!

 

[Dave Peterson]

Maybe the macro at Debra Dalgleish's site will help:
http://contextures.com/xlPivot09.html

 

[saltnsnails]

Dave,
Thanks for the reply. I took an excel class a year ago where the instructor
showed how to do this via processes already in excel. Does anyone have a
clue on this? Thanks!

 

[Dave Peterson]

Maybe you saw the instructor rightclick on the pagefield and use "show pages"

But this wouldn't print anything.

I'm not sure when "show pages" disappeared from the rightclick menu (xl2k???),
but if you don't see this option, you can select any cell in the pivottable
(just to see the pivottable toolbar), then click on the Pivot table dropdown and
choose "show pages".

If you're using xl2007, Debra Dalgleish shared this:

Select a cell in the pivot table
On the Ribbon, click the Options tab
At the far left, click the dropdown arrow for Options
Click Show Report Filter Pages

 

[saltnsnails]

AWESOME! That is exactly what I needed. After I do show pages, I can just
print entire workbook. Thanks Dave!