Export to excel in pivot table .

[#1]

i have a pivot table whenever i am exporting it to excel it is going in form of straight table.

please suggest a way through which it will go as a pivot table Only.

[sujeetsingh]

I dont think that pivoting will be exported in excel.

[amit_saini]

Navneet,

For sure pivot export will give you straight. Might be macro can help you in this case.

Thanks,

AS

[amit_saini]

Check if this helps:

Export pivot table in excel through macros

Thanks,
AS