diff --git a/ClosedXML/Excel/PivotTables/XLPivotTables.cs b/ClosedXML/Excel/PivotTables/XLPivotTables.cs index 5df7957..69a665a 100644 --- a/ClosedXML/Excel/PivotTables/XLPivotTables.cs +++ b/ClosedXML/Excel/PivotTables/XLPivotTables.cs @@ -32,11 +32,7 @@ public IXLPivotTable Add(string name, IXLCell targetCell, IXLTable table) { - var dataRange = table.DataRange; - var header = table.HeadersRow(); - var range = table.Worksheet.Range(header.FirstCell(), dataRange.LastCell()); - - return Add(name, targetCell, range); + return Add(name, targetCell, table.AsRange()); } public IXLPivotTable AddNew(string name, IXLCell targetCell, IXLRange range)