Does this one work with workbook open?
=Indirect(Concatenate("'C:\Documents and Settings\hughel13\My Documents\["&Reports!$C$11&".xls]Sheet1'!R2:R138"))
What errors are you getting?
Are you sure cell Reports!$C$11 contains exactly matching text as the sheet name you want to link to.. check for spaces, etc...
Bookmarks