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. |
All times are GMT +1. The time now is 10:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com