Whatever, you won't be able to pull data from a closed workbook with native excel function, despite of using INDIRECT. You will have to use Harlan's PULL function or INDIRECT.EXT from morefunc.xll