Getting Pivot Fields Error Message on Excel Generation

[Former Member]

Hi All,

I have a report which displays the report output in the form of a Pivot Excel file. When the excel opens up, the macros are disabled & the data is not displayed. When i enable the macros, then an error message pops-up which says "Unable to get the PivotFields property of the Pivot Table Class". I don't know what this message means.After clicking on this "Ok" twice the data is displayed correctly.How can i remove this error message? Is it a problem with the code or the template? Please help me in this regard.

Thanks,

Arpita.

[JanarthananE]

Hi,

Refer the following code for better understanding of your requirements..

http://www.saptechies.com/how-to-create-pivot-table-in-excel-using-desktop-office-integration/

hope its useful to u.,

Regards,

Jana