Hi MrExcel,
I am having problems with the auto-page breaks on a classic pivot table (see attached picture).
When items from the inner field (Dimension 2) overlap a page such that only one item is showing on the second page, then the auto-page-break does not work, resulting in the next item from the outer field (Dimension 1) appearing on the same page.
Weirdly, if the items from the inner field overlap the page so that 2 or more items are shown on the next page, then the page break works fine again.
If you are not able to repeat the phenomenon, based on the picture and description attached, please download this xlsx file, which shows the example...>
https://drive.google.com/open?id=0B6TjI57TetI5SDh0UUNqcWdqb2s
Hope this makes sense
I am having problems with the auto-page breaks on a classic pivot table (see attached picture).
When items from the inner field (Dimension 2) overlap a page such that only one item is showing on the second page, then the auto-page-break does not work, resulting in the next item from the outer field (Dimension 1) appearing on the same page.
Weirdly, if the items from the inner field overlap the page so that 2 or more items are shown on the next page, then the page break works fine again.
If you are not able to repeat the phenomenon, based on the picture and description attached, please download this xlsx file, which shows the example...>
https://drive.google.com/open?id=0B6TjI57TetI5SDh0UUNqcWdqb2s
Hope this makes sense