Forum Discussion
Linking Active Workbook to Closed Workbook
This seems to be a topic that no one has a good answer for unless you're the only person working on the file from one device which in 2024 is unlikely. I have seen loads of other posts bringing this ...
Have you tried placing the linked file in the same folder? When you are using formula links, the easiest way to maximize the chance the link works is by ensuring both files are in the same folder.