I needed to open a spreadsheet with links to external files, which or may not be open. The following snippet did the trick:

my $Book = $Excel->Workbooks->Open("$EXCELFILE", TRUE);
[download]