I have two Excel files posted on SharePoint. With the master file, I've created INDEX, MATCH array formula, referencing the other file. I've entered the entire NUC, and the formula works fine while both files are open.
However, once the referenced report is closed, and Shift+Ctrl+Enter the cell, it returns #Ref! error. When I open the referenced report and do the same, it works fine.
Does anyone have any suggestions or recommendations for what I can do to fix it?