Exporting Pivot Table as it is.

[#1]

Hi,

Can anyone help me in exporting a Pivot Table as it is. I mean, with the cells merged for each dimension values.

Thanks.

Br,

Prasanna.

[zturaiki]

- right click on the table

- click on copy to clipboard

- click on Full table

Try it , sure it will help you ...

[#3]

Yeah...that helps...but is there a more elegant way were the users can just hit a button and export the table with the pivoting?

[vikasgupta]

Hi

Try this macro using one button you will get in excel same format :

Sub SendReport

ActiveDocument.Sheets("SH01").Activate

'ActiveDocument.reload

set objExcel=ActiveDocument.GetSheetObject("CH01")

strDate = Year(Date()) &"-"& month(date()) &"-"& Day(Date()) 

filepath="D:\Excel_"&strDate&".xls"

objExcel.ExportBiff filepath

ActiveDocument.GetApplication.Sleep 5000

Thanks

Vikas

[vikasgupta]

Hi

find the attached sample for same !!!!

Thanks

Vikas

[#6]

Hi,

This not wat actually I am looking at.

Wat I wanted was the Cells in the Exported Excel to be grouped to gether as it is in the Pivot Table in Qlikview Client or Accesspoint.

But thx for trying to help...

Br,

Prasanna