diff --git a/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/Excel/XLWorkbook_Load.cs
index c06bfac..44d678a 100644
--- a/ClosedXML/Excel/XLWorkbook_Load.cs
+++ b/ClosedXML/Excel/XLWorkbook_Load.cs
@@ -582,6 +582,28 @@
 
                                             if (pivotField != null)
                                             {
+                                                if (pf.AverageSubTotal != null)
+                                                    pivotField.AddSubtotal(XLSubtotalFunction.Average);
+                                                if (pf.CountASubtotal != null) 
+                                                    pivotField.AddSubtotal(XLSubtotalFunction.Count);
+                                                if (pf.CountSubtotal != null)
+                                                    pivotField.AddSubtotal(XLSubtotalFunction.CountNumbers);
+                                                if (pf.MaxSubtotal != null)
+                                                    pivotField.AddSubtotal(XLSubtotalFunction.Maximum);
+                                                if (pf.MinSubtotal != null)
+                                                    pivotField.AddSubtotal(XLSubtotalFunction.Minimum);
+                                                if (pf.ApplyStandardDeviationPInSubtotal != null)
+                                                    pivotField.AddSubtotal(XLSubtotalFunction.PopulationStandardDeviation);
+                                                if (pf.ApplyVariancePInSubtotal != null)
+                                                    pivotField.AddSubtotal(XLSubtotalFunction.PopulationVariance);
+                                                if (pf.ApplyProductInSubtotal != null)
+                                                    pivotField.AddSubtotal(XLSubtotalFunction.Product);
+                                                if (pf.ApplyStandardDeviationInSubtotal != null)
+                                                    pivotField.AddSubtotal(XLSubtotalFunction.StandardDeviation);
+                                                if (pf.SumSubtotal != null)
+                                                    pivotField.AddSubtotal(XLSubtotalFunction.Sum);
+                                                if (pf.ApplyVarianceInSubtotal != null)
+                                                    pivotField.AddSubtotal(XLSubtotalFunction.Variance);
                                                 var items = pf.Items.OfType<Item>().Where(i => i.Index != null && i.Index.HasValue);
                                                 if (!items.Any(i => i.HideDetails == null || BooleanValue.ToBoolean(i.HideDetails)))
                                                     pivotField.SetCollapsed();
@@ -620,6 +642,28 @@
 
                                         if (pivotField != null)
                                         {
+                                            if (pf.AverageSubTotal != null)
+                                                pivotField.AddSubtotal(XLSubtotalFunction.Average);
+                                            if (pf.CountASubtotal != null)
+                                                pivotField.AddSubtotal(XLSubtotalFunction.Count);
+                                            if (pf.CountSubtotal != null)
+                                                pivotField.AddSubtotal(XLSubtotalFunction.CountNumbers);
+                                            if (pf.MaxSubtotal != null)
+                                                pivotField.AddSubtotal(XLSubtotalFunction.Maximum);
+                                            if (pf.MinSubtotal != null)
+                                                pivotField.AddSubtotal(XLSubtotalFunction.Minimum);
+                                            if (pf.ApplyStandardDeviationPInSubtotal != null)
+                                                pivotField.AddSubtotal(XLSubtotalFunction.PopulationStandardDeviation);
+                                            if (pf.ApplyVariancePInSubtotal != null)
+                                                pivotField.AddSubtotal(XLSubtotalFunction.PopulationVariance);
+                                            if (pf.ApplyProductInSubtotal != null)
+                                                pivotField.AddSubtotal(XLSubtotalFunction.Product);
+                                            if (pf.ApplyStandardDeviationInSubtotal != null)
+                                                pivotField.AddSubtotal(XLSubtotalFunction.StandardDeviation);
+                                            if (pf.SumSubtotal != null)
+                                                pivotField.AddSubtotal(XLSubtotalFunction.Sum);
+                                            if (pf.ApplyVarianceInSubtotal != null)
+                                                pivotField.AddSubtotal(XLSubtotalFunction.Variance);
                                             var items = pf.Items.OfType<Item>().Where(i => i.Index != null && i.Index.HasValue);
                                             if (!items.Any(i => i.HideDetails == null || BooleanValue.ToBoolean(i.HideDetails)))
                                                 pivotField.SetCollapsed();
diff --git a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs
index 60cee56..e376449 100644
--- a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs
+++ b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs
@@ -136,6 +136,23 @@
             }
         }
 
+        [Test]
+        public void CanLoadPivotTableSubtotals()
+        {
+            using (var stream = TestHelper.GetStreamFromResource(TestHelper.GetResourcePath(@"Misc\LoadPivotTables.xlsx")))
+            using (var wb = new XLWorkbook(stream))
+            {
+                var ws = wb.Worksheet("PivotTableSubtotals");
+                var pt = ws.PivotTable("PivotTableSubtotals");
+
+                var subtotals = pt.RowLabels.Get("Group").Subtotals.ToArray();
+                Assert.AreEqual(3, subtotals.Length);
+                Assert.AreEqual(XLSubtotalFunction.Average, subtotals[0]);
+                Assert.AreEqual(XLSubtotalFunction.Count, subtotals[1]);
+                Assert.AreEqual(XLSubtotalFunction.Sum, subtotals[2]);
+            }
+        }
+
         /// <summary>
         /// For non-English locales, the default style ("Normal" in English) can be
         /// another piece of text (e.g. ??????? in Russian).
diff --git a/ClosedXML_Tests/Resource/Misc/LoadPivotTables.xlsx b/ClosedXML_Tests/Resource/Misc/LoadPivotTables.xlsx
index 93e85b8..fb63015 100644
--- a/ClosedXML_Tests/Resource/Misc/LoadPivotTables.xlsx
+++ b/ClosedXML_Tests/Resource/Misc/LoadPivotTables.xlsx
Binary files differ