Discussion on:

How to repeat pivot table headings when printing Excel documents

Cool. I tried it. It works. Thanks!

Susan: I am not sure if this is under the general rubric of headings, but I have provided source material for a staff member who produces reports that have columns at the top of the Pivot table reports, and he is working with one set of data ( fairly large set), and under one "pivot" he has 5 across the top, but he changes the selection and the display drops from 5 to 3 columns. I seem to recall that there is a solution within a pivot table that will use the data that is there in the data, but does not display, however, I have been searching for a solution, as well as trying to find the exact article I recall, but a trainer here wants to plug the back end into an access data source, which seems to be overdoing it. However, I am stuck in that the data to display is not something I can bring out into public forums, anyway, I don't know what sort of info you would need in this case, since the pivot table would be more consistent with 5 columns, since the rest of the data displays that way. I have been searching Bill jelen's books on the Pivot tables but I can't seem to find exact info.
Apologies if this sounds waffly, thats what pivot tables feel like sometimes
Anyway, I had helped the staff member get so far and not farther; feels like a shakespearean quandry, to go back takes the same effort as to go forward ...

If you have multiple pivots on the same page you actually have to use the Print Titles option Suzan sugests to be removed.