Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
I want to export some dimensions without expression? when i clone my chart and disable the expressions i loose all data!
I think i have just to use a table box which contain my dimension and hide it 🙂