The INDIRECT function will only return the result of a reference to an open file. If a workbook that the INDIRECT function is indirectly referencing is closed (not open in memory) the function will return a #REF! error.
Plugins de terceiros como PULL e INDIRECT.EXT foram escritos para contornar o problema.