Fix Cannot Edit or Delete Calculated Column in Microsoft Lists
Question details
Users are unable to edit or delete a calculated column in Microsoft Lists because the column does not appear in the List settings.
- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Modifying list column properties or cleaning up unused columns within Microsoft Lists settings.
- Observed behavior
- The calculated column is entirely missing from the list settings menu, which prevents users from accessing its configuration page to edit the formula or delete the column.
Verify that you have the appropriate permissions (such as Full Control or Design access) to modify list settings, and ensure your internet connection is stable.
Re-index the Microsoft List
Re-indexing forces the list to update its search index and backend properties, which often restores missing columns to the settings menu.
If a column is stuck or missing due to a backend synchronization glitch, re-indexing the list is the most effective way to resolve the issue. Please note that depending on the size of your list and Microsoft's server load, this process can take up to 24 hours to fully complete.
Open your Microsoft List, click the gear icon in the top-right corner to open Settings, and select 'List settings'.
Under the General Settings category, click on 'Advanced settings'.
Scroll down to the 'Reindex List' section and click the 'Reindex List' button. Confirm the action when prompted by the system.
Try Accessing the List in a Different Browser
Use this method to rule out browser cache issues or temporary web glitches that might be hiding specific list settings.
Contact Your Microsoft 365 Administrator
If re-indexing and changing browsers fail, the issue may require a backend investigation by Microsoft Support.
Manage Data Easily with WPS Office
If you frequently work with complex data, formulas, and lists, a robust spreadsheet tool is essential. WPS Office offers a powerful, lightweight, and free alternative to Microsoft Office, ensuring seamless compatibility and a familiar interface for all your daily productivity needs.
- 1. Download the Installer: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install the Software: Run the installer and follow the quick on-screen instructions to set up WPS Office on your computer.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and easily open your existing Microsoft Excel files to continue managing your data with advanced formulas.
Frequently Asked Questions
Why would a calculated column disappear from Microsoft Lists settings?
Calculated columns can sometimes disappear from the settings menu due to temporary backend synchronization glitches, browser caching issues, or indexing delays within the Microsoft 365 tenant environment.
How long does it take for a re-indexed list to update?
Re-indexing a Microsoft List can take anywhere from a few minutes to up to 24 hours. The duration largely depends on the overall size of your list and the current processing load on Microsoft's servers.
Can I edit a calculated column without accessing List Settings?
Sometimes you can manage a column directly from the list view. Click the column header, select 'Column settings', and choose 'Edit' to change the formula or 'Delete' to remove the column. However, if the column is suffering from a backend glitch, this direct option may also be unavailable.
