Can I turn off export to excel option

[Greg]

I noticed the Export to Excel option copies your data connection information
into excel in addition to the actual pivot data.
Is there a way to designate data only or if nothing else ..turn the button
off?

 

[Antoine Prevot]

Hi Greg,

Didn't hear of a "data only" version of the excel export, but here's the
code to hide the excel button (VB style) :

___________________________________________________________________
Dim btnTemp As Object 'dunno the type, it's a button :-/
Set btnTemp = PT.toolbar.Buttons("owc1004") 'look for the excel export button.

If Not (btnTemp Is Nothing) Then
btnTemp.Visible = False
btnTemp.Enabled = False
End If
___________________________________________________________________

Hope this helps,