Solved: Page break after each new customer

[Djblois]

Why won't this work?

With pt.PivotFields("Customer")
.LayoutPageBreak = True
End With

I declared pt as pivottable and Customer is the correct field

[Djblois]

Does anyone know where my error is? I am trying to get the pivottable to insert a page break after each new item in the customer column field.

P.S. I hope everyone had a good holiday!!!

[m.azrie]

Hello djblois,
May be Your Scalling (in Page Setup) is selection on "Fit to:".. if you want to use page break, you should select on "Adjust To:"..

I hope its work..

[Djblois]

Mohd,

Thanks for the Input. Can you give me an example in code because I don't understand what you are saying

[m.azrie]

Actually, i'm not sure it's correct or not.. but from my experience, Excel page brake wont work when we set the page in fit to pages.


http://www.orbitfiles.com/download/id1124034813