If your team collaborates on Microsoft Excel workbooks stored in Box, you may run into broken links when different people open files using different Microsoft 365 workflows.
This can happen when some users edit in Box’s Co-Authoring mode while others use a different workflow. Because links may be stored differently as URLs or local file paths, formulas can sometimes point to the wrong location, which may lead to errors and workflow disruptions.
Understanding Broken Excel Links in Box
What happens:
- Linked workbook formulas stop resolving and show broken‑link errors, such as update prompts, #REF!, “We can’t update some of the links in your workbook”, etc.
- Links can appear as malformed URLs.
- Ex. "https://api.box.com/Users/Username/Box/Path/To/Folder/File1.xlsx"
- Some formulas or linked ranges require both source and destination workbooks to be open to evaluate; these scenarios are especially fragile.
Why this happens:
- Co‑authoring uses URL references such as: "https://api.box.com/files/<box file ID>/WOPIServiceId_TP_Box_2/WOPIUserId_-/File.xlsx"
- Non‑coauthoring (desktop/local sync) uses local file paths: C:\Users\Username\Box\Path\To\Folder\File.xlsx
- When a workbook with external links that rely on relative or local file paths is opened in Box Co-Authoring, Excel may not convert those references into valid cloud-based URLs. Because Box Co-Authoring accesses files by unique Box file IDs instead of filesystem-relative paths, Excel may be unable to resolve links that depend on local or relative locations. As a result, linked formulas can break.
Who this affects:
- Links created in one mode may stop working after the file is edited in the other mode.
- Mixed environments, where some people use Co‑Authoring and others use desktop sync, tend to repeatedly break links as different users update files.
- Mac users as they cannot use the Windows-only custom mount workaround, making mixed-platform organizations more constrained.
Common scenarios that trigger the issue:
- Opening a file in Co‑Authoring that contains links originally created while Co‑Authoring was disabled.
- Opening a file outside Co‑Authoring that contains links created while Co‑Authoring was enabled.
- Complex formulas or linked ranges that require both source and destination workbooks to be open.
Workarounds and Recommended Workflows
The most reliable approach is to standardize the collaboration mode for any workbook that contains cross‑workbook links.
Option A — Use Co‑Authoring for everyone
- Add or provision Box as a Place in Microsoft Excel and require all collaborators to sign in to Box.
- All users will use cloud file URLs, keeping link references consistent across edits.
- Best suited when real‑time collaboration and simultaneous editing are priorities.
Option B — Disable Co-Authoring for everyone
- Use Box Drive with a consistent custom mount path so all users have identical absolute file paths to linked workbooks.
- Note: custom mounting is supported only on Windows; macOS file provider limits this workaround.
- Best when workflows depend on local absolute paths or when Co‑Authoring is not desired.
Additional practical tips
- For linked-workbook functions, keep both source and destination workbooks open so Excel can resolve dependencies.
- Where feasible, redesign to reduce cross‑workbook links (combine data into one workbook or use shared data sources instead).
- Train collaborators on how to repair broken links (see Repair Instructions below).
Repairing broken links
- Open the destination workbook (the file with the broken links).
- On the Ribbon, go to the Data tab.
- Click Workbook Links.
- Select the broken link entry, click the triple‑dot menu (…) and choose Change Source.
- Click Browse, navigate to the correct source file location (either the sync client path or the URL resource as appropriate), and click OK to update the links.
Notes:
- Restoring a previous version of the document will also restore the links as they existed in that version.
- If you cannot locate a valid source path, converting links manually or recreating them may be necessary while the file is open in the target collaboration mode.
Recommendations
- Decide at an organizational or project level whether to use Co‑Authoring or desktop sync for files that rely on workbook links.
- If using Co‑Authoring, require Box as a Place in Microsoft Excel and mandate sign‑in for all collaborators.
- If desktop sync is required (and all users are on Windows), use a consistent custom Box Drive mount path.
- Teach users the Workbook Links > Change Source flow to recover broken links quickly.
- Reevaluate workflows that depend on fragile cross‑workbook links and consider consolidation where possible.
Bottom line
Broken Excel links in Box can stem from a mismatch between Co‑Authoring URL-based references and desktop sync local-path workflows, especially when collaborators use different modes on the same linked workbooks. However, this is not the only cause: link breakage can also result from files being moved or renamed, permissions changes, or sync conflicts, even when everyone is using the same provider. The best defense is consistency: choose one collaboration mode for workbooks that rely on links, apply it across collaborators, and train users on repair steps. Where consistency is not possible, teams should be prepared to repair links manually and consider redesigning fragile linked-workbook workflows.