Unanswered: Access Pivot Table - only want to export filtered records
I created a pivot table in Access 2007 and there is a button under the Design tab to automatically export your pivot table to Excel. However, in addition to the pivot table, it's exporting all the raw data from the main table. My main table contains over 1 million records. I'd just like the pivot table and the filtered data to export to Excel. Is there a way to do this? Thanks!