diff --git a/ClosedXML/Excel/NamedRanges/XLNamedRanges.cs b/ClosedXML/Excel/NamedRanges/XLNamedRanges.cs
index 4a419bd..a7b191f 100644
--- a/ClosedXML/Excel/NamedRanges/XLNamedRanges.cs
+++ b/ClosedXML/Excel/NamedRanges/XLNamedRanges.cs
@@ -49,14 +49,31 @@
 
         public IXLNamedRange Add(String rangeName, String rangeAddress, String comment)
         {
-            var match = XLHelper.NamedRangeReferenceRegex.Match(rangeAddress);
+            return Add(rangeName, rangeAddress, comment, false);
+        }
 
-            if (!match.Success)
+        /// <summary>
+        /// Adds the specified range name.
+        /// </summary>
+        /// <param name="rangeName">Name of the range.</param>
+        /// <param name="rangeAddress">The range address.</param>
+        /// <param name="comment">The comment.</param>
+        /// <param name="acceptInvalidReferences">if set to <c>true</c> range address will not be checked for validity. Necessary when loading files as is.</param>
+        /// <returns></returns>
+        /// <exception cref="System.ArgumentException">For named ranges in the workbook scope, specify the sheet name in the reference.</exception>
+        internal IXLNamedRange Add(String rangeName, String rangeAddress, String comment, bool acceptInvalidReferences)
+        {
+            if (!acceptInvalidReferences)
             {
-                if (Worksheet == null || !XLHelper.NamedRangeReferenceRegex.Match(Worksheet.Range(rangeAddress).ToString()).Success)
-                    throw new ArgumentException("For named ranges in the workbook scope, specify the sheet name in the reference.");
-                else
-                    rangeAddress = Worksheet.Range(rangeAddress).ToString();
+                var match = XLHelper.NamedRangeReferenceRegex.Match(rangeAddress);
+
+                if (!match.Success)
+                {
+                    if (Worksheet == null || !XLHelper.NamedRangeReferenceRegex.Match(Worksheet.Range(rangeAddress).ToString()).Success)
+                        throw new ArgumentException("For named ranges in the workbook scope, specify the sheet name in the reference.");
+                    else
+                        rangeAddress = Worksheet.Range(rangeAddress).ToString();
+                }
             }
 
             var namedRange = new XLNamedRange(this, rangeName, rangeAddress, comment);
diff --git a/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/Excel/XLWorkbook_Load.cs
index 56b6849..fab0c94 100644
--- a/ClosedXML/Excel/XLWorkbook_Load.cs
+++ b/ClosedXML/Excel/XLWorkbook_Load.cs
@@ -1051,7 +1051,7 @@
                         if (localSheetId == null)
                         {
                             if (!NamedRanges.Any(nr => nr.Name == name))
-                                NamedRanges.Add(name, text, comment).Visible = visible;
+                                (NamedRanges as XLNamedRanges).Add(name, text, comment, true).Visible = visible;
                         }
                         else
                         {