How to Create a Hyperlink Between Worksheets in an Excel OneDrive Workbook
Question details
The user is unable to create functional hyperlinks between different worksheets within the same Excel OneDrive workbook, encountering errors with both relative and absolute URLs.
- Product
- Microsoft Excel for Web (OneDrive)
- Device & OS
- not provided
- Scenario
- Attempting to create a hyperlink to navigate from one worksheet to another within the same workbook hosted on OneDrive.
- Observed behavior
- Both relative HYPERLINK formulas and absolute OneDrive URLs produce errors instead of successfully navigating to the target worksheet.
Ensure your Excel workbook is fully synced to OneDrive and verify that the target worksheet names do not contain unsupported special characters.
Use the Built-in Insert Link Feature in Excel for the Web
The most reliable way to link worksheets in Excel for the web is by using the native Link feature rather than typing out the HYPERLINK formula manually.
Manually typing URLs for OneDrive files can lead to absolute path errors when the file is moved or synced. Using the built-in 'Place in this Document' feature ensures the link remains relative and functional.
Click on the specific cell in your worksheet where you want the hyperlink to appear.
Go to the 'Insert' tab on the top ribbon and click on 'Link' (or press Ctrl+K on your keyboard).
In the Insert Link dialog box, select the 'Place in this document' option to view all available worksheets.
Choose the target worksheet from the list, type the specific cell reference (e.g., A1) in the reference box, and click 'OK'.
Correct the HYPERLINK Formula Syntax
If you prefer or need to use the HYPERLINK function, ensure the formula syntax correctly references internal sheets in OneDrive using the hash (#) symbol.
Create Worksheet Hyperlinks Seamlessly in WPS Spreadsheet
Avoid complex formula syntax errors by using WPS Spreadsheet. It offers an intuitive interface to link between worksheets quickly and is fully compatible with Microsoft Excel files, whether you are working locally or in the cloud.
- 1. Open your workbook: Launch WPS Spreadsheet and open your .xlsx workbook.
- 2. Access the Hyperlink tool: Right-click the cell where you want the link and select 'Hyperlink' from the context menu.
- 3. Choose internal document link: In the dialog box, click on 'Place in this document' on the left panel.
- 4. Confirm the link: Select the target worksheet from the list, enter the target cell reference, and click 'OK'.
Frequently Asked Questions
Why does my HYPERLINK formula return a 'Reference isn't valid' error?
This error typically occurs if the worksheet name is misspelled, if the sheet was deleted, or if the sheet name contains spaces but isn't enclosed in single quotes (e.g., 'My Sheet') within your formula.
Can I link to a specific cell in another worksheet?
Yes. When inserting a link or using the HYPERLINK formula, you can specify the exact cell reference (such as 'Sheet2'!B5) to jump directly to that specific cell upon clicking.
Will my internal hyperlinks still work if I download the OneDrive Excel file to my desktop?
Yes. If the hyperlinks are created correctly as internal document links (using the '#' symbol in the formula or the 'Place in this document' menu option), they will continue to function perfectly on the desktop version of Excel.
