OneDrive File Issues

Fix Microsoft Excel Links That Revert to Broken OneDrive URLs

Olivia MillerOlivia Miller Nov 12, 2026 869 views

Question details

The user needs to repair external workbook links that keep reverting to obsolete or broken OneDrive URLs after files are moved.

Product
Microsoft Excel with OneDrive
Device & OS
not provided
Scenario
An Excel workbook and its linked files have been moved between OneDrive, a Mac, or another storage location, and the user needs to update the link sources permanently.
Observed behavior
After the workbook is saved, Excel restores an old HTTP or OneDrive source instead of retaining the repaired file location.
Before you start

Locate every linked workbook in its new storage location and confirm that you can open it. Then save a working copy of the main workbook outside the OneDrive-synced folder before changing any link sources.

Solution 1Recommended

Repair the OneDrive links from a local Excel copy

Use this method when Excel keeps restoring an obsolete OneDrive URL after the workbook has been moved.

Editing links while the workbook is inside a syncing folder can cause Excel to reuse an older cloud path. A local copy gives the updated source path a chance to be saved before the file is synchronized again.

1
Save a local copy

In Excel, select File > Save As, choose a folder outside OneDrive, and save a separate copy of the workbook.

2
Open the link manager

With the local copy open, select Data > Edit Links. If the command is unavailable, check that the workbook contains external links to other workbooks.

3
Change the broken source

In the Edit Links dialog, select the obsolete link, choose Change Source, browse to the linked workbook in its new location, and select the file.

4
Save and close the local file

Select File > Save, close Excel, and reopen the local copy to confirm that the link still points to the corrected workbook.

5
Return the repaired file to OneDrive

Copy the verified local workbook back to the intended OneDrive folder, replace the old copy if needed, and avoid moving or renaming the linked workbooks afterward.

Keep linked files stable: All linked workbooks must remain available at their repaired locations. Moving or renaming them later can create another broken external reference.

Repair OneDrive workbook links in WPS Spreadsheet

WPS Spreadsheet can open an Excel workbook, let you review and update external link sources, and save the repaired file in Excel-compatible format. Work on a local copy first, then move the verified workbook back to OneDrive.

  1. 1. Create a local copy: In WPS Spreadsheet, select Menu > Save As and save the workbook to a folder outside OneDrive.
  2. 2. Open the external-link tools: Open the local copy and select the Data tab, then choose Edit Links if the workbook contains external workbook references.
  3. 3. Replace the obsolete source: Select the broken link, choose Change Source, and browse to the linked workbook's current location.
  4. 4. Verify and save: Save and close the local workbook, reopen it to test the linked values, and confirm that the source remains correct.
  5. 5. Copy it back to OneDrive: After verification, copy the repaired workbook into OneDrive and keep the linked workbooks in their current locations.
Update external workbook sources before returning the file to a synced OneDrive folderUse a familiar spreadsheet interface with lightweight local editingOpen and save Microsoft Excel .xlsx workbooks with broad format compatibilityKeep linked files organized in stable folders to reduce broken references
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel restore an old OneDrive URL after I change the link?

Excel can retain the original external source when the workbook is edited inside a syncing folder or when the linked files were moved. Save the workbook outside OneDrive, use Data > Edit Links > Change Source, save and close it, then copy the verified file back.

How do I change an external workbook link in Excel?

Open the workbook and select Data > Edit Links. Select the broken source, choose Change Source, browse to the correct linked workbook, and then save the file.

Can I repair the links while the workbook remains in OneDrive?

You can try, but syncing may cause Excel to restore the obsolete path. A safer procedure is to save a local copy outside OneDrive, repair and verify the links there, and then copy the file back.

What should I do after repairing the OneDrive links?

Confirm that every linked workbook exists at the selected location, save and close the repaired workbook, reopen it, and test linked cells. Do not move or rename the linked files afterward.