Forum Discussion
Referencing a Closed Workbook using a cell value as the workbook name.
I need to reference specific cells in a bunch of closed workbooks. Example: ='C:\Users\UserA\Workbooks\[WorkbookA.xlsx]Sheet1'!E13 Typing the workbook names for every reference is clearly a w...
I didn't read carefully but perhaps here https://stackoverflow.com/questions/28461672/referencing-value-in-a-closed-excel-workbook-using-indirect is some workaround. Simply using INDIRECT() doesn't work with closed workbooks.