Exporting Access Pivot tables to Excel

[michelle copper]

Thanks ADezii! I hope you come up with a solution soon for exporting pivot view as well.

[NeoPa]

Hijack question moved to its own thread - How to Export into Multiple Worksheets in Same Workbook.

[ADezii]

As I see it, Michele, the easiest solution by far would be to:

1. Allow All Menus in the StartUp Properties.
2. Open frmExportMetric s in Pivot Table View.
3. Click on the Pivot Table Menu Option, then Export to Microsoft Excel (last option on Menu.
4. Make any adjustments in Excel.
5. Save the Worksheet.

[michelle copper]

Alright. I'll try that instead.

Thank you so much for all responses.