| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a worksheet to a current workbook
I have an existing workbook that I would like to add another worksheet to.
However, when I try to insert another one, it is not an option on the INSERT tab or from right clicking one of the existing tabs at the bottom of the workbook. Any other suggestions. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a worksheet to a current workbook
How many worksheets are in the workbook? If you delete a worksheet does it
allow you to add one. You may be at the max limit to the number of worksheets in a workbook. "naschulte" wrote: I have an existing workbook that I would like to add another worksheet to. However, when I try to insert another one, it is not an option on the INSERT tab or from right clicking one of the existing tabs at the bottom of the workbook. Any other suggestions. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a worksheet to a current workbook
Workbook protected?
-- David Biddulph "naschulte" <u35423@uwe wrote in message news:746148f40cc6b@uwe... I have an existing workbook that I would like to add another worksheet to. However, when I try to insert another one, it is not an option on the INSERT tab or from right clicking one of the existing tabs at the bottom of the workbook. Any other suggestions. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a worksheet to a current workbook
Joel
See help on excel specifications. There is no "max limit" for number of worksheets in a workbook. Gord Dibben MS Excel MVP On Thu, 28 Jun 2007 08:58:02 -0700, Joel wrote: How many worksheets are in the workbook? If you delete a worksheet does it allow you to add one. You may be at the max limit to the number of worksheets in a workbook. "naschulte" wrote: I have an existing workbook that I would like to add another worksheet to. However, when I try to insert another one, it is not an option on the INSERT tab or from right clicking one of the existing tabs at the bottom of the workbook. Any other suggestions. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a worksheet to a current workbook
It appears that someone has indeed changed the password without the authors
knowledge. She has tried the only two passwords used by her at work and all the versions i.e. caps, upper & lower case combinations...so Thank you for your reply David Biddulph wrote: Workbook protected? I have an existing workbook that I would like to add another worksheet to. However, when I try to insert another one, it is not an option on the INSERT tab or from right clicking one of the existing tabs at the bottom of the workbook. Any other suggestions. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a worksheet to a current workbook
See John's site for internal password help.
http://www.mcgimpsey.com/excel/removepwords.html Gord Dibben MS Excel MVP On Thu, 28 Jun 2007 17:33:39 GMT, "naschulte" <u35423@uwe wrote: It appears that someone has indeed changed the password without the authors knowledge. She has tried the only two passwords used by her at work and all the versions i.e. caps, upper & lower case combinations...so Thank you for your reply David Biddulph wrote: Workbook protected? I have an existing workbook that I would like to add another worksheet to. However, when I try to insert another one, it is not an option on the INSERT tab or from right clicking one of the existing tabs at the bottom of the workbook. Any other suggestions. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a worksheet to a current workbook
THANK YOU - we were able to get into the worksheet (over 400) and not have to
duplicate the entire thing. You are awesome to have answered so quickly. Again, thank you. Gord Dibben wrote: See John's site for internal password help. http://www.mcgimpsey.com/excel/removepwords.html Gord Dibben MS Excel MVP It appears that someone has indeed changed the password without the authors knowledge. She has tried the only two passwords used by her at work and all [quoted text clipped - 8 lines] tab or from right clicking one of the existing tabs at the bottom of the workbook. Any other suggestions. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a worksheet to a current workbook
Good to hear.
Thanks for posting back. Gord On Thu, 28 Jun 2007 18:38:55 GMT, "naschulte" <u35423@uwe wrote: THANK YOU - we were able to get into the worksheet (over 400) and not have to duplicate the entire thing. You are awesome to have answered so quickly. Again, thank you. Gord Dibben wrote: See John's site for internal password help. http://www.mcgimpsey.com/excel/removepwords.html Gord Dibben MS Excel MVP It appears that someone has indeed changed the password without the authors knowledge. She has tried the only two passwords used by her at work and all [quoted text clipped - 8 lines] tab or from right clicking one of the existing tabs at the bottom of the workbook. Any other suggestions. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a worksheet to a current workbook | Excel Discussion (Misc queries) | |||
| Adding to current cells | Excel Worksheet Functions | |||
| Cannot be MERGED into the current workbook | Excel Discussion (Misc queries) | |||
| 'Save current worksheet'; 'Open next worksheet' - two command buttons | Excel Discussion (Misc queries) | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Linear Mode
