Calc: Indirect problem with file reference

Hi, I cannot get the Indirect function to work when I place the file reference in a cell, but I can when the file reference is passed as a parameter. Here’s it the spreadsheet showing the indirect function passed directly -

And here it is with the cell reference selected -

image description

Am I doing something wrong?

Remove the extra double quotes around the string in A100. You need them to quote a literal inline string as argument, but as cell’s text content they are passed as part of the string.

Thanks erAck, that’s fixed it!