Page 1 of 1

Pivot Table

Posted: Tue Jul 21, 2009 11:15 am
by quickvfr
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?

=> RE: Pivot Table

Posted: Tue Jul 21, 2009 2:54 pm
by kfleming
We use OLE automation to create pivot tables.__It is possible that the additional security that Microsoft added in Office 2003 is the source of the problem.__We have not made any specific changes in R&R to support Office 2003 although we do have an update in the works to support XLS export to 2003.______Kathleen__R&R Support