'%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)
How to Fix Microsoft Lists Opening in Classic SharePoint and Grid View Failing
Question details
Microsoft Lists defaults to the classic SharePoint experience instead of the modern one, and the Edit in Grid view becomes unavailable, freezes, or displays errors when filters or grouping are applied.
- Product
- Microsoft Lists and SharePoint
- Device & OS
- not provided
- Scenario
- Viewing and editing list data using the modern SharePoint experience and Edit in Grid view.
- Observed behavior
- The list continuously opens in the old SharePoint experience even after selecting the new experience. Additionally, the Edit in Grid view fails, freezes, or throws errors when utilizing Group by or complex filters.
Ensure you have saved any pending data entries in other tabs and verify that your browser is updated to the latest version before modifying list settings.
Verify List View Configurations and Remove Grouping
Grid view is often disabled when complex filters or 'Group by' settings are active. Temporarily disabling them can restore functionality.
Certain view configurations in SharePoint natively conflict with the Edit in Grid view functionality. Testing the list without these settings helps isolate the cause.
Navigate to your Microsoft List and click the View options menu located in the top right corner of the command bar.
Modify the view to ensure that no columns are actively using the 'Group by' feature, as this frequently disables the Edit in Grid view option.
Remove any active, complex filters from your columns and save the view to test if the Edit in Grid view button becomes functional again.
Force Modern Experience and Clear Browser Cache
Corrupted browser cache or incorrect advanced settings can force SharePoint to revert to the classic experience.
Contact Microsoft 365 Support
If the issue involves backend freezing or errors beyond user settings, a support ticket is required for tenant-level investigation.
Boost Your Productivity with a Free Office Alternative
If web-based platforms like SharePoint are causing workflow interruptions, consider WPS Office for your desktop needs. It offers a free, lightweight, and highly compatible alternative for managing spreadsheets, documents, and presentations with a familiar interface and seamless offline transition.
- 1. Download WPS Office: Visit the official WPS website and click the free download button to get the installer.
- 2. Install the software: Run the downloaded installer file and follow the quick setup wizard instructions.
- 3. Open and edit files: Launch WPS Office to seamlessly open, edit, and save your existing Microsoft Office files.
Frequently Asked Questions
Why is my Microsoft List stuck in the classic SharePoint experience?
This usually happens due to the 'List experience' setting in the list's Advanced Settings being set to 'Classic experience', unsupported column types being used in the view, or outdated browser cache overriding modern rendering.
Why does 'Edit in grid view' disappear in SharePoint?
The Edit in grid view option is intentionally hidden or unsupported when certain features are active in your current view, most commonly the 'Group by' feature, complex filtering, or specific unsupported column types.
How can I force the modern experience in SharePoint lists?
Navigate to the gear icon > List Settings > Advanced settings. Scroll down to the 'List experience' section and change the selection from 'Default experience' or 'Classic experience' to 'New experience', then save your changes.
