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.

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.

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.

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.

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.

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.

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.

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.