Pivot Table Page Breaks

[APElliott]

Hello,

Got a problem with page breaks on pivot tables.

I've set 1 of the data fields to insert a break where the data changes.

The trouble comes when I run a macro that changes what is shown in the field.

Some how it is remembering where some of the original page breaks were.

The only way I can think to overcome this problem is to write a code that fits the print area to 1 page and then have a code that inserts page breaks in the 'Page' data field where a cell contains the word Total.

Can anyone help me with this code?

Thanks

Andrew

 

[SkipVought]

Andrew,

You state, "The trouble comes when I run a macro that changes what is shown in the field."

What WAS and IS displayed in that field. Please explain what is happening more completely.


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com