diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTable.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTable.cs
index 2941853..3a0dc7f 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTable.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTable.cs
@@ -324,6 +324,8 @@
             Theme = XLTableTheme.TableStyleLight9;
             if (setAutofilter)
                 InitializeAutoFilter();
+
+            HeadersRow().DataType = XLCellValues.Text;
         }
 
         public void InitializeAutoFilter()
@@ -416,6 +418,8 @@
                                           RangeAddress.FirstAddress.ColumnNumber,
                                           RangeAddress.FirstAddress.FixedRow,
                                           RangeAddress.FirstAddress.FixedColumn);
+
+                    HeadersRow().DataType = XLCellValues.Text;
                 }
                 else
                 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableField.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableField.cs
index 1c4cc46..7d9b9d9 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableField.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableField.cs
@@ -20,7 +20,7 @@
             set 
             {
                 totalsRowFunction = XLTotalsRowFunction.None;
-                table.TotalsRow().Cell(Index + 1).Value = value;
+                table.TotalsRow().Cell(Index + 1).SetValue(value);
                 totalsRowLabel = value; 
             }
         }