Value does not fall within the expected range error in SharePoint

This SharePoint tutorial explains, how to resolve Error when trying to add a new item in the list “Value does not fall within the expected range.” which comes in SharePoint 2013/2016/Online.

Symptoms:

After SharePoint migration from SharePoint 2010 to SharePoint 2013, this issue occurred.

Unable adding / editing items in the SharePoint list, it shows the following error:

“Value does not fall within the expected range.”

Value does not fall within the expected range SharePoint

After a dozen of research in google with no luck, I found the solution as below:

  • Open SharePoint list in the browser, go to list settings from the ribbon.
  • In the SharePoint list settings page under Columns section, click on the “Indexed Columns” and you should see here a list of indexed columns.
  • Delete all the indexes from the SharePoint list.

You may like following SharePoint tutorials:

Hope this SharePoint tutorial explains to solve Value does not fall within the expected range in SharePoint.

>