SharePoint Document Issues

How to Fix SharePoint Lookup Column Errors When Pasting in Grid View

Amos Gikunda Oct 10, 2026 868 views

Question details

Users experience a false error indicator when pasting valid data into a SharePoint list lookup column.

How to Fix SharePoint Lookup Column Errors When Pasting in Grid View

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Pasting a valid lookup value from an Excel spreadsheet into a SharePoint list using the grid view feature.
Observed behavior: The pasted value saves successfully in the backend, but SharePoint displays an error indicator in the grid view UI.

Before you start

Before proceeding, ensure that your browser is fully updated and verify that the values you are pasting from Excel exactly match the available lookup options in your SharePoint list.

Solution 1Recommended

Test the Operation in an InPrivate or Incognito Window

Using a private browsing session bypasses cached data and browser extensions that might be causing the false error indicator in SharePoint.

Browser caches or third-party extensions can sometimes interfere with SharePoint's grid view scripts, causing UI glitches even when data saves correctly. Testing in a private window helps isolate the cause.

Open a private browsing window

Launch your web browser and open an InPrivate window (Microsoft Edge) or an Incognito window (Google Chrome).

Access your SharePoint list

Switch to grid view

Click the 'Edit in grid view' button located at the top of your SharePoint list.

Paste the lookup value

Copy the required value from your Excel spreadsheet and paste it into the lookup column to check if the error indicator still appears.

Test the Operation in an InPrivate or Incognito Window

Clear Browser Cache: If the error does not appear in the private window, clearing your browser's cache and cookies will likely fix the issue permanently in your normal browsing session.

Solution 2

Collect HAR Logs and Contact Microsoft Support

If the error persists across all browsers, you will need to capture network activity logs and escalate the issue to Microsoft Support for a backend fix.

Free Microsoft Office alternative

Manage Your Spreadsheet Data Seamlessly with WPS Office

Since SharePoint grid view errors are often linked to Microsoft Office ecosystem glitches, consider using WPS Office for managing your local spreadsheets. It is a highly compatible, free alternative that ensures your data is clean and ready to be pasted into any web application.

1. Download and Install: Visit the official WPS website to download and install WPS Office for free on your PC or Mac.
2. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open your existing Microsoft Excel files without worrying about formatting loss.
3. Manage and Copy Data: Format your lookup values seamlessly in WPS Spreadsheet and copy them for pasting into your SharePoint lists.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Lightweight installation with blazing fast performanceFamiliar user interface for a zero-learning-curve migrationAdvanced data formatting tools to prevent copy-paste errors

microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint display an error when the pasted lookup value is correct?

This is typically caused by a UI rendering glitch or browser caching issue in SharePoint's 'Edit in grid view' mode. The backend database often successfully registers and saves the lookup value despite the red error indicator appearing on your screen.

Can I paste multiple cells from Excel into SharePoint grid view at once?

Yes, you can copy a range of cells in Excel and paste them into a SharePoint list while in grid view. However, ensure that the columns in Excel perfectly align with the column types and order in your SharePoint list to prevent validation errors.

What is a HAR log and why does Microsoft Support need it?

A HAR (HTTP Archive) log is a file that tracks all network requests happening between your web browser and a website's server. Microsoft Support requires this file to pinpoint exactly where the communication fails when you paste data into the SharePoint grid view.

Document & File Issues