Export To Excel - Pivot Chart - Macro

[sathishkumar_go]

Hi All,

I have written a macro for exporting to excel (Pivot chart) and its working fine.

Just want to know, How to remove grouping while exporting to excel in macro?

-Sathish

[sinanozdemir]

Maybe like the below:

group = ActiveDocument.GetGroups

group(0).RemoveField 2 -> replace 2 with the field that you want to remove from the pivot table.

Hope this helps.

[sathishkumar_go]

Hi Sinan,

Thanks for your reply. Let me explain you my requirement clearly.

I have the pivot chart through macro I am exporting to excel the datas of pivot chart.

Example: After exporting the data into excel

ProductName	Producttype	Value
A	Type1	50
	Type2	100

I don't want merged cells. what I am expecting,   

ProductName	Producttype	Value
A	Type1	50
A	Type2	100

[sinanozdemir]

Hey Sathish,

I don't get that merged cell problem when I export a pivot table via a macro or the export button on the pivot table. Would you post your macro by any chance?