Pivot table content not working for SensitivityLabel in generated excel file

Aspose.Cells Product Family
, ,
1

I have generated excel using ASPOSE using C#. The generated file opening with warning Can’t edit PivotTable on protected sheet. Once I change the Sensitivity Label to Public or Internal, then it’s fine. So, how I can set the sensitivity label with Public or Internal while generating the excel document. So that the file should not display any warning and also pivot table also work fine.

Thanks in advance for any answer.
Regards,
Santu

2

@santu.nandi
Could you post two files (warning and correct ) with Sensitivity Label ? We will check it soon.

And we think you should call Workbook.Worksheets.RefreshPivotTables() to calculate the data of pivot table and set PivotTable.RefreshDataOnOpeningFile as false, then Excel will not refresh the pivot report when loading it.

3

Is it possible to set the SensitivityLabel as Public or Internal for new or existing excel file using ASPOSE? By default no SensitivityLabel is selected.

4

@santu.nandi,

As requested earlier, could you please provide us with the following:

  1. A file that demonstrates a warning message.
  2. Another file that demonstrates the correct file after you have set the Sensitivity Label to public or internal.
  3. Some screenshots taken in MS Excel to evaluate the issue precisely.

Note: Please zip the files before attaching them here.