Field buttons of pivot charts are set to "Hide All" after saving

Field buttons of pivot charts are set to "Hide All" after saving

Posted by: yyoshimura on 16 January 2026, 2:42 am EST

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 16 January 2026, 2:42 am EST

  Hi,

  We have a workbook with pivot charts in it with all field buttons showing, but after saving using the library, the field buttons of pivot charts are set to “Hide All” under [Analyze] → [Field Buttons] ribbon. Please see attachement for reproduction. The pivot charts are in in [Graph] sheet of file [Test.xlsx].

  This issue comes after the following fix. The workbook was corrupted before the fix and the new issue happens after the fix.
  
  https://developer.mescius.com/forums/documents-excel/workbook-is-corrupted-after-saving

  Please help to resolve this issue. Thank you.

  Regards

  GcExcelTest.zip

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 16 January 2026, 3:40 am EST

  Hi Yukinori,

  Apologies for the inconvenience caused.

  We can replicate the behavior you described on our end across DsExcel v7.2.1 and the latest version. We are discussing the matter with the concerned team and will update you as soon as we get any information from their end.

  Internal Tracking ID: DOCXLS-13775

  Kind Regards,
  
  Chirag

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 18 January 2026, 11:51 pm EST - Updated 18 January 2026, 11:54 pm EST

  Hi Yukinori,

  The issue has been identified as a bug, and the fix will be included in DsExcel v9.0.1. The expected release date for this version is 23 January 2026.

  In the meantime, you can use the following workaround to manually set the pivot chart field button options:

  foreach (var worksheet in workbook.Worksheets)
  {
      foreach (var shape in worksheet.Shapes)
      {
          if (shape.HasChart && (shape.Chart is IChart chart && chart.PivotTable != null))
          {
              chart.PivotOptions.ShowReportFilterFieldButtons = true;
              chart.PivotOptions.ShowValueFieldButtons = true;
              chart.PivotOptions.ShowLegendFieldButtons = true;
              chart.PivotOptions.ShowAxisFieldButtons = true;
              chart.PivotOptions.ShowAllFieldButtons = true;
              chart.PivotOptions.ShowExpandCollapseEntireFieldButtons = true;
          }
      }
  }

  We appreciate your patience in the meantime.

  Kind regards,
  
  Chirag

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 20 January 2026, 9:02 pm EST

  Thank you for the clarification. Looking forward to the new release.