Hide pivot table field list

Aspose.Cells Product Family
1

Hi,

I have a pivot table in excel sheet. When I click on the pivot table, the filed list shows up.

Is there any way I can hide field list.

2

Hi,


What do you mean, when you will click on the pivot table in MS Excel, it will show up the field list by default, this is the behavior of MS Excel. Could you elaborate your need and if possible give us your template file with screen shots to show your needs and how could you do it in MS Excel. We will check it soon.


Thank you.
3

The field list is selected by default.

Please find the attached screenshot.

4

Hi,


Please give us your sample Excel files (your desired file (having pivot table) and general file (having pivot table)), we will check it soon.

thank you.
5

Amjad,

Thanks for the quick reply.

I am attaching four files.

myFile is what I am getting using Aspose. When I open myFile and click on the pivot table the field List opens up on right hand side. This would allow the user to change the pivot table.

I dont want the field list to open up.

6

Hi,


thanks for sharing the files.
We understand your requirement now. For your requirement, please use PivotTable.EnableFieldList Boolean property to set to “false”.

e.g
var pivot = workbook.Worksheets[0].PivotTables[0];
pivot.EnableFieldList = false;

Thank you.