Document Editing Problems

Cannot Add Worksheets in Excel? Check Workbook Structure Protection

Anum MushtaqAnum Mushtaq Nov 14, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

Turn off workbook structure protection in Excel

Use this solution when the commands are disabled in one workbook but work in a new workbook.

1
Open protection settings

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.

2
Remove structure protection

If Protect Workbook is enabled, select it to turn off structure protection. Enter the password if Excel asks for one.

3
Test the sheet commands

Click the plus button beside the sheet tabs to add a worksheet, or right-click a sheet tab and select Move or Copy.

Password required?: If the workbook structure is password-protected, ask the workbook owner for the password. Sheet protection and workbook structure protection are separate settings.
Free Microsoft Office alternative

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.

Add and organize worksheets in unprotected workbooksCompatible with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet interface for a smoother transitionFree and lightweight office suite
microsoft office alternative - wps office

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.