diff --git a/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/Excel/XLWorkbook_Load.cs index 85b6eec..d4182b0 100644 --- a/ClosedXML/Excel/XLWorkbook_Load.cs +++ b/ClosedXML/Excel/XLWorkbook_Load.cs @@ -797,9 +797,13 @@ pivotField.AddSubtotal(XLSubtotalFunction.Sum); if (pf.ApplyVarianceInSubtotal != null) pivotField.AddSubtotal(XLSubtotalFunction.Variance); - var items = pf.Items.OfType().Where(i => i.Index != null && i.Index.HasValue); - if (!items.Any(i => i.HideDetails == null || BooleanValue.ToBoolean(i.HideDetails))) - pivotField.SetCollapsed(); + + if (pf.Items?.Any() ?? false) + { + var items = pf.Items.OfType().Where(i => i.Index != null && i.Index.HasValue); + if (!items.Any(i => i.HideDetails == null || BooleanValue.ToBoolean(i.HideDetails))) + pivotField.SetCollapsed(); + } } private void LoadDrawings(WorksheetPart wsPart, IXLWorksheet ws)