ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automated Page Breaks In Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/124285-automated-page-breaks-pivot-table.html)

Teb

Automated Page Breaks In Pivot Table
 
In Microsoft Access Reports, you can ask the report not to break groups of a
field over a page. Can the same be done with Pivot Tabels in Excel? The only
option it gives me is to add a page break after each change in group name of
a field.

Debra Dalgleish

Automated Page Breaks In Pivot Table
 
Pivot tables don't have a similar option that you can use to keep items
in a group together.

Teb wrote:
In Microsoft Access Reports, you can ask the report not to break groups of a
field over a page. Can the same be done with Pivot Tabels in Excel? The only
option it gives me is to add a page break after each change in group name of
a field.



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



All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com