Forum Discussion
REF Broken Formula Link Issue
This problem is more common in shared environments like network drives, OneDrive, or SharePoint, and it's often caused by Excel not being able to resolve the external file paths at the time it opens the workbook.
Here’s a breakdown how to prevent or troubleshoot it effectively:
Cause | Fix |
Cloud syncing / delay | Open files after sync completes |
Files renamed/moved | Update links manually or use relative paths |
Structured references | Replace with static range references |
Calculation before loading | Disable auto-updates or use Power Query |
Inconsistent file order | Open source workbooks first |
In the end it's pretty much the same as what the previous user "Kidd_Ip" suggested, just described a little differently 🙂.
If you can describe your storage setup (e.g. OneDrive, mapped network drive, local folder, operating system, etc.), you might be able to get a more detailed solution suggested in the forum.
My answers are voluntary and without guarantee!
Hope this will help you.