Links to a C: drive or a personal OneDrive: why a colleague's Excel™ file breaks
You build a workbook that pulls a rate from a file in your Documents folder. It works for you. You send it on, and your colleague opens it to a warning and stale numbers, because the path points at a folder only your machine has.
Two links that rarely travel
- A link to a local drive path, such as one starting
C:\. It works for one person on one machine. - A link to a personal OneDrive. The owner can open it; a colleague may not be able to.
Shared locations behave differently. A link to a shared drive or team site can work for everyone who has access, though it still breaks if the folder is reorganised.
Check before sharing
These steps apply to Excel™ in Microsoft 365. Work on a copy.
- Open Data → Edit Links and read the full path of each source.
- Look for a drive letter that is not shared, or a folder under a user name.
- Check Formulas → Name Manager (Ctrl+F3) for names pointing at the same places.
- Select a link and use Change Source to point at a shared location, or Break Link to keep the last stored values.
- Copy the source file to the shared location first, then change the link, so the new path resolves.
- Open the workbook from the shared location to confirm.
Flag them automatically
External Link and Dependency Mapper reports a link to a local drive path (XL-08) and a link to a personal OneDrive (XL-09) per target file, as problems that are certain to break for someone else. Other findings cover links inside defined names (XL-02), validation lists (XL-05) and hyperlinks (XL-06). Scanning and reading the report are free, and nothing leaves your machine.
See External Link and Dependency Mapper for Excel™
Microsoft, Excel, OneDrive and Microsoft 365 are trademarks of the Microsoft group of companies. External Link and Dependency Mapper is not affiliated with or endorsed by Microsoft.