I have written a path to a closed workbook. However it will run the index unless the file is also open.
The file takes to long to load and needs to stay closed and allow to be searched in the background.
Please help here is the code that shows when the workbook is open.
=IFERROR(INDEX('Copy...