As i understand you want to export the pivot table into excel if so.Yes you are able to export the data of pivot table as excel and yes what ever you created you export it into excel. Please clear your requirements also if i am not clear.
By right click on pivot table and send it to excel.
What I am after is the ability to transfer the expansions as well. At
the moment it if you export it exports what you see and does not give
you the ability once exported to expand and other data. You then have to
create the pivot again in Excel which is time consuming.
CRM, Systems & Process Manager
T +44 1508 482691 Ext 4045
F +44 1508 482710
M +44 7786 331195
Enterprise House Harveys Lane Seething
Norfolk NR15 1EN United Kingdom
UK | Australia | Middle East | Singapore | Nigeria | Brazil
As i understand when you want to export the data just right click on the pivot table and click on Expand All and send it to excel. By this you export that data which is in collapse mode. Or i suggest make different pivot table if it is not necesary to put it together.
Hope this helps you.