Export to Excel in Pivot table with same Format

[deepakk]

HI All,

When we export the data from pivot table to excel , can we keep the same format (without writing a MAcro).

Please find the Excel doc for exact requirement.

[#2]

Hi Deepak,

Even i have the same requirement.

Did you get any solution?

or any alternative way of implementing it?

[#3]

Update if you got the solution. By my understanding it is not possible..

[#4]

Hi,

As a workaround:If you right click on the table and select Copy to Clipboard >> Full Table then the complete table with layout is copied.This can be pased into Excel to get the requested result.

Also you can try to enable the option Copy Data under the Caption menu of the pivot table. in QV11.2 SR3 this actually gives the copy to clipboard functionallity as icon.

Kind regards,

Matthijs

[ali_hijazi]

Right-Click on your pivot table and click Copy->Copy Full Table then open Excel and paste all data will be exported and formatted as in Excel