I want to send a pivot table to excel how can i send it to excel. Thanks in advance please.
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.
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.
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.
Retrieving data ...