Index: src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java =================================================================== --- src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java (revision 680985) +++ src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java (working copy) @@ -420,7 +420,8 @@ int size = 0; for (int k = 0; k < ptg.length; k++) { - if ( ptg[k] instanceof org.apache.poi.hssf.record.formula.AreaPtg ) + if (( ptg[k] instanceof org.apache.poi.hssf.record.formula.AreaPtg ) || + ( ptg[k] instanceof org.apache.poi.hssf.record.formula.NamePtg )) { //we should set ptgClass to Ptg.CLASS_REF and explicit formula string to false ptg[k].setClass(Ptg.CLASS_REF);