topic Re: Getting Pivot Fields Error Message on Excel Generation in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/getting-pivot-fields-error-message-on-excel-generation/m-p/8731889#M1673734 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Refer the following code for better understanding of your requirements..</P><P></P><P></P><P><A href="http://www.saptechies.com/how-to-create-pivot-table-in-excel-using-desktop-office-integration/">http://www.saptechies.com/how-to-create-pivot-table-in-excel-using-desktop-office-integration/</A></P><P></P><P>hope its useful to u.,</P><P></P><P>Regards,</P><P>Jana</P></BODY></HTML> Mon, 23 Apr 2012 11:30:29 GMT JanarthananE 2012-04-23T11:30:29Z Getting Pivot Fields Error Message on Excel Generation https://community.sap.com/t5/application-development-and-automation-discussions/getting-pivot-fields-error-message-on-excel-generation/m-p/8731888#M1673733 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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 &amp; 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.</P><P></P><P>Thanks,</P><P>Arpita.</P></BODY></HTML> Mon, 23 Apr 2012 05:51:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/getting-pivot-fields-error-message-on-excel-generation/m-p/8731888#M1673733 Former Member 2012-04-23T05:51:39Z Re: Getting Pivot Fields Error Message on Excel Generation https://community.sap.com/t5/application-development-and-automation-discussions/getting-pivot-fields-error-message-on-excel-generation/m-p/8731889#M1673734 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Refer the following code for better understanding of your requirements..</P><P></P><P></P><P><A href="http://www.saptechies.com/how-to-create-pivot-table-in-excel-using-desktop-office-integration/">http://www.saptechies.com/how-to-create-pivot-table-in-excel-using-desktop-office-integration/</A></P><P></P><P>hope its useful to u.,</P><P></P><P>Regards,</P><P>Jana</P></BODY></HTML> Mon, 23 Apr 2012 11:30:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/getting-pivot-fields-error-message-on-excel-generation/m-p/8731889#M1673734 JanarthananE 2012-04-23T11:30:29Z