Change a SharePoint Lookup Column to Allow Multiple Values
Question details
The user needs to change an existing SharePoint lookup column from a single value to multiple values.

- Product
- SharePoint document library
- Device & OS
- not provided
- Scenario
- A document library uses a supplier lookup column that needs to accept more than one value per document.
- Observed behavior
- Changing the column may fail when it is indexed or the library has other lookup or configuration issues. After the change, the dropdown may remain on Loading.
Confirm that you have permission to change library columns and identify the lookup column and its source list. Check whether the column is indexed before attempting to enable multiple values.
Remove the lookup column index and enable multiple values
Use this approach when an indexed lookup column cannot be changed to accept multiple values.
In the document library, select Settings, then Library settings. Open More library settings if it appears.
Under Columns, select Indexed columns. If the supplier lookup column is listed, open its index and delete the index, not the column.
Return to Library settings, select the supplier lookup column under Columns, and choose Yes for Allow multiple values. Select OK to save.
Select a document in the library and open its Details or properties pane. Try selecting and saving more than one supplier.
Check the content type and isolate the library configuration
Use these checks if the column setting is unavailable, saving fails, or the lookup dropdown remains on Loading.
Edit Office Documents with WPS Office
WPS Office is a free, lightweight alternative for editing documents with a familiar interface. Its Office-format support makes it easier to move existing files between applications. SharePoint lookup settings must still be managed in SharePoint.

Frequently Asked Questions
Why can't I enable multiple values for my lookup column?
An index on the lookup column can prevent the change. Open Library settings, select Indexed columns, and check whether the column has an index. Other library or content type configuration issues may also need investigation.
Will deleting the index delete the lookup column?
No. In Library settings > Indexed columns, delete the index itself rather than deleting the column. Review views and filters that rely on the index before removing it.
What if the lookup dropdown stays on Loading?
Check access to the source list, try another browser, and test a new lookup column in a new library. You can also compare the properties pane with Edit in grid view or the classic experience if available.
Will existing documents automatically get multiple lookup values?
No. Existing documents can retain their previously selected single value. Open a document's properties in the library and add other values as needed.
Can WPS Office change a SharePoint lookup column?
No. Change the lookup column in SharePoint library or content type settings. WPS Office can be used to edit compatible Office documents separately.




