Pivot Table page breaks

%3CLINGO-SUB%20id%3D%22lingo-sub-1574876%22%20slang%3D%22en-US%22%3EPivot%20Table%20page%20breaks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574876%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20developed%20a%20rather%20straightforward%20pivot%20table.%26nbsp%3B%20Only%20slightly%20unusual%20thing%20is%20that%20I%20need%20a%20page%20break%20after%20every%20group.%26nbsp%3B%20I%20set%20it%20up%20by%20right%20clicking%20on%20the%20two%20leftmost%20fields%20of%20my%20output%2C%20selecting%20%22field%20settings%22%20clicking%20on%20the%20%22layout%20%26amp%3B%20Print%22%20tab%2C%26nbsp%3B%20and%20checking%20the%20%22insert%20page%20break%20after%20each%20item%22%20check%20box.%26nbsp%3B%20This%20worked%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHe%20problem%20occurs%20when%20i%20brought%20additional%20rows%20of%20data%20into%20my%20source%20worksheet.%26nbsp%3B%20It%20stops%20breaking%20pages%20at%20the%20same%20point%20in%20that%20the%20previous%20data%20ended%2C%20putting%20the%20data%20that%20now%20appears%20after%20that%20into%20one%20page.%20I've%20tried%20turning%20the%20page%20break%20off%20and%20back%20on%2C%20clearing%20and%20setting%20the%20print%20area%2C%20etc.%20to%20no%20avail.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20to%20%22remember%22%20how%20long%20the%20original%20worksheet%20was%20and%20stop%20breaking%20pages%20at%20that%20point.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EANy%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1574876%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I have developed a rather straightforward pivot table.  Only slightly unusual thing is that I need a page break after every group.  I set it up by right clicking on the two leftmost fields of my output, selecting "field settings" clicking on the "layout & Print" tab,  and checking the "insert page break after each item" check box.  This worked fine.

 

THe problem occurs when i brought additional rows of data into my source worksheet.  It stops breaking pages at the same point in that the previous data ended, putting the data that now appears after that into one page. I've tried turning the page break off and back on, clearing and setting the print area, etc. to no avail.

 

It seems to "remember" how long the original worksheet was and stop breaking pages at that point.  

 

ANy ideas?

0 Replies