Pivot table changing from tabular view to compact view automatically

[Dmpsampath]

I have coded a pivot table from “data” sheet to “pivot” sheet to view in tabular view. But when I assigned a button to my macro my pivot table Changing tabular view to compact view automatically. Could you please help me?

[Paul_Hossler]

It would be helpful if we didn't have to guess at your macro.

Use the [#] icon and paste a copy between the CODE and /CODE tags

Better yet is to attach a copy of the workbook