'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix SharePoint Grid View Not Saving Edits with Calculated Columns
Question details
Users are unable to save edits made to existing items in SharePoint Online list grid views that contain calculated columns.
- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Editing existing list items using the grid view mode in SharePoint Online.
- Observed behavior
- The system spins indefinitely and edits are lost when modifying existing items in a grid view that includes a calculated column, particularly observed in Microsoft Edge and Google Chrome.
Ensure you have the exact URL of the affected SharePoint list, the name of the view, and the formula used in your calculated column recorded for troubleshooting.
Open a Service Request via Microsoft 365 Admin Center
Since this is a known back-end service issue in SharePoint Online, escalating to Microsoft Support is the required solution.
This issue can occur even in newly created SharePoint lists and is caused by back-end service anomalies rather than local browser configurations. Therefore, it requires Microsoft's technical team to intervene.
Collect the affected list URL, the specific view name, the calculated column formula, your browser versions, and examples of the lost edits along with their timestamps.
Reach out to your organization's IT department or Microsoft 365 administrator, as standard users do not have the permissions to open official service requests.
Have the administrator navigate to the Microsoft 365 admin center, access the Support section, and submit a new service request containing all the gathered diagnostic details.
Looking for a Seamless and Reliable Office Alternative?
If you frequently encounter frustrating service-side syncing issues or list limitations with Microsoft 365, consider managing your extensive data locally with WPS Office. It provides a lightweight, fast, and highly compatible spreadsheet solution without complex server-side dependencies.
- 1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to complete the setup process.
- 3. Open your files: Launch WPS Spreadsheet and open your existing Microsoft Excel or exported list files directly with perfect formatting retention.
Frequently Asked Questions
Why does the SharePoint grid view spin indefinitely when editing?
This happens due to a service-side malfunction where SharePoint fails to process edits on existing items if the view contains a calculated column. The server request hangs, resulting in the indefinite loading spinner.
Can I fix this SharePoint list issue by clearing my browser cache?
No. Because this specific bug with calculated columns is a back-end issue on Microsoft's servers, clearing your browser cache or switching to an incognito window will not resolve the problem.
Is there a temporary workaround for editing SharePoint list items with calculated columns?
While waiting for Microsoft Support to resolve the service request, you can try editing list items individually through the standard 'Edit item' detail form rather than using the bulk 'Grid View' mode.
