There are no settings you can change to adjust the way that the Show
Pages command works.

wrote:
For a pivot report, with the pages setup to each year, how can I
customize show pages command to append additional new pivot reports to
the current worksheet instead of creating new ones?

Additionally is there anyway to lay out each report on a different
page when doing this? This would save me time from having to insert
page breaks.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html