How to Fix Disabled SharePoint Quick Edit or Grid View Button
Question details
The Quick Edit or Edit in grid view button is greyed out in a SharePoint list or library, despite users having Contribute permissions granted through a domain group and the feature being enabled in settings.
- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Users are trying to perform bulk edits on a SharePoint list or document library using the grid view functionality.
- Observed behavior
- The Edit in grid view (or Quick Edit) button is present in the command bar but is disabled and unclickable for specific users.
Verify that you have Site Owner or Full Control privileges on the SharePoint site to accurately check list settings, user permissions, and perform isolation tests.
Verify List Settings and Isolate Permission Issues
Use the built-in permission checker to confirm effective permissions and test a new list to isolate the root cause.
Even when domain groups are granted Contribute access, conflicting permission levels at the site or list level can sometimes override group settings. Verifying individual effective permissions ensures the user truly has the required access.
Navigate to the affected list or document library. Click the Gear icon, select List Settings (or Library Settings), then click 'Permissions for this list'. Select 'Check Permissions' in the ribbon, enter an affected user's name, and click 'Check Now' to verify they have Contribute or Edit rights.
Create a brand new SharePoint list on the same site. Navigate to it and check if the 'Edit in grid view' button is active. If it works in the new list, the issue is specific to the original list's views, columns, or corrupted settings.
Review the active views on the original list. Group-by limitations, specific custom formatting, or complex column types might be disabling the grid view functionality. Try switching to a standard 'All Items' view without grouping.
Escalate to Microsoft 365 Administrator
If settings are correct but multiple users in a domain group remain affected, backend support may be required.
Looking for a Lightweight Office Suite? Try WPS Office
While SharePoint configuration requires specific administrator tools, editing your daily documents shouldn't be complicated. WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office for all your word processing, spreadsheet, and presentation needs.
- 1. Download the installer: Visit the official WPS Office website and click the Free Download button.
- 2. Install WPS Office: Run the downloaded executable file and follow the straightforward on-screen instructions.
- 3. Open your files: Launch WPS Office to immediately open, edit, and collaborate on your existing Office documents.
Frequently Asked Questions
Why is the Quick Edit button entirely missing from my SharePoint list?
The feature might be completely disabled at the list level. Go to List Settings > Advanced settings, scroll down to 'Quick property editing', and ensure it is set to 'Yes'.
Can certain columns disable the 'Edit in grid view' functionality?
Yes. If your list contains specific complex column types, or if your default view uses 'Group By' with certain limitations, SharePoint may automatically disable the grid view option to prevent data corruption.
Why does grid view work for Site Owners but not Contributors?
If Contributors cannot use grid view but Owners can, it often indicates an issue with how effective permissions are resolving. The domain group may lack proper Read access at the site level, which is sometimes required alongside list-level Contribute access.
