This seems to have been introduced by the fix for Bug 54400, the linkTable-code is a bit complicated and hard to get right, we obviously need another go at it.

I tried to fix this in r1595048 so that both the previous problem and this one are fixed and removing sheets correctly updates the references to external books in all cases.

Hi, I encountered the possible the same problems with poi_3.10.1 and poi_3.11.beta2.

The workbook contains: 
* sheet1: is protected; contains formulas with referred cells from the other sheets
* sheet2, 3, ...: nothing special
* all sheets: contains named ranges for printing (print area, repeated page header)

My code: just open and try to delete any sheet using wb.removeSheetAt(x).

Error: the same exception as Aleksey. (IndexOutOfBoundsException at ExternSheetRecord#getRef).

I wonder if this bug is fixed and withc version of poi containning the fix since i'm not familliar with bugzilla.

Sorry for my bad English.

Can you attach the Excel file that triggers the problem so we can reproduce it? The original file in this bug-report works fine now via a unit-test so it seems there are more cases where it fails with similar error message.

I believe that I have the same problem here. After setting the print area or set the repeat rows. I can't use the method removeSheetAt(int).

And in my code, if I remove the sheet first, and then set the print area or repeat rows, everything works well.

Sorry, I forgot the mention the POI version I'm using.
It is poi-3.10.1-2014-0818. 

And here is the exception I got:
Caused by: java.lang.IndexOutOfBoundsException: Index: 12, Size: 6
        at java.util.ArrayList.rangeCheck(ArrayList.java:571)
        at java.util.ArrayList.get(ArrayList.java:349)
        at org.apache.poi.hssf.record.ExternSheetRecord.getRef(ExternSheetRecord.java:164)
        at org.apache.poi.hssf.record.ExternSheetRecord.adjustIndex(ExternSheetRecord.java:168)
        at org.apache.poi.hssf.model.LinkTable.updateIndexToInternalSheet(LinkTable.java:419)
        at org.apache.poi.hssf.model.InternalWorkbook.removeSheet(InternalWorkbook.java:721)
        at org.apache.poi.hssf.usermodel.HSSFWorkbook.removeSheetAt(HSSFWorkbook.java:899)


In my code, I called removeSheetAt(3). And there are 6 sheets in the file. I set print area and repeat rows on the last two sheets.

Created attachment 32143 [details]
Here is a file can verify this problem

Here is the code will cause this problem
public class PoiBugTesting {

  public PoiBugTesting() {
    // TODO Auto-generated constructor stub
  }

  public static void main(String[] args) {
    try {
      HSSFWorkbook wBook = (HSSFWorkbook) WorkbookFactory.create(new FileInputStream("C:\\Users\\xxx\\Desktop\\Bug Test Book.xls"));
      HSSFSheet sheet = wBook.cloneSheet(2);
      wBook.setSheetName(3, "Clone 1");
      sheet.setRepeatingRows(CellRangeAddress.valueOf("2:3"));
      wBook.setPrintArea(3, "$A$4:$C$10");
      
      sheet = wBook.cloneSheet(2);
      wBook.setSheetName(4, "Clone 2");
      sheet.setRepeatingRows(CellRangeAddress.valueOf("2:3"));
      wBook.setPrintArea(4, "$A$4:$C$10");
      
      wBook.removeSheetAt(2);
      
      FileOutputStream fOut = new FileOutputStream("C:\\Users\\xxx\\Desktop\\test.xls");
      wBook.write(fOut);
      fOut.close();
      
    } catch (InvalidFormatException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (FileNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (IOException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }

  }

}

I now added the latest test that was provided here, it works fine with latest versions of POI. 

If you still see this problem, please check with the latest version of POI, at least 3.12-beta1 and reopen this bug with an updated test-file/unit-test or more information how the problem can be reproduced.