Fix Missing SharePoint Grid View with Item-Level Permissions
Question details
Users need to use the 'Edit in grid view' and 'New' buttons in a SharePoint list, but these commands are unavailable when users only have edit permissions for selected items.

- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Attempting to bulk edit or create items in a SharePoint list using Grid View.
- Observed behavior
- The 'Edit in grid view' and 'New' buttons are completely hidden or disabled for users who lack list-level Edit permissions.
Verify that you have Site Administrator or Full Control permissions for the SharePoint site, as modifying list inheritance and user permissions requires elevated access.
Restore List-Level Permissions to Enable Grid View
Since SharePoint requires list-level Edit permissions for Grid View, you must remove unique item permissions and grant list-wide access to affected users.
SharePoint natively hides the 'Edit in grid view' and 'New' buttons if a user only has edit permissions for specific items. To make these features visible again, you must delete unique permissions and provide standard Edit access to the entire list. Currently, Microsoft does not provide a supported way to enable grid view while strictly restricting users to selected rows.
Open your SharePoint list, click the gear icon (Settings) in the top-right corner of the page, and select 'List settings' from the dropdown menu.
Under the 'Permissions and Management' column, click on 'Permissions for this list'.
In the Permissions ribbon, click 'Delete unique permissions' to restore inherited permissions from the parent site.
If you are not using inherited permissions, click 'Grant Permissions' in the ribbon and assign 'Edit' access to the necessary users or groups.

Looking for Flexible Data Management? Try WPS Office
If SharePoint's strict list permission limitations are hindering your team's workflow, consider managing your data tables with WPS Spreadsheet. It offers an incredibly lightweight, fully compatible environment for your data without the rigid constraints of SharePoint list views.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open Your Data: Export your SharePoint list to Excel and open the file seamlessly in WPS Spreadsheet.
- 3. Protect Specific Ranges: Go to the 'Review' tab and use 'Allow Users to Edit Ranges' to easily set up granular, item-level editing permissions without breaking view capabilities.

Frequently Asked Questions
Can I enable 'Edit in grid view' for specific items only in SharePoint?
No. SharePoint currently requires users to have Edit permissions at the list level to use the 'Edit in grid view' feature. There is no supported way to enable the grid view button while restricting users' access to only specific rows.
Why is the 'New' button missing in my SharePoint list?
The 'New' button disappears if a user does not have list-level Edit permissions. When users are only granted item-level permissions, SharePoint hides the button because they lack the authority to create new list entries at the root level.
How do I check if my SharePoint list has unique permissions?
Navigate to List Settings > Permissions for this list. If the list has unique permissions, you will see a yellow banner stating 'This list has unique permissions', and the 'Delete unique permissions' option will be visible in the top ribbon.




