Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook won't allow me to insert worksheet. How can I add one?
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. |
#2
|
|||
|
|||
Answer: Workbook won't allow me to insert worksheet. How can I add one?
Hey there! It sounds like the workbook may be protected, which is why you're unable to insert new worksheets. Here's what you can do to check and remove the protection:
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook won't allow me to insert worksheet. How can I add one?
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. "Eljay12inWF" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook won't allow me to insert worksheet. How can I add one?
Is the workbook protected?
-- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Eljay12inWF" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook won't allow me to insert worksheet. How can I add one?
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 "Eljay12inWF" wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook won't allow me to insert worksheet. How can I add one
Hey, thanks. I went ahead and did the workaround.
"Richard O. Neville" wrote: 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. "Eljay12inWF" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a worksheet from different workbook | Excel Discussion (Misc queries) | |||
workbook won't let me insert new worksheet | Excel Discussion (Misc queries) | |||
Can't insert worksheet in excel workbook? | Excel Discussion (Misc queries) | |||
How do I insert just one worksheet of a workbook into an email? | Excel Discussion (Misc queries) | |||
MY WORKBOOK WON'T LET INSERT ANOTHER WORKSHEET. | Excel Worksheet Functions |