All is not lost, however. There is a free Add-in called morefunc which contains the function INDIRECT.EXT, and this will work with closed workbooks. Do a Google search for sites where you can download that from.

Hope this helps.

Pete