How to Fix SharePoint 2013 Cannot Change Choice Column to Checkboxes
Question details
The user is unable to change an existing Choice column from a drop-down list to checkboxes in SharePoint 2013.

- Product
- SharePoint 2013
- Device & OS
- not provided
- Scenario
- Modifying list or library column settings to change the data input method from a drop-down menu to multiple-selection checkboxes.
- Observed behavior
- The system prevents the modification and displays the error message: 'The column cannot be changed to this type.'
Ensure you have the necessary site administrator or list owner permissions to modify list and library settings in your SharePoint 2013 environment.
Remove Column Dependencies
Clear any workflows, list views, or content types that might be referencing the choice column before attempting to change its type.
SharePoint 2013 locks column types if they are actively being used by other backend features to prevent data corruption. Unlinking these dependencies temporarily can resolve the restriction.
Open your SharePoint 2013 site, go to the specific list or document library, and click on 'List Settings' or 'Library Settings' from the ribbon.
Review your active SharePoint Workflows associated with this list. If any workflow references this specific choice column, temporarily remove the reference or disable the workflow.
Check your custom list views and content types. Ensure the choice column is not set as a mandatory field or heavily referenced in custom view filters.
Once dependencies are cleared, return to the Column Settings, select 'Checkboxes (allow multiple selections)', and click 'OK' to save your changes.

Consult Microsoft Q&A for SharePoint Server
Seek dedicated support for SharePoint 2013, as this specific strict limitation is tied to the older server environment rather than SharePoint Online.
Manage Your Documents Seamlessly with WPS Office
While SharePoint handles your server-side lists, WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for opening, editing, and saving your SharePoint document exports.
- 1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
- 2. Open Exported SharePoint Data: Use WPS Spreadsheets to easily open and analyze list data exported from your SharePoint environment.
- 3. Edit and Save: Edit your documents with advanced formatting tools and save them in standard Microsoft formats for seamless collaboration.

Frequently Asked Questions
Why can't I change a SharePoint choice column to checkboxes?
This usually happens when the column is actively tied to list views, workflows, or custom content types. SharePoint 2013 locks the data type to prevent structural conflicts and data corruption across these dependencies.
What is the fastest workaround for this column error?
If unlinking dependencies is too complex, the easiest workaround is to create a brand-new column formatted as checkboxes, migrate any existing data over using the datasheet view, and then delete the old drop-down choice column.
Does this choice column issue affect SharePoint Online?
This specific strict limitation and error message are primarily associated with SharePoint 2013 server environments. SharePoint Online handles column type conversions with updated backend validations, though dependencies can occasionally still cause similar prompts.




