AppGarden External Link and Dependency Mapper logo AppGarden

External Link and Dependency Mapper

Links to a C: drive or a personal OneDrive: why a colleague's Excel™ file breaks

By Paul Kemp · Published

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

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.

  1. Open Data → Edit Links and read the full path of each source.
  2. Look for a drive letter that is not shared, or a folder under a user name.
  3. Check Formulas → Name Manager (Ctrl+F3) for names pointing at the same places.
  4. Select a link and use Change Source to point at a shared location, or Break Link to keep the last stored values.
  5. Copy the source file to the shared location first, then change the link, so the new path resolves.
  6. 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.