diff --git a/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/Excel/XLWorkbook_Save.cs
index 06d2984..2d00ac9 100644
--- a/ClosedXML/Excel/XLWorkbook_Save.cs
+++ b/ClosedXML/Excel/XLWorkbook_Save.cs
@@ -1827,7 +1827,7 @@
             PivotCaches pivotCaches;
             uint cacheId = 0;
             if (workbookPart.Workbook.PivotCaches == null)
-                pivotCaches = workbookPart.Workbook.AppendChild(new PivotCaches());
+                pivotCaches = workbookPart.Workbook.InsertAfter(new PivotCaches(), workbookPart.Workbook.CalculationProperties);
             else
             {
                 pivotCaches = workbookPart.Workbook.PivotCaches;
@@ -1908,12 +1908,10 @@
                 }
                 else
                 {
-                    foreach (var cellValue in source.Cells().Where(cell =>
-                        cell.Address.ColumnNumber == columnNumber &&
-                        cell.Address.RowNumber >
-                        source.FirstRow().RowNumber()).Select(
-                            cell => cell.Value.ToString())
-                        .Where(cellValue => !xlpf.SharedStrings.Contains(cellValue)))
+                    foreach (var cellValue in source.Cells()
+                        .Where(cell => cell.Address.ColumnNumber == columnNumber && cell.Address.RowNumber > source.FirstRow().RowNumber())
+                        .Select(cell => cell.Value.ToString())
+                        .Where(cellValue => !xlpf.SharedStrings.Select(ss => ss.ToLower()).Contains(cellValue.ToLower())))
                     {
                         xlpf.SharedStrings.Add(cellValue);
                     }
diff --git a/ClosedXML_Examples/PivotTables/PivotTables.cs b/ClosedXML_Examples/PivotTables/PivotTables.cs
index 5678228..9af9775 100644
--- a/ClosedXML_Examples/PivotTables/PivotTables.cs
+++ b/ClosedXML_Examples/PivotTables/PivotTables.cs
@@ -38,9 +38,11 @@
                 new Pastry("Danish", 394, -20.24, "Apr"),
                 new Pastry("Danish", 190, 60, "May"),
                 new Pastry("Danish", 221, 24.76, "June"),
+
+                // Deliberately add different casings of same string to ensure pivot table doesn't duplicate it.
                 new Pastry("Scone", 135, 0, "Apr"),
-                new Pastry("Scone", 122, 5.19, "May"),
-                new Pastry("Scone", 243, 44.2, "June")
+                new Pastry("SconE", 122, 5.19, "May"),
+                new Pastry("SCONE", 243, 44.2, "June")
             };
 
             using (var wb = new XLWorkbook())
diff --git a/ClosedXML_Tests/Resource/Examples/PivotTables/PivotTables.xlsx b/ClosedXML_Tests/Resource/Examples/PivotTables/PivotTables.xlsx
index c4025e5..d28109f 100644
--- a/ClosedXML_Tests/Resource/Examples/PivotTables/PivotTables.xlsx
+++ b/ClosedXML_Tests/Resource/Examples/PivotTables/PivotTables.xlsx
Binary files differ