I want to export the pivot table from Access to excel. I know the option of exporting with data. But i want to export only the pivot table without the source data. Can you please tell me if there is any option available in Access.
In Version AC2002, with your Pivot Table open in Access, Right Click on the top of the Pivot Table Window and there will be an option to export to MS Excel. Also, in the menu bar, there is a Pivot Table Option that allows you to export to Excel.
I know that option but in that option it will export with data. I want only pivot table need to be exported without the source data.
I dont need source data , i need only pivot table with values.
Ok. I just did a control +A and then Control +C with the PT open. I then opened an Excel Spreadsheet and did a Control +V and only the PT came into the Spreadsheet. Manual, but it works.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
