How to Restrict Excel Online Row Editing by Logged-In User ID
Question details
The user needs an Excel Online workbook to allow each logged-in user to edit only rows associated with their own email address, rather than all rows in the shared workbook.
- Product
- Microsoft Excel Online
- Device & OS
- not provided
- Scenario
- Multiple users contribute to a shared workbook and require row-level authorization based on each user's email address or user ID.
- Observed behavior
- Standard Excel sharing permissions apply at the workbook or file level only, so users with edit access can modify other users' rows; worksheet protection or hidden rows are not a secure authorization boundary.
Before choosing a workaround, confirm whether your Microsoft 365 plan includes SharePoint Online and Power Apps, and verify that each workbook row contains a reliable owner email or user ID column. If the owner column is missing or inconsistent, no row-level authorization method can work correctly.
Use a SharePoint List with Item-Level Permissions
Best for Microsoft 365 teams that need true row-level authorization without building custom code.
Excel Online sharing permissions only protect the whole workbook. A SharePoint List can enforce item-level permissions or be used with Power Apps so each logged-in user only sees the rows they are allowed to edit.
In SharePoint, select New > List > From Excel, upload the Excel file, and map the Excel columns to list columns, including the owner email or user ID column.
Open List settings > Advanced settings > Item-level Permissions if users will create their own rows. If rows are imported or assigned to different owners, use Power Automate to break permission inheritance per item based on the owner email column.
Share the SharePoint list or its Power Apps form with the users, then change the original Excel Online workbook to view-only or remove edit sharing links so all edits go through the list.
Build a Power Apps Form Over the List
Best when you want a controlled form experience and row filtering without hosting custom code.
Develop a Custom Authenticated Web Application
Best when you need full control, custom workflows, or are already hosting a web application.
Use WPS Office as a Free Excel Alternative When Excel Online Cannot Provide Row-Level Security
Excel Online and desktop Excel do not offer built-in row-level editing by logged-in user ID. WPS Office is a free, lightweight Office alternative that opens and saves .xlsx files with a familiar interface, so you can inspect, clean, and migrate shared workbooks into SharePoint, Power Apps, or a custom app that enforces the authorization you need.
- 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free, then install WPS Office on your device.
- 2. Open the Excel workbook: Launch WPS Spreadsheets, click File > Open, and select the .xlsx file after exporting it from Excel Online.
- 3. Review and migrate owner rows: Use WPS Spreadsheets to verify the owner email or user ID column, clean inconsistent values, and save the file as .xlsx before importing it into SharePoint or a custom authenticated app.
Frequently Asked Questions
Can Excel Online restrict editing to rows based on a user’s email address?
No. Excel Online sharing permissions are enforced at the workbook or file level. A user with edit access can typically modify any row, even if rows are hidden or the worksheet is protected with a basic password.
Does WPS Spreadsheets support row-level permissions by logged-in user ID?
WPS Office also does not provide secure row-level permissions inside a shared spreadsheet. It can open and save .xlsx files, which is useful for preparing or cleaning the owner-email column before migrating the data to SharePoint, Power Apps, or a custom app.
What is the easiest Microsoft 365 way to enforce row-level access?
Use a SharePoint List with item-level permissions or connect it to a Power Apps form. The app can filter records by the logged-in user’s email so each person sees only their assigned rows.
Can VBA or Office Scripts enforce this in Excel Online?
No. Excel Online does not run VBA, and Office Scripts run with the current user’s permissions rather than replacing workbook authorization. Neither provides a secure row-level security boundary against users with edit access.
Is hiding rows or protecting a worksheet enough?
No. Hiding and worksheet protection can reduce accidental edits but are not security controls. Users with edit access can often unhide rows or remove protection, so do not rely on them for authorization.
