Excel Export Pivot Table with formatting( unmerged fields)

[#1]

Whenever I export a pivot table to excel - It exports the excel with cells - unmerged . I want to export it with the exact formatting . Any solutions or workarounds ?

[#2]

Natively I don't think so sorry, the closest you will get is the print option on a chart when using the Ajax client which opens you a html page with the formatting retained.

Third party options such as Nprinting might allow you to do this though, so maybe have a look at that

hope that helps

Joe

[sandeepprasad_j]

Hello Litan,

Write a macro like below

set obj = ActiveDocument.GetSheetObject("CH15")

obj.ExportEx "C:\Documents\test.xls"

or

Try to Click on the Pivot Table in the Qvw Application CTRL+A,CTRL+C and then open the new excel worksheet and CTRL+V ,you will get the desired output

Hope it helps

Sandeep.

[#4]

Hi.

I'm having the same issue. did you find a solution?

thanks

[marcus_sommer]

You could choose copy into clipboard from context-menu and then the complete table.

- Marcus

[MEJ]

If I use the copy to clipboard, it works with the merged dimensions, but NOT the number formats (thousands). So by sending to Excel it works well in one way (number formats), but not the merged dimensions.