SharePoint Online Lookup Column Opens the Edit Page Instead of the Item
Question details
The user needs a SharePoint Online lookup item to open with the expected hyperlink rather than an edit page where the link is missing.

- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- A user clicks a lookup column value in a modern SharePoint list view to access the linked item.
- Observed behavior
- The lookup value opens an edit page, and the expected hyperlink is not displayed when the item is opened.
Identify the affected list, lookup column, and linked item. Check whether the behavior occurs when editing an item, adding an item, or creating the lookup column so you can describe the exact scenario.
Document the lookup behavior and continue with Microsoft Support
Use this approach when the lookup value opens an edit page without the expected hyperlink and the cause is still under investigation.
Open the affected SharePoint list in its modern view, click the lookup value, and record the page that opens and whether the expected hyperlink is visible.
Note whether the issue occurs while editing an item, adding a new item, or creating the lookup column. Record the list and column names and the steps taken before clicking the lookup value.
Take screenshots of the lookup value and the page that opens, including the area where you expect to see the hyperlink.
Send the screenshots, reproduction steps, and support ticket number to Microsoft Premier Support through the existing case or a private support channel.

Work with Office documents in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents. Its format compatibility makes moving existing files easier, though it does not fix SharePoint lookup columns.

Frequently Asked Questions
Why does my SharePoint lookup value open an edit page?
The cause is not established in this case. Record the steps you take in the modern list view and share the behavior with Microsoft Support for investigation.
What should I send Microsoft Support about the missing hyperlink?
Through your existing support case or a private support channel, send the ticket number, screenshots, and precise reproduction steps. Include whether the issue occurs while editing an item, adding an item, or creating the lookup column.
Is there a confirmed fix for this lookup column issue?
No confirmed fix is provided in the source record. Continue working with Microsoft Support and refer to your support case for updates.
Can WPS Office fix a SharePoint lookup column?
No. The lookup column behavior belongs to SharePoint Online. WPS Office can help you work with compatible Office documents, but it does not change SharePoint list navigation.




