Fix a SharePoint Multiple-Choice Column That Does Not Save Values
Question details
Determine why selections in a SharePoint document library multiple-choice column do not persist after saving.

- Product
- SharePoint document library
- Device & OS
- not provided
- Scenario
- Users select values in a multiple-choice column through Quick Edit, the modern properties pane, or classic view.
- Observed behavior
- The selected values disappear after saving, sometimes intermittently and without an error, across multiple users and browsers.
Identify the affected library and column, then confirm that you have permission to edit library settings. Note the affected content type and whether the behavior occurs in both grid view and the properties pane.
Test the choice column and review library settings
Use a separate library to determine whether the issue is specific to the original library or its configuration.
From the SharePoint site, open Site contents and select New > Document library. Add a test document to the new library.
In the test library, select Add column > Choice. Enter the same choices as the affected column and enable multiple selections in the column settings.
Select the test document, open its details pane, choose multiple values, and save if prompted. Refresh the library page and check whether the selections remain; repeat using Edit in grid view.
In the affected library, open Settings > Library settings and select the column under Columns. Check its choices and multiple-selection setting, then review content types, validation settings, and permissions for affected users.
Review any Power Automate flows or other processes connected to the library that update document properties. Check whether they clear or overwrite the choice field after an edit.

Replace the choice column with managed metadata
Use this workaround if the choice column continues to lose values and managed metadata is available in your SharePoint environment.
Edit Office documents with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Microsoft Office formats, making it easy to move existing documents into your workflow. It does not fix SharePoint library column settings.

Frequently Asked Questions
Why do my SharePoint choice values disappear after I save?
The cause is not always visible. Test a similar column in a new library, then review the original column's settings, content types, permissions, validation, and any automation that updates document properties.
How can I check whether a choice column allows multiple selections?
Open the library's Settings > Library settings, select the column under Columns, and check its multiple-selection setting. The available labels may vary by SharePoint version.
Will recreating the choice column always fix the problem?
No. The issue can persist after a column is recreated. If testing and configuration checks do not resolve it, consider a managed metadata column or another suitable field type.
Can a managed metadata column accept more than one value?
Yes, when multiple values are enabled for the column. Create the column from Add column > Managed metadata, select a term set, and configure it to allow multiple values.
Does WPS Office repair SharePoint column settings?
No. SharePoint library columns must be configured and troubleshooted in SharePoint. WPS Office can be used separately to open and edit compatible Office documents.




