diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs
index f22eec4..f373b6d 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs
@@ -231,8 +231,11 @@
         Boolean IsEmpty();
         Boolean IsEmpty(Boolean includeFormats);
 
+#if DEBUG
         IXLPivotTable CreatePivotTable(IXLCell targetCell);
         IXLPivotTable CreatePivotTable(IXLCell targetCell, String name);
+#endif
+
 
         //IXLChart CreateChart(Int32 firstRow, Int32 firstColumn, Int32 lastRow, Int32 lastColumn);
 
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs
index 14b6c0e..a9ce9b8 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs
@@ -1559,18 +1559,22 @@
         //    return chart;
         //}
 
+#if DEBUG
         IXLPivotTable IXLRangeBase.CreatePivotTable(IXLCell targetCell)
         {
             return CreatePivotTable(targetCell);
         }
-        public XLPivotTable CreatePivotTable(IXLCell targetCell)
-        {
-            return CreatePivotTable(targetCell, Guid.NewGuid().ToString());
-        }
         IXLPivotTable IXLRangeBase.CreatePivotTable(IXLCell targetCell, String name)
         {
             return CreatePivotTable(targetCell, name);
         }
+#endif
+
+        public XLPivotTable CreatePivotTable(IXLCell targetCell)
+        {
+            return CreatePivotTable(targetCell, Guid.NewGuid().ToString());
+        }
+
         public XLPivotTable CreatePivotTable(IXLCell targetCell, String name)
         {
             return (XLPivotTable)Worksheet.PivotTables.AddNew(name, targetCell, AsRange());
diff --git a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs
index c5f7ea1..fa70a33 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs
@@ -13,9 +13,7 @@
         static void Main(string[] args)
         {
             var wb = new XLWorkbook();
-            var pts = new PivotTableScenarios();
-            
-            pts.RunAll(wb);
+            var ws = wb.AddWorksheet("Sheet1");
 
             wb.SaveAs(@"Sandbox.xlsx");
         }
@@ -48,10 +46,12 @@
             ws.Cell("C3").Value = 150;
             ws.Cell("C4").Value = 75;
 
-            var pivotTable = ws.Range("A1:C4").CreatePivotTable(ws.Cell("E1"));
-            pivotTable.RowLabels.Add("Category");
-            pivotTable.RowLabels.Add("SubCategory");
-            pivotTable.Values.Add("Number").SetSummaryFormula(XLPivotSummary.Sum);
+            //var pivotTable = ws.Range("A1:C4").CreatePivotTable(ws.Cell("E1"));
+            //pivotTable.RowLabels.Add("Category");
+            //pivotTable.RowLabels.Add("SubCategory");
+            //pivotTable.Values.Add("Number").SetSummaryFormula(XLPivotSummary.Sum);
+
+
         }
 
         private void Add_category_on_row_and_SubCategory_on_column(XLWorkbook wb)
@@ -73,10 +73,10 @@
             ws.Cell("C3").Value = 150;
             ws.Cell("C4").Value = 75;
 
-            var pivotTable = ws.Range("A1:C4").CreatePivotTable(ws.Cell("E1"));
-            pivotTable.RowLabels.Add("Category");
-            pivotTable.ColumnLabels.Add("SubCategory");
-            pivotTable.Values.Add("Number").SetSummaryFormula(XLPivotSummary.Sum);
+            //var pivotTable = ws.Range("A1:C4").CreatePivotTable(ws.Cell("E1"));
+            //pivotTable.RowLabels.Add("Category");
+            //pivotTable.ColumnLabels.Add("SubCategory");
+            //pivotTable.Values.Add("Number").SetSummaryFormula(XLPivotSummary.Sum);
         }
     }
 }
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/AutoFilter/RegularAutoFilter.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/AutoFilter/RegularAutoFilter.xlsx
index 1b57c98..375d6b2 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/AutoFilter/RegularAutoFilter.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/AutoFilter/RegularAutoFilter.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataSet.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataSet.xlsx
index e81594f..e5bbb81 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataSet.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataSet.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataTableAsWorksheet.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataTableAsWorksheet.xlsx
index 3373336..66efdec 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataTableAsWorksheet.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataTableAsWorksheet.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx
index e300ad5..f2664a2 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/DataValidation.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/DataValidation.xlsx
index 68fbe2c..6fced73 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/DataValidation.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/DataValidation.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Hyperlinks.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Hyperlinks.xlsx
index 79bb1e6..f35b2ba 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Hyperlinks.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Hyperlinks.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/InsertingTables.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/InsertingTables.xlsx
index 739b576..2d9eff7 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/InsertingTables.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/InsertingTables.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/ShowCase.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/ShowCase.xlsx
index b0f3982..b68ddde 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/ShowCase.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/ShowCase.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/CopyingRanges.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/CopyingRanges.xlsx
index 544611e..374239a 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/CopyingRanges.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/CopyingRanges.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx
index 6f38430..ef28861 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx
Binary files differ
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/UsingTables.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/UsingTables.xlsx
index f3e164f..d57b7fb 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/UsingTables.xlsx
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/UsingTables.xlsx
Binary files differ