Cannot Add Worksheets in Excel? Check Workbook Structure Protection
Question details
The user needs to add or move worksheets in an Excel workbook where the relevant commands are disabled.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to add a worksheet or use Move or Copy in an existing workbook.
- Observed behavior
- The New Sheet button and Move or Copy command are disabled in one workbook, but worksheets can be added in new workbooks.
Open the affected workbook and create a new workbook using File > New. Check whether the plus button beside the sheet tabs works in the new file; this helps determine whether the issue is specific to one workbook.
Turn off workbook structure protection in Excel
Use this solution when the commands are disabled in one workbook but work in a new workbook.
In the affected workbook, select Review and look for Protect Workbook. You can also check File > Info > Protect Workbook for the workbook structure protection setting.
If Protect Workbook is enabled, select it to turn off structure protection. Enter the password if Excel asks for one.
Click the plus button beside the sheet tabs to add a worksheet, or right-click a sheet tab and select Move or Copy.
Repair Microsoft Office if every workbook is affected
Consider an Office Online Repair when the New Sheet button is also disabled in new workbooks, not just one file.
Manage Worksheets with WPS Spreadsheets
WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files in WPS Spreadsheets for a straightforward transition, though switching apps does not remove Excel workbook protection.

Frequently Asked Questions
Why is the plus button disabled in only one Excel workbook?
Workbook structure protection may prevent worksheets from being added, moved, or copied. Open the affected file and check Review > Protect Workbook.
What if Excel asks for a password when I turn off workbook protection?
Enter the password used to protect the workbook structure. If you do not know it, contact the workbook owner.
Is protecting a worksheet the same as protecting a workbook?
No. Worksheet protection restricts changes within a sheet, while workbook structure protection restricts actions such as adding or moving sheets. Check Review > Protect Workbook for the structure setting.
Should I repair Office if new workbooks work normally?
Usually, no. If the problem occurs in only one file, check that workbook's protection settings first. Consider an Office repair if the issue also affects new workbooks.




