SharePoint Document Issues

How to Fix SharePoint Lookup Column Source Cannot Be Changed

Tauseeq MagsiTauseeq Magsi Nov 3, 2026 868 views

Question details

Users are unable to edit or update the source list of an existing SharePoint lookup column after migrating a list.

How to Fix SharePoint Lookup Column Source Cannot Be Changed
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Migrating a SharePoint list using the 'Save as Template' feature results in a lookup column pointing to the wrong list or library.
Observed behavior
SharePoint does not provide a standard UI option or built-in setting to edit or change the source list of an existing lookup column.
Before you start

Before deleting any existing columns, export your current SharePoint list to Excel to ensure you have a backup of the mapped lookup data, as removing the column will erase these values from existing items.

Solution 1Recommended

Delete and Recreate the Lookup Column

Since SharePoint does not allow editing an existing lookup column's source list, the most reliable and supported method is to delete the faulty column and create a new one pointing to the correct destination.

When a list is migrated using the 'Save as Template' feature, its lookup columns often retain the unique identifier (GUID) of the original source list rather than dynamically updating to a new one. Because this binding happens at the architecture level, it cannot be simply rerouted through standard settings.

1
Navigate to List Settings

Open your SharePoint list, click the gear icon (Settings) in the top-right corner of the screen, and select 'List settings'.

2
Delete the incorrect column

Scroll down to the 'Columns' section and click on the name of the incorrect lookup column. Scroll to the very bottom of the Edit Column page and click the 'Delete' button. Confirm the deletion when prompted.

3
Create a new lookup column

Return to the List Settings page and click 'Create column'. Enter an appropriate name for the new column and select 'Lookup (information already on this site)' as the column type.

4
Configure the correct source

In the 'Get information from' dropdown menu, carefully select the correct target SharePoint list or library. Choose the specific column you want to display, adjust any additional settings, and click 'OK' to save.

Delete and Recreate the Lookup Column
Submit Feature Feedback: You can submit feedback directly to Microsoft requesting a native feature to allow editable lookup sources in future SharePoint updates.
Free Microsoft Office alternative

Looking for a Hassle-Free Office Suite?

While SharePoint offers complex enterprise list management, dealing with restrictive configurations and migration issues can be frustrating. If you need a highly compatible, free, and easy-to-use alternative to Microsoft Office for your daily document and spreadsheet tasks, WPS Office is the perfect choice.

  1. 1. Download the installer: Visit the official WPS Office website and click the free download button for your operating system.
  2. 2. Install the software: Run the downloaded installation file and follow the simple on-screen instructions to complete the setup.
  3. 3. Open your documents: Launch WPS Office to easily open, edit, and save your existing Word, Excel, and PowerPoint files without any formatting loss.
Completely free and lightweight office suite for PC and mobile.Seamless format compatibility with Microsoft Excel (.xlsx) for managing exported list data.Familiar tabbed interface requiring zero learning curve for Office users.Built-in cloud sync for easy document collaboration without complex setup.
microsoft office alternative - wps office

Frequently Asked Questions

Why do lookup columns reference the wrong list after saving as a template?

In SharePoint, lookup columns are hard-bound to the specific List ID (a unique GUID) of the source list, not just its name. When you migrate a list using 'Save as Template', the newly generated list retains the old GUID in its lookup column settings, causing it to point back to the original or an incorrect list.

Is there any workaround to edit the lookup source without deleting the column?

In modern SharePoint Online environments, there is no standard user interface to change the source list of an existing lookup column. While advanced users previously modified the schema XML via SharePoint Designer in older versions, this method is no longer supported or recommended. Deleting and recreating the column remains the official solution.

How can I preserve my existing list data when recreating a lookup column?

Before deleting the incorrect lookup column, export your entire SharePoint list to an Excel spreadsheet or CSV file. After you create the new lookup column and configure it to the correct source, you can use SharePoint's 'Edit in grid view' feature to quickly paste the preserved values back into the new column.