Permission & Access Issues

Limit Editing to Specific Excel Cell Ranges in Microsoft Teams

Adam DavisAdam Davis Nov 14, 2026 868 views

Question details

The user wants to allow a Teams user to edit only selected ranges in a shared Excel workbook.

Limit Editing to Specific Excel Cell Ranges in Microsoft Teams
Product
Microsoft Excel and Microsoft Teams
Device & OS
not provided
Scenario
A workbook stored in Teams needs restricted worksheet editing for a shared user.
Observed behavior
The Allow Edit Ranges dialog does not accept the Teams users shown in the workbook sharing interface.
Before you start

Open the workbook from Teams in the desktop Excel app and confirm that you can edit it. Identify the cells that should remain editable and check the workbook's sharing permissions.

Solution 1Recommended

Protect the Excel worksheet and unlock permitted cells

Use worksheet protection to restrict editing to selected cells for everyone who has edit access to the workbook.

This method does not assign different editable ranges to individual Teams users. All users with edit access can edit the unlocked cells.

Excel's Allow Edit Ranges permissions use supported Windows or Active Directory accounts, not arbitrary Microsoft 365 or Teams sharing identities.

1
Open the workbook in Excel

In Teams, locate the workbook, select its More options menu, and choose to open it in the desktop Excel app.

2
Lock the worksheet cells

Select the entire worksheet, right-click, and choose Format Cells. On the Protection tab, select Locked and click OK.

3
Unlock the allowed ranges

Select the cells users may edit, then right-click and choose Format Cells. On the Protection tab, clear Locked and click OK.

4
Protect the sheet

Select Review > Protect Sheet, choose the actions users may perform, and set a password if needed. Confirm the protection settings.

5
Save and check access

Save the workbook and allow it to sync to Teams. Use Share to confirm the intended user has edit access, then test an unlocked cell and a locked cell.

Protect the Excel worksheet and unlock permitted cells
Worksheet protection is not a security boundary: Sheet protection helps prevent unwanted edits but does not provide strong security or user-specific range permissions. Use workbook sharing permissions to control who can access the file.
Free Microsoft Office alternative

Edit Excel Workbooks with WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files to make migration easier; WPS does not fix Microsoft Teams range-permission limitations.

Work with spreadsheet cells and ranges in WPS SpreadsheetsOpen and edit Microsoft Excel formats, including XLSXUse a familiar interface that makes switching from Office easierAccess a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I add a Teams user in Allow Edit Ranges?

The Excel dialog uses supported Windows or Active Directory accounts and groups, not arbitrary Microsoft 365 identities shown in the Teams sharing interface.

Does unlocking a range allow only one Teams user to edit it?

No. After you use Review > Protect Sheet, the unlocked range is editable by anyone who has edit access to the workbook. It is not restricted to one Teams user.

Can a user edit unlocked cells without workbook edit access?

No. The user also needs edit permission for the workbook. Check the file's Share settings in Teams or Excel.

Does protecting a worksheet secure confidential data?

No. Worksheet protection is intended to prevent unwanted changes, not to secure confidential data. Use the file's sharing permissions to control access.