Send to Excel

[#1]

Hi All,

I want to send a pivot table to excel how can i send it to excel. Thanks in advance please.

Thanks

[neha_shirsath]

Hi ritu,

In Chart properties > Caption Tab> Special Icons & thecn Mark on Send to Excel . When you see the Pivot table on right side you will get the XL option clik on that and you will get the Excel file.

[khadeer]

By right clicking pivot table u can get the option send to excel, else in caption tab u have to check send to excel option, what said by neha.

[#4]

Hi All,

Thanks but i need to send it by macro and data is of Pivot table or straight table. Table contains around 15 fields.

Let me know.

Thanks