Restrict Excel Users to Editing Only Their Own Rows in OneDrive
Question details
The user needs to know whether an Excel workbook stored on OneDrive can restrict each user to editing or deleting only the rows they created.
- Product
- Microsoft Excel and OneDrive
- Device & OS
- not provided
- Scenario
- Multiple users share an Excel workbook stored on OneDrive and need to edit or delete only the rows they created without affecting other contributors.
- Observed behavior
- Excel and OneDrive do not enforce reliable row-level ownership, so users can accidentally edit or delete rows created by others.
Verify that every contributor can access their own separate workbook or a shared OneDrive folder, and confirm that Power Query is available in your installed Excel version before setting up the combination process.
Give Each User a Separate Workbook and Combine the Data with Power Query
Use this reliable workaround when each person must be limited to editing only their own rows and the combined data should remain read-only.
Excel and OneDrive do not provide true row-level permissions. A separate workbook per user keeps each person's edits isolated, while Power Query brings the files together into a single read-only compilation table.
Save a separate Excel workbook for each user in a shared OneDrive folder, and instruct users to edit only their own file.
Open a new Excel workbook, go to the Data tab, choose Get Data > From File > From Folder, and select the folder that contains the individual workbooks.
In the Power Query window, choose Combine > Combine & Load, select the relevant sheet, and confirm to load all rows into the central workbook.
After loading, save the central workbook as read-only or protect the sheet via Review > Protect Sheet so users cannot overwrite the Power Query results.
Check OneDrive Sharing and Excel Protection as a Partial Measure
Use this only to limit access to the whole workbook or to protect fixed ranges; it cannot enforce row ownership by user.
Use WPS Office as a Free Excel Alternative for Shared Spreadsheet Workflows
WPS Office offers a free, lightweight, and familiar spreadsheet environment that opens and saves Microsoft Excel .xlsx files, making it easier to manage separate contributor workbooks and central compilation files without OneDrive row-level permission limitations.
Frequently Asked Questions
Can Excel and OneDrive enforce row-level permissions based on who created the row?
No, Excel and OneDrive do not provide reliable row-level permissions for that scenario. The most practical workaround is to give each user their own workbook and use Power Query to combine the data.
How do I combine separate user workbooks into one central Excel file?
In a new Excel workbook, go to Data > Get Data > From File > From Folder, select the folder containing the user files, and use Combine & Load to import all rows.
Will making the central workbook read-only prevent users from changing the combined data?
Yes. Because Power Query refresh overwrites changes made to the combined table, the central workbook can be shared as read-only or with protected sheet ranges.
Can WPS Office work with the same .xlsx files used in Microsoft Excel?
Yes. WPS Office opens, edits, and saves .xlsx workbooks and offers a familiar ribbon interface for shared spreadsheet tasks.
Is there a way to let users edit only certain rows in a shared workbook without separate files?
There is no built-in row-level permission by creator. You can protect fixed ranges, but that does not automatically identify or restrict rows based on who created them.
