Workbook won't allow me to insert worksheet. How can I add one?

E

Eljay12inWF

Hey. I have a workbook given to me by someone and when I try to insert
additional workseets to the workbook it won't let me. The "insert" function
is not available when I try to add a new sheet. Any sugestions on how to
allow the workbook to let me insert new worksheets? Thanks.
 
R

Richard O. Neville

Don't know why you are unable to insert worksheets, but there is an easy
workaround. Select all the existing worksheets and copy them to a new
workbook; save it; you should then be able to insert additional worksheets.
 
E

Elkar

The Workbook is probably protected. Try unprotecting it.

TOOLS
PROTECTION
UNPROTECT WORKBOOK...

If it asks for a Password, then you should check with the person who sent it
to you.

HTH
Elkar
 

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

Sharing workbooks limitations - Merged Cells 12
Insert Worksheet? 2
Insert Worksheet At the End Of Workbook 2
VBA - retrieve data on last create named range from previous inserted named range 0
Unable to Insert Worksheets or Change Tab Names 4
Allow user to insert rows on protected worksheet 1
Inserting worksheet in Excel 1
Formula Audit mode active in one column only; cannot kill. 2

Top