diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs index a862a42..f0f0c40 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs @@ -704,8 +704,11 @@ if (area.Contains("[")) { String tableName = area.Substring(0, area.IndexOf("[")); - var ws = Worksheets.First(w => (w as XLWorksheet).SheetId == definedName.LocalSheetId + 1); - ws.PageSetup.PrintAreas.Add(area); + var ws = Worksheets.FirstOrDefault(w => (w as XLWorksheet).SheetId == definedName.LocalSheetId + 1); + if (ws != null) + { + ws.PageSetup.PrintAreas.Add(area); + } } else {