SharePoint Document Issues

Fix SharePoint Hyperlink Columns Showing Invalid URLs in Grid View

Huma Ashraf Ch Sep 28, 2026 869 views

Question details

Users are encountering issues where SharePoint Online hyperlink columns become unclickable, revert to relative paths, or display invalid URL errors when modified in Grid View.

Fix SharePoint Hyperlink Columns Showing Invalid URL in Grid View

Product: SharePoint Online
Device & OS: not provided
Scenario: Editing list items containing URLs within the Quick Edit or Grid View interface in SharePoint Online.
Observed behavior: Hyperlink columns behave like editable text fields, complete absolute URLs automatically truncate into relative paths (e.g., /sites/SiteName), and the links cannot be clicked or are flagged as invalid.

Before you start

Ensure you have the necessary edit permissions for the SharePoint list and verify that the column settings haven't been recently altered to a plain text format by other administrators.

Solution 1Recommended

Verify and Reconfigure Column Type to Hyperlink

Ensure the affected column is explicitly configured as a Hyperlink type, as plain text columns will not render URLs as clickable links.

SharePoint lists offer various column types. If a column originally meant for links is set to 'Single line of text' or 'Multiple lines of text', SharePoint will treat the URLs as standard text strings, rendering them unclickable.

Access list settings

Navigate to your SharePoint list, click the gear icon in the top right corner to open Settings, and select 'List settings'.

Verify column type

Scroll down to the Columns section, locate the affected column, and ensure its type is explicitly set to 'Hyperlink or Picture'.

Use the hyperlink dialog

When editing the list, avoid typing directly into the cell. Instead, select the cell and use the 'Add or edit hyperlink' panel to properly input the web address and alternative text.

Verify and Reconfigure Column Type to Hyperlink

Solution 2

Edit the List Item Outside of Grid View

Bypass the Grid View bug by editing the hyperlink within the standard list item details pane to prevent automatic URL truncation.

Free Microsoft Office alternative

Looking for a Seamless Office Alternative? Try WPS Office

While SharePoint and Microsoft Office formatting bugs can occasionally disrupt your workflow, having a reliable and highly compatible document suite shouldn't be a hassle. WPS Office provides a free, lightweight alternative for managing your documents, spreadsheets, and presentations with zero learning curve.

1. Download WPS Office: Visit the official WPS website to download the free, lightweight installer for Windows, Mac, or Linux.
2. Open Microsoft Formats Directly: Double-click your existing .docx, .xlsx, or .pptx files to seamlessly edit them in WPS Office without formatting loss.
3. Collaborate Effortlessly: Save your documents to WPS Cloud to share links with your team, avoiding complex SharePoint list configurations.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx) used in SharePoint.Lightweight application footprint guaranteeing fast installation and loading times.Familiar tabbed user interface, meaning no steep learning curve for Microsoft Office users.Built-in PDF editing tools and seamless cloud integration for easy file sharing.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my SharePoint hyperlinks automatically change to relative paths (e.g., /sites/SiteName)?

This is often caused by a formatting behavior or bug within SharePoint's Grid View, which attempts to optimize internal URLs by trimming the domain name. Editing the link through the standard list item details pane usually prevents this truncation.

How can I prevent SharePoint from treating my URLs as plain text?

You must ensure your list column is configured as a 'Hyperlink or Picture' type rather than 'Single line of text' or 'Multiple lines of text'. You can verify and change this in the List Settings.

Does copying the URL from a different browser help SharePoint recognize it as a link?

In some cases, pasting URLs directly from browsers like Microsoft Edge carries over rich formatting metadata that helps SharePoint's Grid View correctly identify and format the hyperlink. However, using the 'Add or edit hyperlink' dialog is always the most reliable method.

What should I do if the grid view hyperlink issue is affecting every SharePoint list in my organization?

If the issue is widespread across all lists and began recently, it is likely a bug introduced by a Microsoft SharePoint update. Test the behavior outside of Grid View. If the problem persists globally, your SharePoint administrator should open a support ticket with Microsoft.

Document & File Issues