INDIRECT() does not work on closed workbooks

For something like that, you will need to install the Morefunc add-in