I have a pivot table of about a million rows. In consequence, it is a huge table with a big scroll down because all the rows are listed. I would like to have like 100 rows printed in the table using a small scroll and then next/previous buttons to load the next/previous 100 rows. Is there any way to do that? I think in a straight table you can do that in the presentation tab cheking the "max shown number" checkbox, but this option is not available in the pivot table properties.
