Small suggestion: Before that line add a line that dumps $ref_excel (and the other reference vars) with Data::Dumper. Compare the first (successfully opened) sheet with the one that failed