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 ?
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
Write a macro like below
set obj = ActiveDocument.GetSheetObject("CH15")
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
I'm having the same issue. did you find a solution?
You could choose copy into clipboard from context-menu and then the complete table.
Retrieving data ...