diff --git a/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/Excel/XLWorkbook_Load.cs
index 76c27ec..22dc280 100644
--- a/ClosedXML/Excel/XLWorkbook_Load.cs
+++ b/ClosedXML/Excel/XLWorkbook_Load.cs
@@ -922,7 +922,7 @@
         {
             if (workbook.DefinedNames == null) return;
 
-            foreach (DefinedName definedName in workbook.DefinedNames)
+            foreach (var definedName in workbook.DefinedNames.OfType<DefinedName>())
             {
                 var name = definedName.Name;
                 var visible = true;
@@ -934,7 +934,6 @@
                     {
                         if (area.Contains("["))
                         {
-                            String tableName = area.Substring(0, area.IndexOf("["));
                             var ws = Worksheets.FirstOrDefault(w => (w as XLWorksheet).SheetId == definedName.LocalSheetId + 1);
                             if (ws != null)
                             {
@@ -1007,7 +1006,8 @@
             var areas = validateDefinedNames(definedName.Text.Split(','));
             foreach (var item in areas)
             {
-                SetColumnsOrRowsToRepeat(item);
+                if (this.Range(item) != null)
+                    SetColumnsOrRowsToRepeat(item);
             }
         }
 
diff --git a/ClosedXML_Tests/ClosedXML_Tests.csproj b/ClosedXML_Tests/ClosedXML_Tests.csproj
index 47cca6a..56aac5c 100644
--- a/ClosedXML_Tests/ClosedXML_Tests.csproj
+++ b/ClosedXML_Tests/ClosedXML_Tests.csproj
@@ -261,6 +261,7 @@
     <EmbeddedResource Include="Resource\Misc\EmptyTable.xlsx" />
     <EmbeddedResource Include="Resource\Misc\FileWithDefaultStyleNameNotInEnglish.xlsx" />
     <EmbeddedResource Include="Resource\Misc\FileWithMismatchSheetIdAndRelId.xlsx" />
+    <EmbeddedResource Include="Resource\Misc\InvalidPrintTitles.xlsx" />
     <EmbeddedResource Include="Resource\Misc\LoadFileWithCustomSheetViews.xlsx" />
     <EmbeddedResource Include="Resource\Misc\LoadPivotTables.xlsx" />
     <EmbeddedResource Include="Resource\Misc\LibreOfficeFileWithDates.xlsx" />
diff --git a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs
index 5cff8ca..9f6a359 100644
--- a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs
+++ b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs
@@ -21,7 +21,8 @@
                 @"Misc\EmptyTable.xlsx",
                 @"Misc\LoadPivotTables.xlsx",
                 @"Misc\LoadFileWithCustomSheetViews.xlsx",
-                @"Misc\LoadSheetsWithCommas.xlsx"
+                @"Misc\LoadSheetsWithCommas.xlsx",
+                @"Misc\InvalidPrintTitles.xlsx"
             };
 
             foreach (var file in files)
diff --git a/ClosedXML_Tests/Resource/Misc/InvalidPrintTitles.xlsx b/ClosedXML_Tests/Resource/Misc/InvalidPrintTitles.xlsx
new file mode 100644
index 0000000..86bef09
--- /dev/null
+++ b/ClosedXML_Tests/Resource/Misc/InvalidPrintTitles.xlsx
Binary files differ