Calc: Indirect problem with file reference

[Jays]

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 -

Am I doing something wrong?

[erAck]

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.

[Jays]

Thanks erAck, that’s fixed it!