Old post I know - but if anyone is still looking the OP is asking to read Excel's cached data when a workbook link exists to a non-accessible file. PHPExcel attempts and to calculate the formula and fails.

Answer is to use the method: getOldCalculatedValue(). Example: $objWorksheet->getCell('A1')->getOldCalculatedValue()