Fix Excel Hyperlinks That Drop URL Query Strings
Question details
The user needs an Excel hyperlink to open a URL while preserving its query string.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening a website from an Excel hyperlink that includes parameters such as ?xx=555.
- Observed behavior
- The link may open the website's home page instead of preserving the query parameters.
Copy the complete intended URL, including its query string, and paste it directly into a browser's address bar. Check whether the destination retains the parameters or redirects even without Excel.
Check the hyperlink address and formula
Use this method to find missing query parameters or incorrect characters in the stored link.
Right-click the hyperlink cell and select Edit Hyperlink. Check that the Address field contains the full URL, including the question mark and query parameters.
If the cell uses a formula, select it and inspect the formula bar. For example, use =HYPERLINK("https://example.com/page?xx=555","Open page") and confirm that the full URL is inside the address argument.
Compare the URL with the version that works in your browser. Encode special characters within parameter values when required, but keep URL separators such as ? and & in their intended roles.
In a blank cell, use Insert > Link to create a hyperlink with the same URL, then compare it with the HYPERLINK formula by opening both.

Update Excel and test without add-ins
Use this method if the stored address is correct but Excel still opens the wrong destination.
Compare workbooks, browsers, and Office apps
Use these comparisons to narrow down whether the issue is specific to the workbook or local environment.
Work with spreadsheet hyperlinks in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet to continue working with hyperlinks and make the transition from Microsoft Office easier.

Frequently Asked Questions
How do I check whether an Excel hyperlink includes its query string?
Right-click the linked cell and select Edit Hyperlink, then inspect the Address field. For a HYPERLINK formula, select the cell and check the address argument in the formula bar.
Should I encode the question mark and ampersands in my URL?
Usually, the question mark and ampersands act as query separators and should remain in place. Encode special characters within parameter values when required, and compare the result with a URL that works directly in your browser.
How can I tell whether an Excel add-in is causing the problem?
On Windows, hold Ctrl while opening the Excel shortcut and confirm Safe Mode. If the hyperlink works there, reopen Excel normally and review add-ins under File > Options > Add-ins.
What if the URL also redirects when I paste it into a browser?
The website or a redirect may be changing the destination independently of Excel. Check the URL with the website owner or service documentation, including whether the query parameters are supported.




