Restrict Editing of Assigned Rows in Excel Filtered Data
Question details
The user needs people to edit only rows assigned to them while still being able to add new rows.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A shared table contains rows assigned to different people, and users need to add records and edit only their assigned records.
- Observed behavior
- Filtering the table by a person's name does not prevent other users from accessing or editing those rows.
Identify whether access should depend on the person assigned to each row or the person who created it. List who may add records, change assignments, and administer permissions.
Move the data to a database with row-level security
Use a database when users need centrally enforced access to assigned records and permission to add new ones.
Excel's Allow Edit Ranges and worksheet protection cannot dynamically enforce permissions based on a filtered value or row authorship. A database can enforce access independently of the view shown to each user.
In SQL Server Management Studio, create a database table with an assignment field that identifies the user responsible for each record.
Create a SQL Server row-level security policy that checks the signed-in user's identity against the assignment field. Configure appropriate filter and block predicates for reading and modifying records.
Grant users the required INSERT permission and configure the security policy or application to validate assignments on new records. Limit who can change the assignment field.
Sign in with separate test accounts and try to read and edit another user's record, add a record, and change an assignment. Adjust the policy and database permissions before inviting users.

Use a SharePoint list with configured item permissions
Use a SharePoint list when your organization can manage permissions for individual records.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to move existing files. It does not provide secure, dynamic row-level permissions based on filtered assignments; use a database or configured SharePoint solution for that requirement.

Frequently Asked Questions
Can filtering by name prevent someone from editing another person's rows?
No. An Excel filter changes which rows are displayed; it does not enforce permissions. Users with access to the worksheet may be able to change or remove the filter.
Can Excel's Allow Edit Ranges restrict rows based on an Assigned To column?
No. Review > Allow Edit Ranges can define editable ranges on a protected sheet, but it does not dynamically grant access based on a row's assignee or author.
Can users add rows when access is controlled in a database?
Yes, if they have INSERT permission and the database security policy or application allows the new record. The assignment should be validated so users cannot bypass the access rules.
Does a SharePoint list view filtered to the current user secure the items?
No. A filtered view only changes what is displayed. Configure and test item-level permissions if users must be prevented from editing other people's items.




