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

  • Thread starter Thread starter Eljay12inWF
  • Start date Start date
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.
 
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.
 
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
Copy sheet to different workbook sizing error message 2
VBA - retrieve data on last create named range from previous inserted named range 0
How to create absolue path link to another workbook (Excel 2003) 1
Unable to Insert Worksheets or Change Tab Names 4
Allow user to insert rows on protected worksheet 1

Back
Top