SharePoint Document Issues

Change a SharePoint Lookup Column to Allow Multiple Values

Adam DavisAdam Davis Nov 14, 2026 868 views

Question details

The user needs to change an existing SharePoint lookup column from a single value to multiple values.

Change a SharePoint Lookup Column to Allow 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.
Before you start

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.

Solution 1

Remove the lookup column index and enable multiple values

Use this approach when an indexed lookup column cannot be changed to accept multiple values.

1
Open library settings

In the document library, select Settings, then Library settings. Open More library settings if it appears.

2
Check the index

Under Columns, select Indexed columns. If the supplier lookup column is listed, open its index and delete the index, not the column.

3
Edit the lookup column

Return to Library settings, select the supplier lookup column under Columns, and choose Yes for Allow multiple values. Select OK to save.

4
Test the change

Select a document in the library and open its Details or properties pane. Try selecting and saving more than one supplier.

Check views after removing an index: Removing an index may affect views or filters that rely on it, especially in a large library. Existing documents may still show only their previously selected value until you edit them.
Free Microsoft Office alternative

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.

Edit documents associated with your SharePoint workflow after opening or downloading themCompatible with Microsoft Office formats, including DOCX, XLSX, and PPTXFamiliar editing interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.