Pivot Table Page Break problem
I want to have a page break on each change of value for a Row field. I have
switched off Table Options/Report Autoformat, I have selected Table Options/Preserve Formatting. I select the relevant Field heading on table report, and from right click menu select Field Settings/Layout button and then select 'Insert page break after each item'. On the first few pages this is OK, but then I start to get two, three, four... items on each page. See example below, I want to break on change of Op.Desc eg P.Order W.Order Op Op.Desc Mat -- Patricia D |
All times are GMT +1. The time now is 01:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com