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.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

>