I current am working a spreadsheet that has 4 tabs at the bottom, the most
R/H tab being a summary report. When I try to insert another worksheet using
the "insert" function, I find it blocked/inactive. The Excel help menu has NO
usable information whatsoever on why the insert function is NOT active. I
find the help menus on Excel getting worse and worse not able to supply
simple information and not relating properly to the pull down menus.

Most common reasaon for this is that the Workbook is protected.

In 2003 and earlier you would go to ToolsProtectionUnprotect workbook.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 07:28:02 -0700, John Falkenstine wrote:

I current am working a spreadsheet that has 4 tabs at the bottom, the most
R/H tab being a summary report. When I try to insert another worksheet using
the "insert" function, I find it blocked/inactive. The Excel help menu has NO
usable information whatsoever on why the insert function is NOT active. I
find the help menus on Excel getting worse and worse not able to supply
simple information and not relating properly to the pull down menus.

John Falkenstine;2412888 Wrote:
I current am working a spreadsheet that has 4 tabs at the bottom, the
most
R/H tab being a summary report. When I try to insert another worksheet
using
the "insert" function, I find it blocked/inactive. The Excel help menu
has NO
usable information whatsoever on why the insert function is NOT active.
I
find the help menus on Excel getting worse and worse not able to supply

simple information and not relating properly to the pull down menus.

What worked for me is as follow. ToolsOptions then choose the general
tub and in the middle you have the option of increasing the number of
worksheets you can have. Excel typicaly comes with 3 in the # of
worsheets spot.
Good Luck




--
ab3d4u

What worked for me is as follow. ToolsOptions then choose the general
tub and in the middle you have the option of increasing the number of
worksheets you can have. Excel typicaly comes with 3 in the # of
worsheets spot.

That is only the default number of sheets in a new workbook and no bearing on
how many sheets you can insert later or why your "insert sheet" was blocked.

But glad to hear you can now insert a new sheet.


Gord Dibben MS Excel MVP


On Tue, 9 Oct 2007 20:38:12 +0100, ab3d4u
wrote:


John Falkenstine;2412888 Wrote:
I current am working a spreadsheet that has 4 tabs at the bottom, the
most
R/H tab being a summary report. When I try to insert another worksheet
using
the "insert" function, I find it blocked/inactive. The Excel help menu
has NO
usable information whatsoever on why the insert function is NOT active.
I
find the help menus on Excel getting worse and worse not able to supply

simple information and not relating properly to the pull down menus.

What worked for me is as follow. ToolsOptions then choose the general
tub and in the middle you have the option of increasing the number of
worksheets you can have. Excel typicaly comes with 3 in the # of
worsheets spot.
Good Luck