wont allow adding worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello!

We have a excel workbook we use to keep track of inventory and there are
several worsheets inside that hold different sets of data. The problem is
that all of the sudden it will not let us add any more worsheets to the
workbook. There are only 10 worksheets right now so I know its not a 'limit'
thing. I try right clicking the tabs and insert is greyed out and also click
insert menu at the top and 'worksheet' is greyed out. Anyone know of
anything that could be causing this??

Thanks in advance!!
 
Ehren,

Your workbook appears to be protected.

Use Tools / Protection.... Unprotect Workbook and you should be able to insert worksheets.

HTH,
Bernie
MS Excel MVP
 
Sounds like you have set workbook protection to "on".

Tools>Protection>Unprotect workbook.

You may have to supply a password to unlock if someone has deliberately
protected the book.


Gord Dibben MS Excel MVP
 
Thank you much!

Gord Dibben said:
Sounds like you have set workbook protection to "on".

Tools>Protection>Unprotect workbook.

You may have to supply a password to unlock if someone has deliberately
protected the book.


Gord Dibben MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem rearranging worksheets 3
No answer yet... Data Import from Many Worksheets to on file... 2
Save Worksheet To Master Workbook 5
Email Worksheet Question 3
Excel 2007 worksheet switching issue using Windows 7 17
Do not specify worksheet in a named range 3
Unable to add/delete row 1
Click to Clear Radio Button 10

Back
Top