Pivot Table
Posted: Tue Jul 21, 2009 11:15 am
I have a report that I am trying to export to an Excel Pivot Table. I have Office 2003 Pro installed and the ODBC, Excel 5.0/95 set up but get: "Run-time error ^1004^: Unable to get the PivotFields property of the PivotTableClass" from the "Report Export PivotTable OLE Automation Driver" box once the report has been queued up. I have looked online for answers but seem to be directed at very specific, macro arguements. Any suggestions?