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.