export to excel

[#1]

Hello,

How can i export some column of a pivot table to excel using a macro. I know how to export all object, but not some colomun.

Rgds.

[#2]

I sort of cheat here by having a seperate (hidden) pivot table just containing the columns the user wants to export and then create an 'Export' button that runs a macro to export the hidden object. I often make the button 100% transparent and then place it on the original pivot table title.

Regards,

Gordon

[#3]

I want to export some dimensions without expression? when i clone my chart and disable the expressions i loose all data!

[#4]

I think i have just to use a table box which contain my dimension and hide it 🙂