I have imported an excel file into SharePoint 2013. One of the columns I imported was PolicyType. It is currently set as a text field but I need to change it to a choice from a menu field. I don't have this option and I noticed I also cannot delete this column either. Is there anything I can do to fix this issue?

  • Delete that column and create the new column of same name. Put the choices that are required. And don't forget to delete the "PolicyType" column from recycle bin. Oct 20, 2015 at 11:27
  • OP mentioned that he is unable to delete this column. And it is true that for some column, there is no delete option. I found this issue while deploying custom list definition from visual studio. Oct 20, 2015 at 12:14

1 Answer 1


Try following PowerShell script to delete it forcefully and be aware of after effect!

$web = Get-SPWeb -identity http://YourSiteUrl
$list = $web.Lists["Your List Name"]
$column = $list.Fields["Name of Column"]
$column.Hidden = $false
$column.ReadOnlyField = $false
$column.Allowdeletion = $true
$column.Sealed = $false

For some column, there is no delete option. Specially when you deploy custom list definition using visual studio. In that case, PowerShell has solved my issue. So try to delete you column using PowerShel and create new.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.