Excel Workbook Links Point to Old Network Path: Fix

You open an Excel workbook and see a security warning about automatic update of links. When you click Edit Links, the dialog shows file references pointing to a network server or folder that no longer exists. This happens when source workbooks were moved, the network drive was remapped, or the file server name changed. This article explains how to find and update all broken external links so your formulas reference the correct current location.

Why Excel Workbook Links Break After a Network Path Change

Excel stores external references as absolute paths in formulas. When you link to a cell in another workbook, Excel records the full path like \\OldServer\Shared\Data\source.xlsx. If the server is renamed, the share is moved, or the drive letter changes, Excel cannot resolve the path. The link remains in the workbook but shows an error or prompts for update.

Links can be stored in multiple places: cell formulas, named ranges, chart data series, conditional formatting rules, data validation lists, and even in pivot table source references. A single workbook may have dozens of hidden links that all must be updated to the new path.

Excel does not automatically remap old paths. You must manually point each link to the new location. The Edit Links dialog handles cell formulas and some named ranges, but other link types require separate steps.

Steps to Update Links to the New Network Path

The following steps cover the most common locations where old paths are stored. Perform them in order to ensure all links are updated.

Update Links Using the Edit Links Dialog

1. Open the Edit Links dialog
   Go to Data > Queries & Connections > Edit Links. If the button is grayed out, the workbook has no external links.
2. Select the old link
   In the Edit Links dialog, click the source file that shows the old network path. The path appears in the Source column.
3. Click Change Source
   Browse to the new location of the source workbook. Select the file and click OK. Excel updates all formulas that reference that source.
4. Repeat for each link
   If multiple source files appear, repeat steps 2 and 3 for each one. Click Close when done.

Update Named Ranges That Contain Old Paths

1. Open Name Manager
   Go to Formulas > Name Manager.
2. Check each name for an external reference
   Look in the Refers To column for entries that include \\OldServer or the old drive letter. A name that references another workbook shows the full path.
3. Edit the name
   Select the name and click Edit. In the Refers To box, replace the old path with the new one. Click OK.
4. Repeat for all affected names
   Continue until every name with an old path is updated.

Replace Old Path in All Formulas Using Find and Replace

1. Open Find and Replace
   Press Ctrl+H to open the Replace tab.
2. Enter the old path text
   In Find what, type the old server name or path segment, for example \\OldServer\Shared. In Replace with, type the new path, for example \\NewServer\Data.
3. Set search scope
   Click Options, set Within to Workbook, and Look in to Formulas.
4. Replace all
   Click Replace All. Excel updates every formula that contains the old text. Confirm the number of replacements.

Check Charts, Conditional Formatting, and Data Validation

1. Inspect chart data sources
   Right-click a chart and select Select Data. In the Legend Entries section, click each series and check the Series values box for old paths. Edit as needed.
2. Review conditional formatting rules
   Go to Home > Conditional Formatting > Manage Rules. Examine each rule’s formula for external references. Update the path in the formula.
3. Check data validation lists
   Select a cell with data validation. Go to Data > Data Validation. In the Source box, look for a reference to an old path. Replace it with the new path.

If Links Still Point to the Old Path After Updating

Sometimes links remain even after you think you have updated everything. The following issues explain why and how to resolve them.

Hidden Links in Pivot Table Source Data

Pivot tables can reference an external source workbook. To check, right-click the pivot table, select PivotTable Options, go to the Data tab, and look at the Source data field. If it contains an old path, you must recreate the pivot table or use a macro to change the source. The easiest fix is to delete the pivot table and create a new one pointing to the correct file.

Links Stored in Defined Names That Are Not Visible in Name Manager

Some hidden names are created by Excel add-ins or legacy features. Use the Name Manager and enable the checkbox at the bottom that says Named Ranges. If you still see no external references, run a macro to list all names. Press Alt+F11, insert a module, and run this code:

Sub ListAllNames()
    Dim nm As Name
    For Each nm In ActiveWorkbook.Names
        Debug.Print nm.Name, nm.RefersTo
    Next nm
End Sub

Check the Immediate window (Ctrl+G) for names that contain the old path.

Broken Links That Cause a Security Warning on Open

If you still see a prompt to update links when opening the workbook, there may be a link in a chart sheet or embedded object. Go to Data > Edit Links and see if any source still shows. If the dialog is empty but the warning persists, the link is stored in the workbook’s link table. Use the macro below to remove orphaned links:

Sub RemoveOrphanedLinks()
    Dim link As Variant
    For Each link In ActiveWorkbook.LinkSources(xlLinkTypeExcelLinks)
        ActiveWorkbook.BreakLink Name:=link, Type:=xlLinkTypeExcelLinks
    Next link
End Sub

Edit Links Dialog vs Find and Replace: When to Use Each Method

Item	Edit Links Dialog	Find and Replace
Primary use	Update the source file for cell formulas and some named ranges	Replace text in formulas, defined names, and chart sources
Scope	Only links Excel recognizes as external references	All formulas and text strings in the workbook
Handles multiple sources	Yes, one at a time	Yes, all at once with a single replacement
Works on charts	No	Yes, if the chart source is a formula
Risk of accidental change	Low – only link sources are updated	Higher – may replace text in unintended cells
Best for	One or two source files with many formulas	Many formulas with a common old path segment

You can now update all external links in your workbook to point to the correct network path. Start with the Edit Links dialog for direct source changes, then use Name Manager and Find and Replace to catch hidden references. For stubborn links, inspect pivot tables and run a macro to list or remove orphaned connections. As an advanced tip, before moving source files, use Data > Edit Links to change the source path while the old location is still accessible — this prevents broken links from the start.