Is it possible to not have any orphaned rows when printing a Pivot Table report? Currently I use page break preview and manually adjust the page breaks so as not to have an orphaned row on the next page with its sub header and related rows on the previous page.
This is ok if the report is relatively short but I can't see doing this for several page reports. I don't know VBA.
Thanks,
Lee
This is ok if the report is relatively short but I can't see doing this for several page reports. I don't know VBA.
Thanks,
Lee