I have a requirement in which I want to send the pivot to excel without opening it.

[ferha_jafri]

Hello Experts,

I have a requirement in which I want to change the pivot icon and want to restrict it to open. 

I want users to have only one option to send to excel.Also wanted to change the by default minimize pivot icon.

Thanks in advance

PFA with the sample in which I want to change the icon and do not want to open it ,just want to send it to excel.

[ferha_jafri]

Hello ,

I want to know that whether it is possible or not without macros..

[Brett_Bleess]

If I am following you correctly, the only decent way I see to accomplish things is to make that pivot table a hidden object and use a button object to do the export to Excel...

Regards,
Brett