I've got a couple of workbooks that are linked via use of the indirect function e.g.

I've lots of cells in a workbook that contain the following formula that take this form
=INDIRECT("'[book 1.xls]sheet 1'!$a$"&A1) where the cell A1 contain the row number

I want to replace the indirect function with a direct reference as both workbooks must be open for the link to work.

Any ideas?