Data Import & Export

How to Stop Excel OneDrive Hyperlinks from Opening in a Web Browser

John Wilson Oct 7, 2026 869 views

Question details

The user wants to prevent Excel hyperlinks from launching a web browser and instead open files locally as originally intended.

How to Stop Excel OneDrive Hyperlinks from Opening in a Web Browser

Product: Excel
Device & OS: not provided
Scenario: Clicking on an Excel hyperlink that is supposed to open a local image or document.
Observed behavior: The hyperlink opens a OneDrive URL in a web browser because the target path automatically changed from a local file path to a cloud path.

Before you start

Verify that the images or documents you are linking to are physically stored on your local drive, using the 'Always keep on this device' option in your OneDrive folder if necessary.

Solution 1Recommended

Bulk Update Hyperlink Paths using Find and Replace

This is the most efficient method when you have multiple hyperlinks pointing to OneDrive URLs that need to be reverted to local paths.

By replacing the cloud URL prefix with your local machine's directory path, you can instantly correct all broken or redirected links in your spreadsheet.

Open Find and Replace

In your Excel spreadsheet, press the 'Ctrl + H' keyboard shortcut to open the Find and Replace dialog box.

Enter the OneDrive URL

In the 'Find what' field, type the base OneDrive URL or the cloud folder path that currently precedes your file names.

Enter the Local File Path

In the 'Replace with' field, enter the correct local folder path (e.g., C:\Users\Username\Documents\Images).

Execute the Replacement

Click the 'Replace All' button to update all matching cloud paths to your local directory paths at once.

Bulk Update Hyperlink Paths using Find and Replace

Verification: Click one of the updated hyperlinks to test it. It should now open the file locally using your default desktop application instead of a web browser.

Solution 2

Manually Edit Individual Hyperlinks

Best for situations where only a few specific hyperlinks have been altered to cloud URLs.

Efficient Spreadsheet Management

Easily Manage Links and Data with WPS Office

WPS Spreadsheet provides powerful data management tools, including an advanced Find and Replace feature that makes it incredibly easy to fix redirected hyperlinks and manage local file paths without syncing conflicts.

1. Open your Document: Launch WPS Spreadsheet and open the file containing the cloud hyperlinks.
2. Launch Find and Replace: Press 'Ctrl + H' to instantly bring up the Find and Replace dialog.
3. Input the Paths: Type the incorrect OneDrive URL in the 'Find' box and your correct local directory in the 'Replace' box.
4. Update All Links: Click 'Replace All' to swiftly redirect all targeted links back to your local files.

Fully compatible with Microsoft Excel (.xlsx) formatsAdvanced Find and Replace tools for rapid bulk editsSeamless local file linking without forced cloud redirectsLightweight application that runs smoothly on any PC

microsoft office alternative - wps office

Frequently Asked Questions

Why did my local Excel hyperlinks change to OneDrive URLs automatically?

When files are synced to OneDrive, Office applications often convert local file paths to cloud URLs automatically. This is designed to ensure the links continue to work when the document is shared with others or opened on different devices, but it causes the links to open in a web browser.

How do I ensure my OneDrive files are stored locally on my computer?

Open your File Explorer, navigate to your OneDrive folder, right-click the specific files or folders you are linking to, and select 'Always keep on this device'. This forces OneDrive to download a physical copy to your local hard drive.

Can I prevent Excel from changing my local link paths to relative or cloud links in the future?

Yes. You can disable automatic link updating by navigating to File > Options > Advanced, scrolling down to the General section, clicking 'Web Options', and under the Files tab, unchecking the 'Update links on save' option.

Excel & Data Problems