Change a Calculated Column Formula in a Large SharePoint List
Question details
The user needs to create or change a calculated column formula in a SharePoint list with more than 20,000 items.

- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Updating a calculated column in a large SharePoint list.
- Observed behavior
- Creating or updating the calculated column fails because the operation exceeds the 5,000-item list-view threshold.
Check the exact error message and confirm that you have permission to change list settings. Identify a suitable existing column for filtering the list, such as a date or status column.
Use Indexed Columns and Filtered Views to Manage the List
Use indexed filters to work with smaller subsets of the list, then ask an administrator for help if the calculated-column change remains blocked.
Indexed columns and filtered views can help with large-list queries, but they do not remove the list-view threshold or guarantee that a calculated-column formula can be changed.
Open the list, select Settings > List settings > Indexed columns, and choose Create a new index. Select a suitable existing column and save the index.
Open a list view, choose its view menu, and select Edit current view. Under Filter, use the indexed column to limit the items displayed, then save the view.
Go to Settings > List settings, select the calculated column under Columns, and try updating its formula. To create one, select Create column and choose Calculated.
If the change or index creation still fails, provide the exact error and list details to your SharePoint administrator. An administrator can contact Microsoft Support through Help & support in the Microsoft 365 admin center.

Move Data into Smaller SharePoint Lists
Consider dividing the data when the calculated-column operation remains blocked and separate lists suit the workflow.
Review SharePoint List Exports with WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface for reviewing SharePoint data saved as an Excel workbook. Its Microsoft Office format compatibility makes it easy to move between office suites, although it cannot change SharePoint list settings or remove the threshold.

Frequently Asked Questions
Does indexing remove the 5,000-item threshold?
No. Indexes can help SharePoint process filtered queries, but they do not remove the threshold or guarantee that a calculated-column change will succeed.
Where do I create an indexed column?
Open the list and select Settings > List settings > Indexed columns > Create a new index. Choose a suitable existing column and save.
Can a filtered view fix the calculated-column error?
A filtered view can help you work with a smaller set of items, but it may not change how SharePoint processes a calculated-column schema update. If the update still fails, contact your SharePoint administrator.
Will exporting a list to Excel preserve everything?
Not necessarily. Use Export > Export to Excel from the list view, then verify the exported items and columns. Attachments, permissions, item IDs, and other list features may need separate handling.




