Export Access Pivot Table to Excel and retain Pivot Table Formatting
We currently have data in Access which we are displaying in a Pivot Table form because we have monthly data for a group of accounts.
We have it setup in Access and would like to be able to export the Pivot Table including its format to Excel for further analysis.
Thoughts?
We have it setup in Access and would like to be able to export the Pivot Table including its format to Excel for further analysis.
Thoughts?
I recommend users to export the table/query from Access and create the Pivot Table in Excel
To make it a consistent process, export to a name file (for example, AccessOut.xlsx). In a DIFFERENT workbook, create the Pivot Table against that exported file. On the next export, replace the last one (AccessOut.xlsx). When you reopen the Pivot Table it will refresh with the new data or you can use the Refresh Data option in Excel pivot tables.
Is there something in the access pivot tables that you find hard to duplicate in Excel?
To make it a consistent process, export to a name file (for example, AccessOut.xlsx). In a DIFFERENT workbook, create the Pivot Table against that exported file. On the next export, replace the last one (AccessOut.xlsx). When you reopen the Pivot Table it will refresh with the new data or you can use the Refresh Data option in Excel pivot tables.
Is there something in the access pivot tables that you find hard to duplicate in Excel?
ASKER
I was also considering building a crosstab query and build a report from that.
We are using Access 2010
We are using Access 2010
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Before I offer a solution, please confirm the version of Access that your using.