OneDrive File Issues

How to Use Local File Paths for Excel Links in OneDrive

Ayan Masood Oct 9, 2026 869 views

Question details

The user wants to ensure Excel workbook links use local file paths instead of cloud URLs when files are stored in OneDrive.

How to Use Local File Paths for Excel Links in OneDrive

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating or updating links between Excel workbooks that are synchronized locally via OneDrive.
Observed behavior: Current OneDrive versions default to cloud paths, and the option to use Office applications to sync opened files is missing, causing linked paths to vary or break between different computers.

Before you start

Ensure your OneDrive desktop client is running and that the Excel workbooks you intend to link are fully downloaded and synchronized to your local drive.

Solution 1Recommended

Disable Cloud AutoSave and Recreate Local Links

Prevent Excel from forcing cloud-based URLs by turning off default cloud AutoSave, then recreate your workbook links using the local folder path.

Because recent versions of OneDrive removed the specific option to toggle Office application syncing, the most effective workaround is to adjust Excel's native Save options. This stops Excel from prioritizing the cloud path over your local directory.

Access Excel Save Options

Open Microsoft Excel, click on File in the top ribbon menu, and select Options at the bottom left of the screen.

Disable Default Cloud AutoSave

In the Excel Options window, select Save from the left sidebar. Uncheck the box that says 'AutoSave files stored in the Cloud by default in Excel', then click OK.

Open Files from Local OneDrive

Close any currently open workbooks. Open Windows File Explorer and navigate directly to your local OneDrive synchronization folder (e.g., C:\Users\YourName\OneDrive). Open your workbooks from this local location.

Create or Update Links

With the workbooks opened from the local drive, create your new cell links. To fix old links, go to Data > Edit Links, select the broken links, and update them to reference the local file path.

Disable Cloud AutoSave and Recreate Local Links

Link Breakage Warning: Local links may still break if the OneDrive folder is moved to a different drive, or if another user collaborating on the file has a different local OneDrive path due to a different Windows username.

Effortless Workbook Linking

Easily Link Local Spreadsheets with WPS Office

If Microsoft 365 and OneDrive's forced cloud paths disrupt your workflow, consider using WPS Office. It prioritizes local file paths, making it incredibly simple to link multiple spreadsheets together locally without cloud path interference.

1. Open WPS Spreadsheets: Launch WPS Office and open your main workbook alongside the source workbook directly from your local OneDrive folder.
2. Initiate the Formula: Type the equals sign (=) in the desired cell of your main workbook where you want the linked data to appear.
3. Select Source Data: Switch to the source workbook window and click the specific cell or range of cells you wish to link.
4. Complete the Link: Press Enter. WPS Spreadsheets will automatically generate a reliable, local file path link between the two documents.

Fully compatible with Microsoft Excel (.xlsx) file formatsSeamlessly creates stable local file links without forcing cloud URLsLightweight application that bypasses unwanted cloud sync settingsFree to download with a familiar user interface

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel links keep changing to a SharePoint or OneDrive URL?

Microsoft 365 defaults to saving and linking via the cloud when AutoSave is enabled for files stored in OneDrive. This automatically converts local directory paths to cloud URLs to facilitate real-time co-authoring.

Can I permanently stop OneDrive from converting local links to web links?

You can minimize this by turning off 'AutoSave files stored in the Cloud by default' in Excel's Save options. Additionally, always open the documents via your local File Explorer rather than Excel's 'Recent Files' list, which often defaults to the cloud version.

How do I fix Excel links that are already broken due to varying local paths?

Open your workbook, navigate to the Data tab, and click Edit Links. Select the broken links from the list, click Change Source, and manually browse to the correct local OneDrive folder on your current PC to reselect the source workbook.

Will local Excel links work for other users sharing my OneDrive folder?

Local links will only work for collaborators if their local OneDrive sync folder is located at the exact same directory path as yours (e.g., C:\OneDrive). Because Windows usually includes the username in the path (e.g., C:\Users\Username\OneDrive), local links often break for other users.

Document & File Issues