Index: src/java/org/apache/poi/hssf/usermodel/HSSFWorkbook.java =================================================================== --- src/java/org/apache/poi/hssf/usermodel/HSSFWorkbook.java (revision 491459) +++ src/java/org/apache/poi/hssf/usermodel/HSSFWorkbook.java (working copy) @@ -750,11 +750,14 @@ NameRecord r = null; while ((r = (NameRecord) workbook.findNextRecordBySid(NameRecord.sid, index)) != null) { - int nameRecordSheetIndex = workbook.getSheetIndexFromExternSheetIndex(r.getEqualsToIndexToSheet() - 1); - if (isRowColHeaderRecord( r ) && nameRecordSheetIndex == sheetIndex) - { - return index; - } + int indexToSheet = r.getEqualsToIndexToSheet() -1; + if(indexToSheet > -1) { //ignore "GLOBAL" name records + int nameRecordSheetIndex = workbook.getSheetIndexFromExternSheetIndex(indexToSheet); + if (isRowColHeaderRecord( r ) && nameRecordSheetIndex == sheetIndex) + { + return index; + } + } index++; }