diff --git a/ClosedXML/Excel/Ranges/XLRangeBase.cs b/ClosedXML/Excel/Ranges/XLRangeBase.cs index 3200de5..b05cf55 100644 --- a/ClosedXML/Excel/Ranges/XLRangeBase.cs +++ b/ClosedXML/Excel/Ranges/XLRangeBase.cs @@ -1667,7 +1667,7 @@ public XLPivotTable CreatePivotTable(IXLCell targetCell, String name) { - return (XLPivotTable)Worksheet.PivotTables.Add(name, targetCell, AsRange()); + return (XLPivotTable)targetCell.Worksheet.PivotTables.Add(name, targetCell, AsRange()); } public IXLAutoFilter SetAutoFilter()