Automatic pivot table print area

I produce a daily summary of my company’s products using an Excel pivot table. It no longer scales the number of pages based on the individual products when I select them. I have to manually adjust pages for the end of the document. The footer contains “Page X of Y Pages”. How do I reset it so that it automatically knows where the last page occurs? My page scaling is set to 100%; 1 wide by [blank] long does not correct the problem. Thanks for any help.