Excel dropdown does not include new list items

Compare the new item with the list source

Save a workbook copy before changing the rule. Note which input cells should share it; a setting meant for one field may also be used elsewhere.

Identify the source type

Microsoft's list-update guide covers these different sources. Do not replace a named or formula-driven source with a guessed rectangle just because the rectangle is easier to understand.

Extend a fixed range

In the workbook copy, select an affected input cell and return to Data Validation > Settings. Click Source and select the full intended list, including the new item. Exclude the heading; it should not become a choice.

For the A2:A5 example, select A2:A6 if A6 is the only added entry. Check the first and last entries before selecting OK, then reopen that input cell's dropdown.

Use Apply these changes to all other cells with the same settings only if all those cells should receive this update. Otherwise, keep the change limited and inspect the other input cells separately.

Update a name or table at its source

For a named list, open Formulas > Name Manager, select its name, and inspect Refers to. Extend an ordinary fixed reference to the intended entries and select the checkmark to commit it. Microsoft's Name Manager guide describes this control. A name may be used beyond this dropdown, so inspect its purpose before editing it. Leave an unfamiliar formula-based definition to the workbook owner.

For a table-backed list, add the new entry at the end of the actual source table. Microsoft's dropdown creation guide explains that associated dropdowns update as their table source changes. Confirm that the new item belongs to that table rather than a separate list with a similar heading.

If the control is missing or disabled

If no arrow appears, check Allow: List and In-cell dropdown in Settings. Finish any cell edit first. A protected worksheet can prevent validation changes; ask its owner for the permitted edit instead of removing protection from a shared workbook without agreement.

Changing a rule does not automatically flag every invalid value already stored in the cells. Microsoft's validation details cover Circle Invalid Data if you need to inspect existing entries. Review those entries separately rather than overwriting them with the new choice.

If the arrow is in a column heading and hides rows, it is a filter. Use the missing filtered-row checks for that problem. For an unresolved validation list, use the support links in Microsoft's update guide with an anonymized sample and the Source expression.