Pivot Table

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
quickvfr
Posts: 21
Joined: Tue Oct 10, 2017 12:44 pm

Pivot Table

Post by quickvfr » 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?
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Pivot Table

Post by kfleming » Tue Jul 21, 2009 2:54 pm

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
Top
Post Reply

Return to “R&R ReportWorks Users”