Formula Errors

How to Fix Excel for the Web Hyperlinks Between Sheets Not Working

Rana Garcia Oct 1, 2026 868 views

Question details

The user needs to fix HYPERLINK formulas that correctly link between sheets in desktop Excel but fail and return reference errors when opened in Excel for the web.

Fix Excel for the Web Hyperlinks Between Sheets Not Working

Product: Excel for the Web
Device & OS: not provided
Scenario: Using dynamic HYPERLINK formulas to navigate between different sheets within the same workbook while working in a web browser.
Observed behavior: The formulas work correctly in the desktop application but return reference errors in Excel for the web due to unsupported characters or spaces in the file name.

Before you start

Verify that the hyperlinks are functioning properly in the desktop version of Excel before troubleshooting, and ensure you have edit permissions for the file in your cloud storage.

Solution 1Recommended

Rename the Workbook to Remove Spaces or Unsupported Characters

Excel for the web can struggle to parse dynamic sheet references if the file name contains spaces or special characters. Renaming the file instantly resolves this.

When Excel for the web processes the HYPERLINK function, spaces or special characters in the workbook's file name can break the URL encoding used by the browser, resulting in a reference error. This issue does not affect the desktop version because it processes file paths differently.

Close the workbook

Ensure the Excel workbook is completely closed in your web browser to allow file modifications.

Locate the file

Navigate to the OneDrive or SharePoint folder where your Excel file is saved.

Rename the file

Right-click the Excel file and select 'Rename'.

Remove spaces

Delete any spaces or special characters from the file name. Use underscores instead if you need separators (e.g., change 'Annual Report' to 'Annual_Report').

Reopen and test

Reopen the renamed file in Excel for the web and click your hyperlink to verify it now navigates to the correct sheet.

Rename the Workbook to Remove Spaces or Unsupported Characters

Quick Fix: Removing spaces from the filename is the most reliable way to fix formula parsing errors for cross-sheet hyperlinks in the web browser version.

WPS Spreadsheet Solution

Create Reliable Cross-Sheet Hyperlinks with WPS Spreadsheet

WPS Spreadsheet handles complex workbook navigation effortlessly. You can easily insert robust hyperlinks to other sheets that will not break due to file name spaces or browser limitations, ensuring your data is always accessible.

1. Open your workbook: Launch WPS Spreadsheet and open your existing .xlsx workbook.
2. Select the cell: Click on the cell where you want to insert or edit the cross-sheet hyperlink.
3. Open the Hyperlink menu: Press the shortcut Ctrl + K, or navigate to the Insert tab on the top ribbon and click 'Hyperlink'.
4. Choose target location: In the Hyperlink dialog box, select 'Place in this Document' from the left panel.
5. Select sheet and confirm: Choose the target sheet name and type the specific cell reference, then click OK to apply the reliable hyperlink.

Seamlessly create and manage hyperlinks across multiple worksheets.Highly compatible with Microsoft Excel (.xlsx) formulas, formatting, and functions.Free and lightweight desktop software that avoids web-browser processing limitations.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel hyperlinks work on desktop but not on the web?

Excel for the web relies on browser URL encoding to process dynamic links. If your workbook file name contains spaces or unsupported special characters, the web application may fail to parse the destination URL correctly, leading to reference errors. The desktop version parses local file paths differently, so it remains unaffected.

Are there specific characters I should avoid in Excel file names?

Yes. To ensure maximum compatibility across desktop, mobile, and web applications, it is best practice to avoid spaces, hash symbols (#), percent signs (%), and ampersands (&) in your workbook file names. Using underscores (_) or camelCase is highly recommended.

How do I write a HYPERLINK formula to jump to another sheet?

You can use the HYPERLINK function combined with the pound sign (#) for internal references. For example: =HYPERLINK("#Sheet2!B5", "Go to Sheet 2"). If your sheet name contains spaces, you must enclose it in single quotes: =HYPERLINK("#'Data Sheet'!B5", "View Data").

How do I fix the 'Reference isn't valid' error in Excel?

This error generally means the destination sheet or cell was deleted, renamed, or the hyperlink syntax is invalid. Check your formula to ensure the sheet name matches exactly, verify the syntax, and confirm that the workbook file name does not contain spaces if you are working in Excel for the web.

Excel & Data Problems