Use of the INDIRECT(ref_text,a1) function in Excel insists that “if ref_text refers to another workbook (an external reference), the other workbook must be open. If the source workbook is not open, INDIRECT returns the #REF! error value.”
Is there another function I can use that uses cell text as an external reference to another workbook that does not require that workbook to be open?
