Permission & Access Issues

Restrict Editing of Assigned Rows in Excel Filtered Data

Khadija KhanKhadija Khan Nov 13, 2026 868 views

Question details

The user needs people to edit only rows assigned to them while still being able to add new rows.

Restrict Editing of Assigned Rows in Excel Filtered Data
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.
Before you start

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.

Solution 1Recommended

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.

1
Create the table

In SQL Server Management Studio, create a database table with an assignment field that identifies the user responsible for each record.

2
Configure row-level security

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.

3
Control new 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.

4
Test access

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.

Move the data to a database with row-level security
Authentication matters: The database or application must reliably identify each user. A shared database login alone cannot distinguish individual users for an identity-based policy.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesFilter and organize table data in a familiar spreadsheet interfaceMove existing spreadsheets into WPS Office without starting from scratchUse a free, lightweight office suite
microsoft office alternative - wps office

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.