Printing pages from Pivot Tables automatically
 

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!

Printing pages from Pivot Tables automatically
 

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



saltnsnails wrote:

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

Printing pages from Pivot Tables automatically
 

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!
--
-CRM


"saltnsnails" wrote:

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!

Printing pages from Pivot Tables automatically
 

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 wrote:

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!
--
-CRM

"saltnsnails" wrote:

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

Printing pages from Pivot Tables automatically
 

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

--
-CRM


"Dave Peterson" wrote:

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 wrote:

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!
--
-CRM

"saltnsnails" wrote:

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