Indirect to file on server #REF error

[boxsterman]

Hi all,

I'm trying to link to a several files on our server, depending how I link or view them they have two names, either:

W:\Finance\Finance NT_PCO_!current\2021\Plan\004.xlsm
or
'\\PCOFS01\Finance$\Finance\Finance NT_PCO_!current\2021\Plan\[004.xlsm]21_Plan'!$P$58

When the file is open and I reference just the file name (from cell B3) and use this, =INDIRECT("'["&B3&"]2020'!$P$58"), it works perfectly. The issue when the file is closed and I try to reference on of the two above, I get the #REF error.

Any thoughts?

Thanks,

J.

 

[Fluff]

The indirect function does not work on closed workbooks.

 

[boxsterman]

Thanks - Is there another option available that I could use on a closed workbook?

 

[Fluff]

Unfortunately, not that I'm aware of.