Re: Can't insert a new worksheet

  • Thread starter Thread starter Dave Peterson
  • Start date Start date
D

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.
 
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.
 
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
 
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.
 
Back
Top