I was wondering if it was possible to link 2 workbooks together and use the Indirect formula. I sucessfully linked the 2 but when I reopen the workbook that has the Indirect formula without opening the other, I get a #REF in the cells. Any help would be greatly appreciated.
=INDIRECT("'C:\Users\bob\Downloads\[2020 Report Inv.xlsx]1'!C"&((COLUMN()-2)*82)+14)