diff --git a/ClosedXML/ClosedXML/ClosedXML/ClosedXML.csproj b/ClosedXML/ClosedXML/ClosedXML/ClosedXML.csproj
index 76826e4..57f1bd9 100644
--- a/ClosedXML/ClosedXML/ClosedXML/ClosedXML.csproj
+++ b/ClosedXML/ClosedXML/ClosedXML/ClosedXML.csproj
@@ -133,10 +133,27 @@
     <Compile Include="Excel\Columns\XLColumnCollection.cs" />
     <Compile Include="Excel\Coordinates\XLSheetRange.cs" />
     <Compile Include="Excel\Coordinates\XLSheetPoint.cs" />
+    <Compile Include="Excel\PivotTables\PivotValues\XLPivotValueCombination.cs" />
+    <Compile Include="Excel\PivotTables\PivotValues\IXLPivotValueCombination.cs" />
+    <Compile Include="Excel\PivotTables\PivotValues\XLPivotValueFormat.cs" />
+    <Compile Include="Excel\PivotTables\PivotValues\IXLPivotValueFormat.cs" />
+    <Compile Include="Excel\PivotTables\PivotValues\XLPivotValue.cs" />
+    <Compile Include="Excel\PivotTables\PivotValues\XLPivotValues.cs" />
+    <Compile Include="Excel\PivotTables\XLPivotFields.cs" />
+    <Compile Include="Excel\PivotTables\XLPivotField.cs" />
+    <Compile Include="Excel\PivotTables\PivotValues\IXLPivotValues.cs" />
+    <Compile Include="Excel\PivotTables\IXLPivotFields.cs" />
+    <Compile Include="Excel\PivotTables\PivotValues\IXLPivotValue.cs" />
+    <Compile Include="Excel\PivotTables\IXLPivotField.cs" />
+    <Compile Include="Excel\PivotTables\IXLPivotTables.cs" />
+    <Compile Include="Excel\PivotTables\XLPivotTables.cs" />
+    <Compile Include="Excel\PivotTables\XLPivotTable.cs" />
+    <Compile Include="Excel\PivotTables\IXLPivotTable.cs" />
     <Compile Include="Excel\RichText\XLPhonetics.cs" />
     <Compile Include="Excel\RichText\XLPhonetic.cs" />
     <Compile Include="Excel\RichText\IXLPhonetics.cs" />
     <Compile Include="Excel\RichText\IXLPhonetic.cs" />
+    <Compile Include="Excel\Style\IXLNumberFormatBase.cs" />
     <Compile Include="Excel\XLWorkbook_Save.NestedTypes.cs" />
     <Compile Include="Excel\CustomProperties\XLCustomProperties.cs" />
     <Compile Include="Excel\CustomProperties\IXLCustomProperties.cs" />
@@ -264,9 +281,7 @@
     <Compile Include="PathHelper.cs" />
     <Compile Include="Properties\AssemblyInfo.cs" />
   </ItemGroup>
-  <ItemGroup>
-    <Folder Include="Excel\PivotTables\" />
-  </ItemGroup>
+  <ItemGroup />
   <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
   <!-- To modify your build process, add your task inside one of the targets below and uncomment it. 
        Other similar extension points exist, see Microsoft.Common.targets.
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLTimeCriteria.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLTimeCriteria.cs
index 117ee98..5d93a2e 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLTimeCriteria.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLTimeCriteria.cs
@@ -9,7 +9,7 @@
         {
         }
 
-        private String GetXLTime(TimeSpan value)
+        private static String GetXLTime(TimeSpan value)
         {
             return (value.TotalHours / 24.0).ToString();
         }
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheet.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheet.cs
index 5a38cb4..ef8223b 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheet.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheet.cs
@@ -320,5 +320,7 @@
         IXLWorksheet SetTabSelected(); IXLWorksheet SetTabSelected(Boolean value);
         IXLWorksheet SetTabActive(); IXLWorksheet SetTabActive(Boolean value);
 
+        IXLPivotTable PivotTable(String name);
+        IXLPivotTables PivotTables { get; }
     }
 }
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/IXLPivotField.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/IXLPivotField.cs
new file mode 100644
index 0000000..26336ec
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/IXLPivotField.cs
@@ -0,0 +1,55 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    public enum XLSubtotalFunction
+    {
+        Automatic,
+        None,
+        Sum,
+        Count,
+        Average,
+        Minimum,
+        Maximum,
+        Product,
+        CountNumbers,
+        StandardDeviation,
+        PopulationStandardDeviation,
+        Variance,
+        PopulationVariance,
+    }
+    public enum XLLabelForm { Outline, Tabular }
+    public interface IXLPivotField
+    {
+        String SourceName { get; }
+        String CustomName { get; set; }
+
+        XLSubtotalFunction Subtotals { get; set; }
+        Boolean IncludeNewItemsInFilter { get; set; }
+
+        XLLabelForm ItemLabelsForm { get; set; }
+        Boolean CompactForm { get; set; }
+        Boolean SubtotalsAtTop { get; set; }
+        Boolean RepeatItemLabels { get; set; }
+        Boolean InsertBlankLines  { get; set; }
+        Boolean ShowBlankItems { get; set; }
+        Boolean InsertPageBreaks { get; set; }
+
+        IXLPivotField SetCustomName(String value);
+
+        IXLPivotField SetSubtotals(XLSubtotalFunction value);
+        IXLPivotField SetIncludeNewItemsInFilter(); IXLPivotField SetIncludeNewItemsInFilter(Boolean value);
+
+        IXLPivotField SetItemLabelsForm(XLLabelForm value);
+        IXLPivotField SetCompactForm(); IXLPivotField SetCompactForm(Boolean value);
+        IXLPivotField SetSubtotalsAtTop(); IXLPivotField SetSubtotalsAtTop(Boolean value);
+        IXLPivotField SetRepeatItemLabels(); IXLPivotField SetRepeatItemLabels(Boolean value);
+        IXLPivotField SetInsertBlankLines(); IXLPivotField SetInsertBlankLines(Boolean value);
+        IXLPivotField SetShowBlankItems(); IXLPivotField SetShowBlankItems(Boolean value);
+        IXLPivotField SetInsertPageBreaks(); IXLPivotField SetInsertPageBreaks(Boolean value);
+
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/IXLPivotFields.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/IXLPivotFields.cs
new file mode 100644
index 0000000..97b70dd
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/IXLPivotFields.cs
@@ -0,0 +1,15 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    public interface IXLPivotFields: IEnumerable<IXLPivotField>
+    {
+        IXLPivotField Add(String sourceName);
+        IXLPivotField Add(String sourceName, String customName);
+        void Clear();
+        void Remove(String sourceName);
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/IXLPivotTable.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/IXLPivotTable.cs
new file mode 100644
index 0000000..a79ec3c
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/IXLPivotTable.cs
@@ -0,0 +1,101 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    public enum XLFilterAreaOrder { DownThenOver, OverThenDown }
+    public enum XLItemsToRetain { Automatic, None, Max }
+
+    public interface IXLPivotTable
+    {
+        IXLPivotFields ReportFilters { get; }
+        IXLPivotFields  ColumnLabels { get; }
+        IXLPivotFields RowLabels { get; }
+        IXLPivotValues Values { get; }
+
+        String Name { get; set; }
+        String Title { get; set; }
+        String Description { get; set; }
+
+        Boolean MergeAndCenterWithLabels { get; set; } // MergeItem
+        Int32 RowLabelIndent { get; set; } // Indent
+        XLFilterAreaOrder FilterAreaOrder { get; set; } // PageOverThenDown 
+        Int32 FilterFieldsPageWrap { get; set; } // PageWrap
+        String ErrorValueReplacement { get; set; } // ErrorCaption
+        String EmptyCellReplacement { get; set; } // MissingCaption
+        Boolean AutofitColumns { get; set; } //UseAutoFormatting 
+        Boolean PreserveCellFormatting { get; set; } // PreserveFormatting 
+        
+        Boolean ShowGrandTotalsRows { get; set; } // RowGrandTotals 
+        Boolean ShowGrandTotalsColumns { get; set; } // ColumnGrandTotals 
+        Boolean FilteredItemsInSubtotals { get; set; } // Subtotal filtered page items
+        Boolean AllowMultipleFilters { get; set; } // MultipleFieldFilters 
+        Boolean UseCustomListsForSorting { get; set; } // CustomListSort 
+
+        Boolean ShowExpandCollapseButtons { get; set; }
+        Boolean ShowContextualTooltips { get; set; }
+        Boolean ShowPropertiesInTooltips { get; set; }
+        Boolean DisplayCaptionsAndDropdowns { get; set; }
+        Boolean ClassicPivotTableLayout { get; set; }
+        Boolean ShowValuesRow { get; set; }
+        Boolean ShowEmptyItemsOnRows { get; set; }
+        Boolean ShowEmptyItemsOnColumns { get; set; }
+        Boolean DisplayItemLabels { get; set; }
+        Boolean SortFieldsAtoZ { get; set; }
+
+        Boolean PrintExpandCollapsedButtons { get; set; }
+        Boolean RepeatRowLabels { get; set; }
+        Boolean PrintTitles { get; set; }
+
+        Boolean SaveSourceData { get; set; }
+        Boolean EnableShowDetails { get; set; }
+        Boolean RefreshDataOnOpen { get; set; }
+        XLItemsToRetain ItemsToRetainPerField { get; set; }
+        Boolean EnableCellEditing { get; set; }
+
+        IXLPivotTable SetName(String value);
+        IXLPivotTable SetTitle(String value);
+        IXLPivotTable SetDescription(String value);
+
+        IXLPivotTable SetMergeAndCenterWithLabels(); IXLPivotTable SetMergeAndCenterWithLabels(Boolean value);
+        IXLPivotTable SetRowLabelIndent(Int32 value);
+        IXLPivotTable SetFilterAreaOrder(XLFilterAreaOrder value);
+        IXLPivotTable SetFilterFieldsPageWrap(Int32 value);
+        IXLPivotTable SetErrorValueReplacement(String value);
+        IXLPivotTable SetEmptyCellReplacement(String value);
+        IXLPivotTable SetAutofitColumns(); IXLPivotTable SetAutofitColumns(Boolean value);
+        IXLPivotTable SetPreserveCellFormatting(); IXLPivotTable SetPreserveCellFormatting(Boolean value);
+
+        IXLPivotTable SetShowGrandTotalsRows(); IXLPivotTable SetShowGrandTotalsRows(Boolean value);
+        IXLPivotTable SetShowGrandTotalsColumns(); IXLPivotTable SetShowGrandTotalsColumns(Boolean value);
+        IXLPivotTable SetFilteredItemsInSubtotals(); IXLPivotTable SetFilteredItemsInSubtotals(Boolean value);
+        IXLPivotTable SetAllowMultipleFilters(); IXLPivotTable SetAllowMultipleFilters(Boolean value);
+        IXLPivotTable SetUseCustomListsForSorting(); IXLPivotTable SetUseCustomListsForSorting(Boolean value);
+
+        IXLPivotTable SetShowExpandCollapseButtons(); IXLPivotTable SetShowExpandCollapseButtons(Boolean value);
+        IXLPivotTable SetShowContextualTooltips(); IXLPivotTable SetShowContextualTooltips(Boolean value);
+        IXLPivotTable SetShowPropertiesInTooltips(); IXLPivotTable SetShowPropertiesInTooltips(Boolean value);
+        IXLPivotTable SetDisplayCaptionsAndDropdowns(); IXLPivotTable SetDisplayCaptionsAndDropdowns(Boolean value);
+        IXLPivotTable SetClassicPivotTableLayout(); IXLPivotTable SetClassicPivotTableLayout(Boolean value);
+        IXLPivotTable SetShowValuesRow(); IXLPivotTable SetShowValuesRow(Boolean value);
+        IXLPivotTable SetShowEmptyItemsOnRows(); IXLPivotTable SetShowEmptyItemsOnRows(Boolean value);
+        IXLPivotTable SetShowEmptyItemsOnColumns(); IXLPivotTable SetShowEmptyItemsOnColumns(Boolean value);
+        IXLPivotTable SetDisplayItemLabels(); IXLPivotTable SetDisplayItemLabels(Boolean value);
+        IXLPivotTable SetSortFieldsAtoZ(); IXLPivotTable SetSortFieldsAtoZ(Boolean value);
+
+        IXLPivotTable SetPrintExpandCollapsedButtons(); IXLPivotTable SetPrintExpandCollapsedButtons(Boolean value);
+        IXLPivotTable SetRepeatRowLabels(); IXLPivotTable SetRepeatRowLabels(Boolean value);
+        IXLPivotTable SetPrintTitles(); IXLPivotTable SetPrintTitles(Boolean value);
+
+        IXLPivotTable SetSaveSourceData(); IXLPivotTable SetSaveSourceData(Boolean value);
+        IXLPivotTable SetEnableShowDetails(); IXLPivotTable SetEnableShowDetails(Boolean value);
+        IXLPivotTable SetRefreshDataOnOpen(); IXLPivotTable SetRefreshDataOnOpen(Boolean value);
+        IXLPivotTable SetItemsToRetainPerField(XLItemsToRetain value);
+        IXLPivotTable SetEnableCellEditing(); IXLPivotTable SetEnableCellEditing(Boolean value);
+
+
+
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/IXLPivotTables.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/IXLPivotTables.cs
new file mode 100644
index 0000000..bd27bb9
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/IXLPivotTables.cs
@@ -0,0 +1,14 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    public interface IXLPivotTables: IEnumerable<IXLPivotTable>
+    {
+        IXLPivotTable PivotTable(String name);
+        void Delete(String name);
+        void DeleteAll();
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/IXLPivotValue.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/IXLPivotValue.cs
new file mode 100644
index 0000000..48c6190
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/IXLPivotValue.cs
@@ -0,0 +1,71 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    public enum XLPivotSummary
+    {
+        Sum,
+        Count,
+        Average,
+        Minimum,
+        Maximum,
+        Product,
+        CountNumbers,
+        StandardDeviation,
+        PopulationStandardDeviation,
+        Variance,
+        PopulationVariance,
+    }
+
+    public enum XLPivotCalculation
+    {
+        Normal,
+        DifferenceFrom,
+        PctOf,
+        PctDifferenceFrom,
+        RunningTotal,
+        PctOfRow,
+        PctOfColumn,
+        PctOfTotal,
+        Index
+    }
+    public enum XLPivotCalculationItem
+    {
+        Value, Previous, Next
+    }
+
+    public interface IXLPivotValue
+    {
+        String SourceName { get; }
+        String CustomName { get; set; }
+
+        IXLPivotValueFormat NumberFormat { get; }
+
+        XLPivotSummary SummaryFormula { get; set; }
+        XLPivotCalculation Calculation { get; set; }
+        String BaseField { get; set; }
+        String BaseItem { get; set; }
+        XLPivotCalculationItem CalculationItem { get; set; }
+
+        IXLPivotValue SetSummaryFormula(XLPivotSummary value);
+        IXLPivotValue SetCalculation(XLPivotCalculation value);
+        IXLPivotValue SetBaseField(String value);
+        IXLPivotValue SetBaseItem(String value);
+        IXLPivotValue SetCalculationItem(XLPivotCalculationItem value);
+
+
+        IXLPivotValue ShowAsNormal();
+        IXLPivotValueCombination ShowAsDifferenceFrom(String fieldSourceName);
+        IXLPivotValueCombination ShowAsPctFrom(String fieldSourceName);
+        IXLPivotValueCombination ShowAsPctDifferenceFrom(String fieldSourceName);
+        IXLPivotValue ShowAsRunningTotalIn(String fieldSourceName);
+        IXLPivotValue ShowAsPctOfRow();
+        IXLPivotValue ShowAsPctOfColumn();
+        IXLPivotValue ShowAsPctOfTotal();
+        IXLPivotValue ShowAsIndex();
+
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/IXLPivotValueCombination.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/IXLPivotValueCombination.cs
new file mode 100644
index 0000000..3e655b8
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/IXLPivotValueCombination.cs
@@ -0,0 +1,14 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    public interface IXLPivotValueCombination
+    {
+        IXLPivotValue And(String item);
+        IXLPivotValue AndPrevious();
+        IXLPivotValue AndNext();
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/IXLPivotValueFormat.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/IXLPivotValueFormat.cs
new file mode 100644
index 0000000..6ccaedf
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/IXLPivotValueFormat.cs
@@ -0,0 +1,13 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    public interface IXLPivotValueFormat: IXLNumberFormatBase
+    {
+        IXLPivotValue SetNumberFormatId(Int32 value);
+        IXLPivotValue SetFormat(String value);
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/IXLPivotValues.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/IXLPivotValues.cs
new file mode 100644
index 0000000..0d971e6
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/IXLPivotValues.cs
@@ -0,0 +1,15 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    public interface IXLPivotValues: IEnumerable<IXLPivotValue>
+    {
+        IXLPivotValue Add(String sourceName);
+        IXLPivotValue Add(String sourceName, String customName);
+        void Clear();
+        void Remove(String sourceName);
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/XLPivotValue.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/XLPivotValue.cs
new file mode 100644
index 0000000..37ec344
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/XLPivotValue.cs
@@ -0,0 +1,74 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    internal class XLPivotValue: IXLPivotValue
+    {
+        public XLPivotValue(string sourceName)
+        {
+            SourceName = sourceName;
+            NumberFormat = new XLPivotValueFormat(this);
+        }
+
+        public IXLPivotValueFormat NumberFormat { get; private set; }
+        public String SourceName { get; private set; }	
+        public String CustomName { get; set; }		public IXLPivotValue SetCustomName(String value) { CustomName = value; return this; }
+
+        public XLPivotSummary SummaryFormula { get; set; }		public IXLPivotValue SetSummaryFormula(XLPivotSummary value) { SummaryFormula = value; return this; }
+        public XLPivotCalculation Calculation { get; set; }		public IXLPivotValue SetCalculation(XLPivotCalculation value) { Calculation = value; return this; }
+        public String BaseField { get; set; }		public IXLPivotValue SetBaseField(String value) { BaseField = value; return this; }
+        public String BaseItem { get; set; }		public IXLPivotValue SetBaseItem(String value) { BaseItem = value; return this; }
+        public XLPivotCalculationItem CalculationItem { get; set; }		public IXLPivotValue SetCalculationItem(XLPivotCalculationItem value) { CalculationItem = value; return this; }
+
+
+        public IXLPivotValue ShowAsNormal()
+        {
+            return SetCalculation(XLPivotCalculation.Normal);
+        }
+        public IXLPivotValueCombination ShowAsDifferenceFrom(String fieldSourceName)
+        {
+            BaseField = fieldSourceName;
+            SetCalculation(XLPivotCalculation.DifferenceFrom);
+            return new XLPivotValueCombination(this);
+        }
+        public IXLPivotValueCombination ShowAsPctFrom(String fieldSourceName)
+        {
+            BaseField = fieldSourceName;
+            SetCalculation(XLPivotCalculation.PctOf);
+            return new XLPivotValueCombination(this);
+        }
+        public IXLPivotValueCombination ShowAsPctDifferenceFrom(String fieldSourceName)
+        {
+            BaseField = fieldSourceName;
+            SetCalculation(XLPivotCalculation.PctDifferenceFrom);
+            return new XLPivotValueCombination(this);
+        }
+        public IXLPivotValue ShowAsRunningTotalIn(String fieldSourceName)
+        {
+            BaseField = fieldSourceName;
+            return SetCalculation(XLPivotCalculation.RunningTotal);
+        }
+        public IXLPivotValue ShowAsPctOfRow()
+        {
+            return SetCalculation(XLPivotCalculation.PctOfRow);
+        }
+
+        public IXLPivotValue ShowAsPctOfColumn()
+        {
+            return SetCalculation(XLPivotCalculation.PctOfColumn);
+        }
+
+        public IXLPivotValue ShowAsPctOfTotal()
+        {
+            return SetCalculation(XLPivotCalculation.PctOfTotal);
+        }
+
+        public IXLPivotValue ShowAsIndex()
+        {
+            return SetCalculation(XLPivotCalculation.Index);
+        }
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/XLPivotValueCombination.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/XLPivotValueCombination.cs
new file mode 100644
index 0000000..56f04bc
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/XLPivotValueCombination.cs
@@ -0,0 +1,32 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    internal class XLPivotValueCombination: IXLPivotValueCombination
+    {
+        private readonly IXLPivotValue _pivotValue;
+        public XLPivotValueCombination(IXLPivotValue pivotValue)
+        {
+            _pivotValue = pivotValue;
+        }
+        public IXLPivotValue And(String item)
+        {
+            _pivotValue.BaseItem = item;
+            _pivotValue.CalculationItem = XLPivotCalculationItem.Value;
+            return _pivotValue;
+        }
+        public IXLPivotValue AndPrevious()
+        {
+            _pivotValue.CalculationItem = XLPivotCalculationItem.Previous;
+            return _pivotValue;
+        }
+        public IXLPivotValue AndNext()
+        {
+            _pivotValue.CalculationItem = XLPivotCalculationItem.Next;
+            return _pivotValue;
+        }
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/XLPivotValueFormat.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/XLPivotValueFormat.cs
new file mode 100644
index 0000000..a45d71c
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/XLPivotValueFormat.cs
@@ -0,0 +1,50 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    internal class XLPivotValueFormat: IXLPivotValueFormat
+    {
+        private readonly XLPivotValue _pivotValue;
+        public XLPivotValueFormat(XLPivotValue pivotValue)
+        {
+            _pivotValue = pivotValue;
+        }
+
+        private Int32 _numberFormatId = -1;
+        public Int32 NumberFormatId
+        {
+            get { return _numberFormatId; }
+            set
+            {
+                _numberFormatId = value;
+                _format = string.Empty;
+            }
+        }
+
+        private String _format = String.Empty;
+        public String Format
+        {
+            get { return _format; }
+            set
+            {
+                _format = value;
+                _numberFormatId = -1;
+            }
+        }
+
+        public IXLPivotValue SetNumberFormatId(Int32 value)
+        {
+            NumberFormatId = value;
+            return _pivotValue;
+        }
+        public IXLPivotValue SetFormat(String value)
+        {
+            Format = value;
+            return _pivotValue;
+        }
+
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/XLPivotValues.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/XLPivotValues.cs
new file mode 100644
index 0000000..b855923
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/PivotValues/XLPivotValues.cs
@@ -0,0 +1,41 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    internal class XLPivotValues: IXLPivotValues
+    {
+        private readonly Dictionary<String, IXLPivotValue> _pivotValues = new Dictionary<string, IXLPivotValue>();
+        public IEnumerator<IXLPivotValue> GetEnumerator()
+        {
+            return _pivotValues.Values.GetEnumerator();
+        }
+
+        System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
+        {
+            return GetEnumerator();
+        }
+
+        public IXLPivotValue Add(String sourceName)
+        {
+            return Add(sourceName, sourceName);
+        }
+        public IXLPivotValue Add(String sourceName, String customName)
+        {
+            var pivotValue = new XLPivotValue(sourceName) { CustomName = customName };
+            _pivotValues.Add(sourceName, pivotValue);
+            return pivotValue;
+        }
+
+        public void Clear()
+        {
+            _pivotValues.Clear();
+        }
+        public void Remove(String sourceName)
+        {
+            _pivotValues.Remove(sourceName);
+        }
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/XLPivotField.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/XLPivotField.cs
new file mode 100644
index 0000000..eb345f5
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/XLPivotField.cs
@@ -0,0 +1,31 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+
+    public class XLPivotField: IXLPivotField
+    {
+        public XLPivotField(string sourceName)
+        {
+            SourceName = sourceName;
+        }
+
+        public String SourceName { get; private set; }	
+        public String CustomName { get; set; }		public IXLPivotField SetCustomName(String value) { CustomName = value; return this; }
+
+        public XLSubtotalFunction Subtotals { get; set; }		public IXLPivotField SetSubtotals(XLSubtotalFunction value) { Subtotals = value; return this; }
+        public Boolean IncludeNewItemsInFilter { get; set; }	public IXLPivotField SetIncludeNewItemsInFilter() { IncludeNewItemsInFilter = true; return this; }	public IXLPivotField SetIncludeNewItemsInFilter(Boolean value) { IncludeNewItemsInFilter = value; return this; }
+
+        public XLLabelForm ItemLabelsForm { get; set; }		public IXLPivotField SetItemLabelsForm(XLLabelForm value) { ItemLabelsForm = value; return this; }
+        public Boolean CompactForm { get; set; }	public IXLPivotField SetCompactForm() { CompactForm = true; return this; }	public IXLPivotField SetCompactForm(Boolean value) { CompactForm = value; return this; }
+        public Boolean SubtotalsAtTop { get; set; }	public IXLPivotField SetSubtotalsAtTop() { SubtotalsAtTop = true; return this; }	public IXLPivotField SetSubtotalsAtTop(Boolean value) { SubtotalsAtTop = value; return this; }
+        public Boolean RepeatItemLabels { get; set; }	public IXLPivotField SetRepeatItemLabels() { RepeatItemLabels = true; return this; }	public IXLPivotField SetRepeatItemLabels(Boolean value) { RepeatItemLabels = value; return this; }
+        public Boolean InsertBlankLines { get; set; }	public IXLPivotField SetInsertBlankLines() { InsertBlankLines = true; return this; }	public IXLPivotField SetInsertBlankLines(Boolean value) { InsertBlankLines = value; return this; }
+        public Boolean ShowBlankItems { get; set; }	public IXLPivotField SetShowBlankItems() { ShowBlankItems = true; return this; }	public IXLPivotField SetShowBlankItems(Boolean value) { ShowBlankItems = value; return this; }
+        public Boolean InsertPageBreaks { get; set; }	public IXLPivotField SetInsertPageBreaks() { InsertPageBreaks = true; return this; }	public IXLPivotField SetInsertPageBreaks(Boolean value) { InsertPageBreaks = value; return this; }
+
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/XLPivotFields.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/XLPivotFields.cs
new file mode 100644
index 0000000..eeea202
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/XLPivotFields.cs
@@ -0,0 +1,41 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    public class XLPivotFields: IXLPivotFields
+    {
+        private readonly Dictionary<String, IXLPivotField> _pivotFields = new Dictionary<string, IXLPivotField>();
+        public IEnumerator<IXLPivotField> GetEnumerator()
+        {
+            return _pivotFields.Values.GetEnumerator();
+        }
+
+        System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
+        {
+            return GetEnumerator();
+        }
+
+        public IXLPivotField Add(String sourceName)
+        {
+            return Add(sourceName, sourceName);
+        }
+        public IXLPivotField Add(String sourceName, String customName)
+        {
+            var pivotField = new XLPivotField(sourceName) {CustomName = customName};
+            _pivotFields.Add(sourceName, pivotField);
+            return pivotField;
+        }
+
+        public void Clear()
+        {
+            _pivotFields.Clear();
+        }
+        public void Remove(String sourceName)
+        {
+            _pivotFields.Remove(sourceName);
+        }
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/XLPivotTable.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/XLPivotTable.cs
new file mode 100644
index 0000000..f8bab9a
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/XLPivotTable.cs
@@ -0,0 +1,64 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    internal class XLPivotTable: IXLPivotTable
+    {
+        public XLPivotTable()
+        {
+            ReportFilters = new XLPivotFields();
+            ColumnLabels=new XLPivotFields();
+            RowLabels = new XLPivotFields();
+            Values = new XLPivotValues();
+        }
+
+        public IXLPivotFields ReportFilters { get; private set; }
+        public IXLPivotFields ColumnLabels { get; private set; }
+        public IXLPivotFields RowLabels { get; private set; }
+        public IXLPivotValues Values { get; private set; }
+
+        public String Name { get; set; }		public IXLPivotTable SetName(String value) { Name = value; return this; }
+        public String Title { get; set; }		public IXLPivotTable SetTitle(String value) { Title = value; return this; }
+        public String Description { get; set; }		public IXLPivotTable SetDescription(String value) { Description = value; return this; }
+
+        public Boolean MergeAndCenterWithLabels { get; set; }	public IXLPivotTable SetMergeAndCenterWithLabels() { MergeAndCenterWithLabels = true; return this; }	public IXLPivotTable SetMergeAndCenterWithLabels(Boolean value) { MergeAndCenterWithLabels = value; return this; }
+        public Int32 RowLabelIndent { get; set; }		public IXLPivotTable SetRowLabelIndent(Int32 value) { RowLabelIndent = value; return this; }
+        public XLFilterAreaOrder FilterAreaOrder { get; set; }		public IXLPivotTable SetFilterAreaOrder(XLFilterAreaOrder value) { FilterAreaOrder = value; return this; }
+        public Int32 FilterFieldsPageWrap { get; set; }		public IXLPivotTable SetFilterFieldsPageWrap(Int32 value) { FilterFieldsPageWrap = value; return this; }
+        public String ErrorValueReplacement { get; set; }		public IXLPivotTable SetErrorValueReplacement(String value) { ErrorValueReplacement = value; return this; }
+        public String EmptyCellReplacement { get; set; }		public IXLPivotTable SetEmptyCellReplacement(String value) { EmptyCellReplacement = value; return this; }
+        public Boolean AutofitColumns { get; set; }	public IXLPivotTable SetAutofitColumns() { AutofitColumns = true; return this; }	public IXLPivotTable SetAutofitColumns(Boolean value) { AutofitColumns = value; return this; }
+        public Boolean PreserveCellFormatting { get; set; }	public IXLPivotTable SetPreserveCellFormatting() { PreserveCellFormatting = true; return this; }	public IXLPivotTable SetPreserveCellFormatting(Boolean value) { PreserveCellFormatting = value; return this; }
+
+        public Boolean ShowGrandTotalsRows { get; set; }	public IXLPivotTable SetShowGrandTotalsRows() { ShowGrandTotalsRows = true; return this; }	public IXLPivotTable SetShowGrandTotalsRows(Boolean value) { ShowGrandTotalsRows = value; return this; }
+        public Boolean ShowGrandTotalsColumns { get; set; }	public IXLPivotTable SetShowGrandTotalsColumns() { ShowGrandTotalsColumns = true; return this; }	public IXLPivotTable SetShowGrandTotalsColumns(Boolean value) { ShowGrandTotalsColumns = value; return this; }
+        public Boolean FilteredItemsInSubtotals { get; set; }	public IXLPivotTable SetFilteredItemsInSubtotals() { FilteredItemsInSubtotals = true; return this; }	public IXLPivotTable SetFilteredItemsInSubtotals(Boolean value) { FilteredItemsInSubtotals = value; return this; }
+        public Boolean AllowMultipleFilters { get; set; }	public IXLPivotTable SetAllowMultipleFilters() { AllowMultipleFilters = true; return this; }	public IXLPivotTable SetAllowMultipleFilters(Boolean value) { AllowMultipleFilters = value; return this; }
+        public Boolean UseCustomListsForSorting { get; set; }	public IXLPivotTable SetUseCustomListsForSorting() { UseCustomListsForSorting = true; return this; }	public IXLPivotTable SetUseCustomListsForSorting(Boolean value) { UseCustomListsForSorting = value; return this; }
+
+        public Boolean ShowExpandCollapseButtons { get; set; }	public IXLPivotTable SetShowExpandCollapseButtons() { ShowExpandCollapseButtons = true; return this; }	public IXLPivotTable SetShowExpandCollapseButtons(Boolean value) { ShowExpandCollapseButtons = value; return this; }
+        public Boolean ShowContextualTooltips { get; set; }	public IXLPivotTable SetShowContextualTooltips() { ShowContextualTooltips = true; return this; }	public IXLPivotTable SetShowContextualTooltips(Boolean value) { ShowContextualTooltips = value; return this; }
+        public Boolean ShowPropertiesInTooltips { get; set; }	public IXLPivotTable SetShowPropertiesInTooltips() { ShowPropertiesInTooltips = true; return this; }	public IXLPivotTable SetShowPropertiesInTooltips(Boolean value) { ShowPropertiesInTooltips = value; return this; }
+        public Boolean DisplayCaptionsAndDropdowns { get; set; }	public IXLPivotTable SetDisplayCaptionsAndDropdowns() { DisplayCaptionsAndDropdowns = true; return this; }	public IXLPivotTable SetDisplayCaptionsAndDropdowns(Boolean value) { DisplayCaptionsAndDropdowns = value; return this; }
+        public Boolean ClassicPivotTableLayout { get; set; }	public IXLPivotTable SetClassicPivotTableLayout() { ClassicPivotTableLayout = true; return this; }	public IXLPivotTable SetClassicPivotTableLayout(Boolean value) { ClassicPivotTableLayout = value; return this; }
+        public Boolean ShowValuesRow { get; set; }	public IXLPivotTable SetShowValuesRow() { ShowValuesRow = true; return this; }	public IXLPivotTable SetShowValuesRow(Boolean value) { ShowValuesRow = value; return this; }
+        public Boolean ShowEmptyItemsOnRows { get; set; }	public IXLPivotTable SetShowEmptyItemsOnRows() { ShowEmptyItemsOnRows = true; return this; }	public IXLPivotTable SetShowEmptyItemsOnRows(Boolean value) { ShowEmptyItemsOnRows = value; return this; }
+        public Boolean ShowEmptyItemsOnColumns { get; set; }	public IXLPivotTable SetShowEmptyItemsOnColumns() { ShowEmptyItemsOnColumns = true; return this; }	public IXLPivotTable SetShowEmptyItemsOnColumns(Boolean value) { ShowEmptyItemsOnColumns = value; return this; }
+        public Boolean DisplayItemLabels { get; set; }	public IXLPivotTable SetDisplayItemLabels() { DisplayItemLabels = true; return this; }	public IXLPivotTable SetDisplayItemLabels(Boolean value) { DisplayItemLabels = value; return this; }
+        public Boolean SortFieldsAtoZ { get; set; }	public IXLPivotTable SetSortFieldsAtoZ() { SortFieldsAtoZ = true; return this; }	public IXLPivotTable SetSortFieldsAtoZ(Boolean value) { SortFieldsAtoZ = value; return this; }
+
+        public Boolean PrintExpandCollapsedButtons { get; set; }	public IXLPivotTable SetPrintExpandCollapsedButtons() { PrintExpandCollapsedButtons = true; return this; }	public IXLPivotTable SetPrintExpandCollapsedButtons(Boolean value) { PrintExpandCollapsedButtons = value; return this; }
+        public Boolean RepeatRowLabels { get; set; }	public IXLPivotTable SetRepeatRowLabels() { RepeatRowLabels = true; return this; }	public IXLPivotTable SetRepeatRowLabels(Boolean value) { RepeatRowLabels = value; return this; }
+        public Boolean PrintTitles { get; set; }	public IXLPivotTable SetPrintTitles() { PrintTitles = true; return this; }	public IXLPivotTable SetPrintTitles(Boolean value) { PrintTitles = value; return this; }
+
+        public Boolean SaveSourceData { get; set; }	public IXLPivotTable SetSaveSourceData() { SaveSourceData = true; return this; }	public IXLPivotTable SetSaveSourceData(Boolean value) { SaveSourceData = value; return this; }
+        public Boolean EnableShowDetails { get; set; }	public IXLPivotTable SetEnableShowDetails() { EnableShowDetails = true; return this; }	public IXLPivotTable SetEnableShowDetails(Boolean value) { EnableShowDetails = value; return this; }
+        public Boolean RefreshDataOnOpen { get; set; }	public IXLPivotTable SetRefreshDataOnOpen() { RefreshDataOnOpen = true; return this; }	public IXLPivotTable SetRefreshDataOnOpen(Boolean value) { RefreshDataOnOpen = value; return this; }
+        public XLItemsToRetain ItemsToRetainPerField { get; set; }		public IXLPivotTable SetItemsToRetainPerField(XLItemsToRetain value) { ItemsToRetainPerField = value; return this; }
+        public Boolean EnableCellEditing { get; set; }	public IXLPivotTable SetEnableCellEditing() { EnableCellEditing = true; return this; }	public IXLPivotTable SetEnableCellEditing(Boolean value) { EnableCellEditing = value; return this; }
+
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/XLPivotTables.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/XLPivotTables.cs
new file mode 100644
index 0000000..a09536b
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PivotTables/XLPivotTables.cs
@@ -0,0 +1,43 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    internal class XLPivotTables: IXLPivotTables
+    {
+        private readonly Dictionary<String, XLPivotTable> _pivotTables = new Dictionary<string, XLPivotTable>();
+        public IEnumerator<IXLPivotTable> GetEnumerator()
+        {
+            return _pivotTables.Values.Cast<IXLPivotTable>().GetEnumerator();
+        }
+
+        System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
+        {
+            return GetEnumerator();
+        }
+
+        public XLPivotTable PivotTable(String name)
+        {
+            return _pivotTables[name];
+        }
+        IXLPivotTable IXLPivotTables.PivotTable(String name)
+        {
+            return PivotTable(name);
+        }
+        public void Delete(String name)
+        {
+            _pivotTables.Remove(name);
+        }
+        public void DeleteAll()
+        {
+            _pivotTables.Clear();
+        }
+
+        public void Add(String name, XLPivotTable pivotTable)
+        {
+            _pivotTables.Add(name, pivotTable);
+        }
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRange.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRange.cs
index bbad09d..3733011 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRange.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRange.cs
@@ -242,6 +242,7 @@
         IXLRange Sort(XLSortOrientation sortOrientation, String elementsToSortBy, Boolean matchCase);
 
         IXLRange SetDataType(XLCellValues dataType);
+        
     }
 }
 
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs
index 06a7ebd..c4256c4 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs
@@ -220,6 +220,8 @@
         Boolean IsEmpty();
         Boolean IsEmpty(Boolean includeFormats);
 
+        IXLPivotTable CreatePivotTable(IXLCell targetCell);
+        IXLPivotTable CreatePivotTable(IXLCell targetCell, String name);
 
         //IXLChart CreateChart(Int32 firstRow, Int32 firstColumn, Int32 lastRow, Int32 lastColumn);
     }
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRange.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRange.cs
index b254049..8fd7ccc 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRange.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRange.cs
@@ -978,5 +978,7 @@
             return RangeAddress.GetHashCode()
                    ^ Worksheet.GetHashCode();
         }
+
+
     }
 }
\ No newline at end of file
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs
index 73a09f0..bf78385 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs
@@ -1190,5 +1190,22 @@
         //    Worksheet.Charts.Add(chart);
         //    return chart;
         //}
+
+        IXLPivotTable IXLRangeBase.CreatePivotTable(IXLCell targetCell)
+        {
+            return CreatePivotTable(targetCell);
+        }
+        public XLPivotTable CreatePivotTable(IXLCell targetCell)
+        {
+            throw new NotImplementedException();
+        }
+        IXLPivotTable IXLRangeBase.CreatePivotTable(IXLCell targetCell, String name)
+        {
+            return CreatePivotTable(targetCell, name);
+        }
+        public XLPivotTable CreatePivotTable(IXLCell targetCell, String name)
+        {
+            throw new NotImplementedException();
+        }
     }
 }
\ No newline at end of file
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLNumberFormat.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLNumberFormat.cs
index 73f36e2..1490413 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLNumberFormat.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLNumberFormat.cs
@@ -2,10 +2,8 @@
 
 namespace ClosedXML.Excel
 {
-    public interface IXLNumberFormat: IEquatable<IXLNumberFormat>
+    public interface IXLNumberFormat: IXLNumberFormatBase, IEquatable<IXLNumberFormat>
     {
-        Int32 NumberFormatId { get; set; }
-        String Format { get; set; }
         IXLStyle SetNumberFormatId(Int32 value);
         IXLStyle SetFormat(String value);
     }
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLNumberFormatBase.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLNumberFormatBase.cs
new file mode 100644
index 0000000..d162a90
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLNumberFormatBase.cs
@@ -0,0 +1,13 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel
+{
+    public interface IXLNumberFormatBase
+    {
+        Int32 NumberFormatId { get; set; }
+        String Format { get; set; }
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLNumberFormat.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLNumberFormat.cs
index 1cb2b21..ad9b4b0 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLNumberFormat.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLNumberFormat.cs
@@ -6,46 +6,46 @@
     {
         #region Properties
 
-        IXLStylized container;
+        readonly IXLStylized _container;
 
-        private Int32 numberFormatId;
+        private Int32 _numberFormatId;
         public Int32 NumberFormatId
         {
-            get { return numberFormatId; }
+            get { return _numberFormatId; }
             set
             {
-                if (container != null && !container.UpdatingStyle)
+                if (_container != null && !_container.UpdatingStyle)
                 {
-                    container.Styles.ForEach(s => s.NumberFormat.NumberFormatId = value);
+                    _container.Styles.ForEach(s => s.NumberFormat.NumberFormatId = value);
                 }
                 else
                 {
-                    numberFormatId = value;
-                    format = String.Empty;
+                    _numberFormatId = value;
+                    _format = String.Empty;
                 }
             }
         }
 
-        private String format = String.Empty;
+        private String _format = String.Empty;
         public String Format
         {
-            get { return format; }
+            get { return _format; }
             set
             {
-                if (container != null && !container.UpdatingStyle)
+                if (_container != null && !_container.UpdatingStyle)
                 {
-                    container.Styles.ForEach(s => s.NumberFormat.Format = value);
+                    _container.Styles.ForEach(s => s.NumberFormat.Format = value);
                 }
                 else
                 {
-                    format = value;
-                    numberFormatId = -1;
+                    _format = value;
+                    _numberFormatId = -1;
                 }
             }
         }
 
-        public IXLStyle SetNumberFormatId(Int32 value) { NumberFormatId = value; return container.Style; }
-        public IXLStyle SetFormat(String value) { Format = value; return container.Style; }
+        public IXLStyle SetNumberFormatId(Int32 value) { NumberFormatId = value; return _container.Style; }
+        public IXLStyle SetFormat(String value) { Format = value; return _container.Style; }
 
         #endregion
 
@@ -59,12 +59,10 @@
 
         public XLNumberFormat(IXLStylized container, IXLNumberFormat defaultNumberFormat)
         {
-            this.container = container;
-            if (defaultNumberFormat != null)
-            {
-                numberFormatId = defaultNumberFormat.NumberFormatId;
-                format = defaultNumberFormat.Format;
-            }
+            _container = container;
+            if (defaultNumberFormat == null) return;
+            _numberFormatId = defaultNumberFormat.NumberFormatId;
+            _format = defaultNumberFormat.Format;
         }
 
         #endregion
@@ -73,23 +71,24 @@
 
         public override string ToString()
         {
-            return numberFormatId.ToString() + "-" + format;
+            return _numberFormatId + "-" + _format;
         }
 
         #endregion
 
         public bool Equals(IXLNumberFormat other)
         {
-            var otherNF = other as XLNumberFormat;
+            var otherNf = other as XLNumberFormat;
+            
             return
-            numberFormatId == otherNF.numberFormatId
-            && format == otherNF.format
+            _numberFormatId == otherNf._numberFormatId
+            && _format == otherNf._format
             ;
         }
 
         public override bool Equals(object obj)
         {
-            return this.Equals((XLNumberFormat)obj);
+            return Equals((XLNumberFormat)obj);
         }
 
         public override int GetHashCode()
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs
index e3794e3..2d175db 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs
@@ -52,6 +52,7 @@
             Tables = new XLTables();
             Hyperlinks = new XLHyperlinks();
             DataValidations = new XLDataValidations();
+            PivotTables = new XLPivotTables();
             Protection = new XLSheetProtection();
             Workbook = workbook;
             _style = new XLStyle(this, workbook.Style);
@@ -1101,5 +1102,15 @@
             SortRows.ForEach(e => range.SortRows.Add(e.ElementNumber, e.SortOrder, e.IgnoreBlanks, e.MatchCase));
             return range;
         }
+
+        IXLPivotTable IXLWorksheet.PivotTable(String name)
+        {
+            return PivotTable(name);
+        }
+        public XLPivotTable PivotTable(String name)
+        {
+            return (XLPivotTable)PivotTables.PivotTable(name);
+        }
+        public IXLPivotTables PivotTables { get; private set; }
     }
 }
\ No newline at end of file
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/ClosedXML_Examples.csproj b/ClosedXML/ClosedXML/ClosedXML_Examples/ClosedXML_Examples.csproj
index a47ed60..9aac251 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/ClosedXML_Examples.csproj
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/ClosedXML_Examples.csproj
@@ -148,6 +148,7 @@
     <Compile Include="PageSetup\TwoPages.cs" />
     <Compile Include="Misc\ShowCase.cs" />
     <Compile Include="ExampleHelper.cs" />
+    <Compile Include="PivotTables\PivotTables.cs" />
     <Compile Include="Ranges\CurrentRowColumn.cs" />
     <Compile Include="Ranges\WalkingRanges.cs" />
     <Compile Include="Ranges\SortExample.cs" />
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/PivotTables/PivotTables.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/PivotTables/PivotTables.cs
new file mode 100644
index 0000000..8990336
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/PivotTables/PivotTables.cs
@@ -0,0 +1,31 @@
+using System;
+using ClosedXML.Excel;
+
+namespace ClosedXML_Examples
+{
+    public class PivotTables
+    {
+        public void Create(String filePath)
+        {
+            var wb = new XLWorkbook();
+            var ws = wb.Worksheets.Add("Pivot Table");
+            
+            ws.Cell("A1").Value = "Category";
+            ws.Cell("A2").Value = "A";
+            ws.Cell("A3").Value = "B";
+            ws.Cell("A4").Value = "B";
+            ws.Cell("B1").Value = "Number";
+            ws.Cell("B2").Value = 100;
+            ws.Cell("B3").Value = 150;
+            ws.Cell("B4").Value = 75;
+
+            var pivotTable = ws.Range("A1:B4").CreatePivotTable(ws.Cell("D1"));
+            pivotTable.RowLabels.Add("Category");
+            pivotTable.Values.Add("Number")
+                .ShowAsPctFrom("Category").And("A")
+                .NumberFormat.Format = "0%";
+
+            wb.SaveAs(filePath);
+        }
+    }
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML_Net3.5/ClosedXML_Net3.5.csproj b/ClosedXML/ClosedXML/ClosedXML_Net3.5/ClosedXML_Net3.5.csproj
index 7ff3d6b..0722c8e 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Net3.5/ClosedXML_Net3.5.csproj
+++ b/ClosedXML/ClosedXML/ClosedXML_Net3.5/ClosedXML_Net3.5.csproj
@@ -304,6 +304,54 @@
     <Compile Include="..\ClosedXML\Excel\PageSetup\XLPrintAreas.cs">
       <Link>Excel\PageSetup\XLPrintAreas.cs</Link>
     </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\IXLPivotField.cs">
+      <Link>Excel\PivotTables\IXLPivotField.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\IXLPivotFields.cs">
+      <Link>Excel\PivotTables\IXLPivotFields.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\IXLPivotTable.cs">
+      <Link>Excel\PivotTables\IXLPivotTable.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\IXLPivotTables.cs">
+      <Link>Excel\PivotTables\IXLPivotTables.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\PivotValues\IXLPivotValue.cs">
+      <Link>Excel\PivotTables\PivotValues\IXLPivotValue.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\PivotValues\IXLPivotValueCombination.cs">
+      <Link>Excel\PivotTables\PivotValues\IXLPivotValueCombination.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\PivotValues\IXLPivotValueFormat.cs">
+      <Link>Excel\PivotTables\PivotValues\IXLPivotValueFormat.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\PivotValues\IXLPivotValues.cs">
+      <Link>Excel\PivotTables\PivotValues\IXLPivotValues.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\PivotValues\XLPivotValue.cs">
+      <Link>Excel\PivotTables\PivotValues\XLPivotValue.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\PivotValues\XLPivotValueCombination.cs">
+      <Link>Excel\PivotTables\PivotValues\XLPivotValueCombination.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\PivotValues\XLPivotValueFormat.cs">
+      <Link>Excel\PivotTables\PivotValues\XLPivotValueFormat.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\PivotValues\XLPivotValues.cs">
+      <Link>Excel\PivotTables\PivotValues\XLPivotValues.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\XLPivotField.cs">
+      <Link>Excel\PivotTables\XLPivotField.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\XLPivotFields.cs">
+      <Link>Excel\PivotTables\XLPivotFields.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\XLPivotTable.cs">
+      <Link>Excel\PivotTables\XLPivotTable.cs</Link>
+    </Compile>
+    <Compile Include="..\ClosedXML\Excel\PivotTables\XLPivotTables.cs">
+      <Link>Excel\PivotTables\XLPivotTables.cs</Link>
+    </Compile>
     <Compile Include="..\ClosedXML\Excel\Ranges\IXLRange.cs">
       <Link>Excel\Ranges\IXLRange.cs</Link>
     </Compile>
@@ -439,6 +487,9 @@
     <Compile Include="..\ClosedXML\Excel\Style\IXLNumberFormat.cs">
       <Link>Excel\Style\IXLNumberFormat.cs</Link>
     </Compile>
+    <Compile Include="..\ClosedXML\Excel\Style\IXLNumberFormatBase.cs">
+      <Link>Excel\Style\IXLNumberFormatBase.cs</Link>
+    </Compile>
     <Compile Include="..\ClosedXML\Excel\Style\IXLProtection.cs">
       <Link>Excel\Style\IXLProtection.cs</Link>
     </Compile>
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj b/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj
index 31f2a4c..f53922d 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj
@@ -64,6 +64,7 @@
     <Compile Include="Examples\StylesTests.cs" />
     <Compile Include="ExcelDocsComparerTests.cs" />
     <Compile Include="Excel\Cells\XLCellTest.cs" />
+    <Compile Include="Excel\PivotTables\XLPivotTableTest.cs" />
     <Compile Include="Excel\Ranges\XLRangeBaseTest.cs" />
     <Compile Include="Utils\ExcelDocsComparer.cs" />
     <Compile Include="Examples\DeleteTests.cs" />
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Excel/PivotTables/XLPivotTableTest.cs b/ClosedXML/ClosedXML/ClosedXML_Tests/Excel/PivotTables/XLPivotTableTest.cs
new file mode 100644
index 0000000..ba9dab7
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Excel/PivotTables/XLPivotTableTest.cs
@@ -0,0 +1,20 @@
+using ClosedXML.Excel;
+using Microsoft.VisualStudio.TestTools.UnitTesting;
+using System.Linq;
+using System;
+
+namespace ClosedXML_Tests
+{
+    [TestClass()]
+    public class XLPivotTableTest
+    {
+        //[TestMethod()]
+        //public void CreateTable()
+        //{
+        //    var ws = new XLWorkbook().Worksheets.Add("Sheet1");
+            
+            
+        //}
+
+    }
+}