How to Fix SharePoint Lookup Column Source Cannot Be Changed
Question details
Users are unable to edit or update the source list of an existing SharePoint lookup column after migrating a list.

- 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 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.
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.
Open your SharePoint list, click the gear icon (Settings) in the top-right corner of the screen, and select 'List settings'.
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.
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.
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.

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. Download the installer: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install the software: Run the downloaded installation file and follow the simple on-screen instructions to complete the setup.
- 3. Open your documents: Launch WPS Office to easily open, edit, and save your existing Word, Excel, and PowerPoint files without any formatting loss.

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.




