pivot table data export to Excel

[bhavvibudagam]

Hi,

While exporting pivot table data to the Excel is it possible to display the Table title on Excel also along with that i need to display note describing calculations been given.

Is their any option please help me to do

Thanks

[bindu_apte]

Hi,

Hope this thread will help.

Export to excel with chart header.

[sujeetsingh]

Go to General tab on the object (table, pivot table, etc.) settings and press "Print Settings" button. Under tab Header/Footer you can specify what you want to print.

Here you can also specify standard variables, for example &[Title] in "Center Section" to print table title as header of the page.

Try pressing "Default" button on this window and you will see what I am talking about. Hope this is what you are looking for.