Fix Microsoft Excel Links That Revert to Broken OneDrive URLs
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.
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.
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.
In Excel, select File > Save As, choose a folder outside OneDrive, and save a separate copy of the workbook.
With the local copy open, select Data > Edit Links. If the command is unavailable, check that the workbook contains external links to other workbooks.
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.
Select File > Save, close Excel, and reopen the local copy to confirm that the link still points to the corrected workbook.
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 the linked workbooks in a stable shared folder
Use this preventive approach after repairing the links to reduce future OneDrive path changes.
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. Create a local copy: In WPS Spreadsheet, select Menu > Save As and save the workbook to a folder outside OneDrive.
- 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. Replace the obsolete source: Select the broken link, choose Change Source, and browse to the linked workbook's current location.
- 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. Copy it back to OneDrive: After verification, copy the repaired workbook into OneDrive and keep the linked workbooks in their current locations.

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.




