SharePoint Document Issues

Fix SharePoint Choice Values Missing for Existing Items

Emma Brown Oct 10, 2026 870 views

Question details

Users report that newly added choice values in a SharePoint List column are available when creating new items but do not appear when editing existing items or using grid view.

How to Fix SharePoint Choice Values Not Appearing for Existing Items

Product: SharePoint
Device & OS: not provided
Scenario: Updating choice column values and applying them to existing list items via standard edit or grid view.
Observed behavior: New choice values are missing for existing items, and in some cases, dropdowns show duplicate or incorrect legacy options.

Before you start

Verify that you have 'Design' or 'Full Control' permissions for the SharePoint list to access and modify list settings.

Solution 1Recommended

Review List Column Settings

Ensure new values are permanently saved to the column schema rather than added as temporary fill-in options.

Often, new choices are mistakenly added as manual fill-in entries rather than permanent schema options. Updating the list settings ensures the choices apply globally to all items.

Open List Settings

Navigate to your SharePoint List, click on the gear icon (Settings) in the top-right corner, and select 'List settings'.

Select the Choice Column

Scroll down to the 'Columns' section and click on the specific choice column that is missing values.

Verify Choice Options

In the 'Type each choice on a separate line' text box, ensure all your new choices are listed correctly. Uncheck the 'Allow fill-in choices' option to prevent temporary manual entries from causing conflicts.

Save and Refresh

Click 'OK' at the bottom of the page to save the settings. Return to your list, refresh the browser, and test editing an existing item.

Solution 2

Recreate the Choice Column

If list schema corruption prevents options from showing up in grid view, recreating the column can clear the underlying cache or glitch.

Solution 3

Test Classic SharePoint View

Sometimes the modern SharePoint view experiences temporary caching issues. Toggling to the classic view can help bypass these glitches.

Free Microsoft Office alternative

Manage List Data Seamlessly with WPS Office

SharePoint list syncing issues can disrupt your data management workflow. As an alternative, WPS Spreadsheet offers a robust, offline-capable, and highly stable environment for tracking lists and collaborating without browser-based caching glitches.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
2. Export SharePoint List: In SharePoint, use the 'Export to Excel' feature to download your current list data as an Excel file.
3. Open and Edit in WPS: Open the downloaded .xlsx file in WPS Spreadsheet to manage your dropdown choices and data reliably.

Free, lightweight, and fast-loading office suite.Seamless compatibility with Microsoft Excel (.xlsx) formats.Robust data validation and dropdown list creation without syncing errors.Familiar user interface with zero learning curve for seamless migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why are my new SharePoint choices not showing up?

This usually happens due to browser caching, a temporary glitch in the SharePoint modern UI, or if the choice was inadvertently added as a manual "fill-in" value instead of being permanently saved to the column schema.

Does changing the column type to radio buttons help?

According to user reports, switching the display format from a dropdown to radio buttons generally does not resolve this specific synchronization issue between new and existing items. Recreating the column is often more effective.

What should I do if my choice dropdown shows duplicate options?

Duplicate or missing choices (like two "No" options) indicate a list schema error. You will likely need to recreate the choice column or contact your SharePoint administrator to run a backend diagnostic check.

Document & File Issues