'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Links Showing a d.docs.live.net OneDrive Path
Question details
The user needs to resolve an issue where Excel external reference links display a OneDrive cloud path (d.docs.live.net) instead of the local file path, preventing data from loading correctly.
- Product
- Microsoft Excel, OneDrive
- Device & OS
- not provided
- Scenario
- Opening an Excel workbook containing external links after moving the OneDrive installation folder to a different drive (e.g., from C: to D:).
- Observed behavior
- Excel external link formulas display a d.docs.live.net URL and fail to load data, referencing an invalid local path, a cloud location, or an inaccessible file.
Ensure that the OneDrive application is actively running on your computer, properly signed in, and completely synced before attempting to update the workbook links.
Update External References via the Edit Links Tool
Use the built-in Edit Links feature in Excel to manually repoint the workbook to the new local OneDrive directory.
When OneDrive is moved to a new drive, Excel may fail to locate the referenced workbooks automatically and default to the cloud path instead. Updating the source path manually tells Excel exactly where the files are now stored.
Open the Excel workbook containing the broken formulas. Navigate to the 'Data' tab on the ribbon and click on 'Edit Links' in the Queries & Connections group.
In the Edit Links dialog box, select the broken link from the list, then click the 'Change Source' button.
Browse to the new local OneDrive path (for example, on your D: drive), select the source workbook, and click 'OK'.
Check that the link status changes to 'OK'. Close the Edit Links dialog and save the file to apply the new local paths permanently.
Manually Update Formulas and Calculation Options
Directly edit the formulas in the cells and ensure that workbook calculations are set to automatic so values refresh properly.
Fix Broken Queries and Connections
Update the data source settings if the external data was imported using Power Query rather than standard formula links.
Experience Hassle-Free File Linking with WPS Office
Tired of dealing with proprietary cloud paths breaking your spreadsheets? WPS Office provides a robust, lightweight, and completely free alternative to Microsoft Office. It handles local and external workbook links flawlessly without forcing unnecessary cloud-based URL conversions.
- 1. Download and Install: Download WPS Office for free from the official website and run the lightweight installer.
- 2. Open Your Workbooks: Launch WPS Spreadsheet and open your existing .xlsx files directly without any formatting loss.
- 3. Manage Links Easily: Navigate to the Data tab to easily manage and update local external links using familiar tools.
Frequently Asked Questions
Why does Excel change my local path to d.docs.live.net?
Excel automatically converts local OneDrive paths to cloud URLs (d.docs.live.net) to facilitate co-authoring and easy sharing among users. When a OneDrive folder is moved or not syncing properly, this translation fails and exposes the raw cloud URL in the formula.
How do I stop Excel from using OneDrive web links?
You can turn off this behavior by opening your OneDrive Settings, navigating to the Sync and Backup (or Office) tab, and disabling the option that says 'Use Office applications to sync Office files that I open'.
What should I do if 'Edit Links' is greyed out in Excel?
If 'Edit Links' is disabled, your workbook might be protected, or the external references are embedded in objects, charts, named ranges, or data validation rules rather than direct cell formulas.
Will I lose my data if I choose to break the links?
Breaking links will convert the current formula results into static text or numbers. You will not lose the currently displayed data, but those specific cells will no longer update automatically if the original source file changes.
