Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why can't i insert a new worksheet?
I have an Excel 2000 spreadsheet that has about 25 worksheets in it, all
quite small. It won't let me add a new worksheet though, nothing happens when i click the icon for it and when I right-click the tabs at the bottom the 'Insert' option is greyed out. I have mostly been trying to open it in Excel 2007 but I also tried on a pc using Excel 2000 and get the same result. In 2007, i have checked its in a trusted location and i can make other changes to the spreadsheet. any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why can't i insert a new worksheet?
1. make sure there are no protections in place that prevent adding a worksheet
2. open the workbook in Office Safe Mode and see if that helps. -- Gary''s Student - gsnu200801 "beaker15" wrote: I have an Excel 2000 spreadsheet that has about 25 worksheets in it, all quite small. It won't let me add a new worksheet though, nothing happens when i click the icon for it and when I right-click the tabs at the bottom the 'Insert' option is greyed out. I have mostly been trying to open it in Excel 2007 but I also tried on a pc using Excel 2000 and get the same result. In 2007, i have checked its in a trusted location and i can make other changes to the spreadsheet. any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot insert worksheet in exel - not available in insert menu | Excel Worksheet Functions | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Wish to add a WORKSHEET but 'WORKSHEET' not open in 'INSERT' | Excel Worksheet Functions | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
insert worksheet | New Users to Excel |