SharePoint Document Issues

How to Fix Cannot Edit or Delete Calculated Columns in a SharePoint List

Tauseeq Magsi Sep 27, 2026 869 views

Question details

Users are unable to modify, delete, or create calculated columns in a SharePoint list that was created from an existing list.

How to Fix Cannot Edit or Delete Calculated Columns in a SharePoint List

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Modifying list settings and managing column configurations in a SharePoint list workspace.
Observed behavior: Clicking on existing calculated columns or attempting to create new ones results in an error, while all other column types function normally.

Before you start

Verify that you have Full Control or Design permissions for the SharePoint list and test the list in a private or incognito browsing window to rule out localized browser cache conflicts.

Solution 1Recommended

Recreate the List from the Original Source

Creating a fresh list from the source helps determine if the issue is a one-off corruption isolated to the currently inherited list.

Inheritance errors can sometimes occur when copying SharePoint list schemas. Re-triggering the copy process often bypasses these backend glitches.

Create a new list

Navigate to your SharePoint site's homepage, click the 'New' button, and select 'List' from the dropdown menu.

Choose the source

Select the 'From existing list' option and choose the exact same original source list you used previously.

Test column functionality

Navigate to the List Settings of the newly created list and attempt to edit, delete, or create a calculated column to see if the error persists.

Migrate data and replace

If the calculated columns work perfectly in the new list, migrate any required data from the problematic list over to the new one, then delete the faulty list.

Recreate the List from the Original Source

Data Preservation: Always ensure your data is safely backed up or completely migrated to the new working list before deleting the problematic one to prevent permanent data loss.

Solution 2

Contact Microsoft 365 Support via Tenant Administrator

If recreating the list does not resolve the calculated column errors, the issue may stem from a broader tenant-wide configuration or a SharePoint service incident.

Free Microsoft Office alternative

Looking for a Reliable Alternative to Microsoft Office?

Dealing with cloud service errors and configuration glitches in Microsoft SharePoint can interrupt your workflow. For your daily document, spreadsheet, and presentation needs, try WPS Office—a highly compatible, lightweight, and free alternative to Microsoft Office.

1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install the software: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
3. Open existing files: Double-click your existing Microsoft Office documents, spreadsheets, or presentations to open them seamlessly in WPS Office.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formatsFree, lightweight desktop application that works completely offline without web browser errorsFamiliar and intuitive user interface designed for a seamless transitionPowerful built-in PDF editing, merging, and conversion tools

microsoft office alternative - wps office

Frequently Asked Questions

Why do calculated columns throw errors only in inherited SharePoint lists?

This typically happens due to hidden schema corruption or backend reference errors that fail to carry over correctly when generating a new list from an existing template. Recreating the list often clears these isolated glitches.

Can I fix the SharePoint calculated column error by clearing my browser cache?

Generally, no. If the error persists while using private or incognito browsing modes, it indicates a server-side list configuration problem rather than a localized, client-side browser cache issue.

Will I lose my list items if I delete the problematic SharePoint list?

Yes, deleting a SharePoint list permanently removes all of its contents and configurations. You must successfully copy or migrate your list items to a newly created, fully functional list before deleting the faulty one.

Document & File Issues