The right Reference is like "Sheet1!$A$1:$E$10" in excel2000, But get sheet's name String is passed by find "." not "!" at the method "parseURL" in org.apache.poi.hssf.util.RangeAddress. I think it is because of difference Excel's Version? (^_^Sorry,My English is Bad^_^)
*** Bug 16835 has been marked as a duplicate of this bug. ***
Fixed as of March 6, 2003 Nightly, test case added to TestNamedRange