Indirect File Link

[shobolos]

Does any know how to make an indirect file link work using the Indirect function?

The formula is =INDIRECT("'c:\temp\[Indirect File Link.xlsx]"&$A$1&"'!A6")

With the file (Indirect File Link.xlsx) open the above formula works ok.

With the file closed I get #REF! returned.

Any help would be gratefully received.

 

[JazzSP8]

My knowledge of Excel is kind of rusty, but the last I knew you couldn't use INDIRECT with a closed workbook.

I have this bookmark saved from way back when > Daily Dose of Excel » Blog Archive » INDIRECT and closed workbooks <

You might have to have a rethink