SharePoint Document Issues

How to Fix SharePoint 2013 Cannot Change Choice Column to Checkboxes

Huma Ashraf ChHuma Ashraf Ch Oct 26, 2026 869 views

Question details

The user is unable to change an existing Choice column from a drop-down list to checkboxes in SharePoint 2013.

How to Fix SharePoint 2013 Cannot Change Choice Column to Checkboxes
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.'
Before you start

Ensure you have the necessary site administrator or list owner permissions to modify list and library settings in your SharePoint 2013 environment.

Solution 1Recommended

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.

1
Navigate to List Settings

Open your SharePoint 2013 site, go to the specific list or document library, and click on 'List Settings' or 'Library Settings' from the ribbon.

2
Check Workflows

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.

3
Inspect Views and Content Types

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.

4
Apply Checkbox Changes

Once dependencies are cleared, return to the Column Settings, select 'Checkboxes (allow multiple selections)', and click 'OK' to save your changes.

Remove Column Dependencies
Data Loss Warning: Changing column types can sometimes result in lost metadata. It is highly recommended to export your list data to Excel as a backup before modifying column structures.
Free Microsoft Office alternative

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. 1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
  2. 2. Open Exported SharePoint Data: Use WPS Spreadsheets to easily open and analyze list data exported from your SharePoint environment.
  3. 3. Edit and Save: Edit your documents with advanced formatting tools and save them in standard Microsoft formats for seamless collaboration.
Completely free and lightweight office suiteFully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Seamless integration with cloud storage and document management workflowsFamiliar tabbed user interface for a quick and easy transition
microsoft office alternative - wps office

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.