Re: Can't insert a new worksheet

[Dave Peterson]

I would double check to make sure that the workbook protection has been removed.

If it has, try closing other applications/workbooks. The maximum number of
sheets in any workbook is limited by available memory.

If that doesn't help, I'd try this against a copy of the workbook. See if you
can remove worksheets. If you can, then see if you can add more after you've
deleted a few.

 

[Dave Peterson]

If you start excel in safe mode:

Close excel
Windows start button|Run
type:
excel /safe

Then use file|open to open your file, can you delete/insert sheets?

If yes, then maybe you have a macro that's disabling those options.

 

[Gord Dibben]

What did you mean by

"None of the workbooks have passwords but all are protected (without a
password)."?

If a workbook is protected, you cannot insert sheets.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Excel offers different levels of protection.

You've seen the file level password to open (or password to modify).

You've see worksheet level (Tools|protection|protect sheet)

But it also offers a workbook level protection:
Tools|Protection|protect workbook

And there's an option to protect the workbook's structure in that last type.
You may want to look for this type once more.