Manage workbook links
Managing workbook links in Excel involves viewing, updating, and removing links to external workbooks that your current workbook depends on. Here’s a clear guide on how to manage those links:
✅ How to Manage Workbook Links in Excel
1. View All External Links
- Go to the Data tab on the Ribbon.
- Click on Edit Links (in the Connections group).
This opens the Edit Links dialog box showing all workbooks linked to your current file.
2. Update Links
- In the Edit Links dialog, select the link you want to update.
- Click Update Values to refresh the data from the source workbook.
- Or click Change Source to point the link to a different workbook/file.
3. Break Links
If you want to remove the connection and convert formulas to their current values:
- In the Edit Links dialog, select the link(s).
- Click Break Link.
- Confirm the warning (this action cannot be undone).
This replaces formulas referring to external workbooks with their current values.
4. Check Where Links Are
Sometimes links hide in:
- Formulas
- Named ranges
- Charts
- Objects (like text boxes)
- Data validation
Use Find and Replace (Ctrl + F) and search for part of the source workbook’s name or file path to locate links.
5. Prevent Workbook Links
- Avoid using direct references to external workbooks unless necessary.
- Use Power Query or Import Data features for safer data connections.