Forum Discussion
Cannot Edit Choice Values in List that was imported from Excel?
atrain204 I think this is a bug or limitation of creating a list using excel import.
I just tried creating a list with simple excel like:
It created a list properly but same issue with the choice column settings:
Note: "Can add values manually" option is checked - this option allows fill-in choices (any text like single line of text column) in column value.
I would suggest you to raise a support ticket directly with Microsoft and report this behavior. Follow documentation: Get support - online support
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
I just encountered this same issue. It appears when you create the list from Excel and select "choices" as the column type, it does not actually create the choices. It imports your text from the excel file, but never generates the choices, thus you cannot save any changes to the column without adding the correct choices. Once you add a choice (see the "+Add Choice" button in your first screenshot), you will be able to save the changes. This is not great, but in my situation, it still is more useful than adding many records manually.
After a quick test, you are able to copy + paste a range of excel cells as the choices in your list at once, this is a huge win to circumvent the problem (I have 20 different choices for my column).