INDIRECT

[Chad Portman]

I am trying to link to a another file on my work server using the INDIRECT
function. The following is my equation:

=INDIRECT("'"&B13&B14&B15&".xls]"&B16)

This ends up creating a link to a cell on a certain sheet of the workbook
based on the filepath to get to the file.

This function works no problem with the reference file open but I need to
have it work without the reference file being open. Is this possible?

 

[Sheeloo]

No. INDIRECT needs the file to be open...