How to Fix Excel Hyperlinks Opening OneDrive Files Incorrectly
Question details
Users need to fix Excel hyperlinks pointing to OneDrive files that open incorrectly, such as displaying as folders or failing on mobile apps due to local paths.
- Product
- Microsoft Excel, OneDrive
- Device & OS
- not provided
- Scenario
- Creating or clicking hyperlinks in an Excel workbook that link to files hosted on OneDrive.
- Observed behavior
- Hyperlinks open files as folders, display them incorrectly in the browser, or show unusable local paths that do not work on mobile apps or for other shared users.
Ensure you have an active internet connection and are signed into your OneDrive account through a web browser to generate the correct sharing links.
Replace Local File Paths with OneDrive Web Sharing Links
Use this method to ensure your Excel hyperlinks work seamlessly across all devices and for all users sharing the file.
When you create a hyperlink by browsing local files in Excel, it often inserts a local directory path. This path is unique to your computer and will fail when the file is opened on a mobile device or by another user.
Open a web browser and navigate to the OneDrive website, then log in to your account.
Find the specific file you want to link to within your OneDrive folders.
Click the 'Share' icon next to the file (or right-click and select 'Share'), choose your desired access permissions, and click 'Copy link'.
Open your Excel spreadsheet, right-click the cell containing the broken hyperlink, select 'Edit Hyperlink', and paste the copied URL into the 'Address' field.
Experience Seamless Cloud File Linking with WPS Office
Tired of broken links and complex local path issues in Microsoft Excel? WPS Office provides a free, lightweight, and highly compatible alternative. Enjoy seamless hyperlink management, excellent cloud integration, and a familiar user interface without the hassle.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open your workbook: Launch WPS Spreadsheet and open your existing Excel workbook (.xlsx).
- 3. Insert cloud links easily: Select any cell, press Ctrl+K to open the hyperlink dialog, and paste your cloud sharing link directly.
Frequently Asked Questions
Why do my Excel hyperlinks to OneDrive files open as folders?
This usually happens when the hyperlink points to the parent directory path on your local drive instead of the specific file's web URL. Updating the link to a direct OneDrive sharing link resolves this.
Can I use a relative path in Excel for shared OneDrive folders?
Excel does not natively support relative paths for local OneDrive folders across different users because the base path varies by user. You must use the cloud sharing link for universal access.
Why do my Excel hyperlinks stop working on the mobile app?
Mobile apps cannot access local PC file systems. If your Excel hyperlink uses a local OneDrive path, it will fail on mobile. Replacing it with an 'https://' sharing link ensures mobile compatibility.
