#REF! when reading formula from cell

Question

rvdsarr opened this issue 4 years ago · 1 comments

I am trying to read the formula from a cell which contains a reference to another workbook. Like so:

='c:[test2.xls]A1'

The extension will give me a #REF! back on the filename. Is there anything I can do about this?

Answer 1 · 2021-05-14T03:29:28.000Z

unless you have the other file, there is not much you can do. I don't believe you can access that directly from within libxl.