Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't insert a new worksheet
On Sunday, August 1, 2010 at 2:19:26 AM UTC+5:30, Jack Deuce wrote:
I have 4 spreadsheets, one for each school, each containing 100+ worksheets with the same worksheet names. The only difference between them is the data (inventory) that is recorded in each. It's time to roll the totals for next year and add new products. All 4 have been unprotected and 3 of them will allow the inserting of new worksheets, but the 4th when I right-click on an adjoining tab is displaying grayed out 'INSERT, DELETE, RENAME, MOVE or COPY'. I need to insert new worksheets for new products. Does anyone have any ideas as to why this one workbook would disallow the insertion of a new worksheet? None of the workbooks have passwords but all are protected (without a password). Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Insert Worksheet with Worksheet Name the Current Date | Excel Programming | |||
Cannot insert worksheet in exel - not available in insert menu | Excel Worksheet Functions | |||
Insert new Worksheet with name, and insert the sheet into itsalphabetical / numerical location | Excel Programming | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions |