Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of Sheets (Full of Sheet)
Hi All,
This should be an easy one, and as usual I am being lazy by asking. My colleague's (yup - that ole chestnut - ain't mine that's broke - no sirree) Excel won't behave when adding a workbook or adding a worksheet. Adding a workbook problem: Under Tools Options General the "Sheets in New Workbook" box says "2". When she adds a new workbook it has 3 worksheets. Adding a worksheet problem: Adds a new worksheet. Gets x3 worksheets added. TIA and Cheers, Matt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of Sheets (Full of Sheet)
Hi,
really strange behaviour... Well, I would look if there is a file in xlstart folder, and if there is and you do not need it, just remove it from folder, as excel opens whatever is in it. If the folder is empty, just try to change the number of worksheets in new workbook, save it with click on OK and then change it again. Sometimes changing values helps. Regards, Nika Lampe "veryeavy" je napisal: Hi All, This should be an easy one, and as usual I am being lazy by asking. My colleague's (yup - that ole chestnut - ain't mine that's broke - no sirree) Excel won't behave when adding a workbook or adding a worksheet. Adding a workbook problem: Under Tools Options General the "Sheets in New Workbook" box says "2". When she adds a new workbook it has 3 worksheets. Adding a worksheet problem: Adds a new worksheet. Gets x3 worksheets added. TIA and Cheers, Matt |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of Sheets (Full of Sheet)
Just to add to Nika's reply...
You can use a template stored in your, er, your co-worker's XLStart folder that will be used when inserting a new sheet(s). The name of this template file is: Sheet.xlt You can delete it or move it or even open it and change it to what your co-worker wants. There is also a template that is used for new workbooks. It's in that same folder and is named: Book.xlt Whenever your co-worker clicks on the new icon on the standard toolbar, that template workbook will be used as the basis for the new workbook. Nika Lampe wrote: Hi, really strange behaviour... Well, I would look if there is a file in xlstart folder, and if there is and you do not need it, just remove it from folder, as excel opens whatever is in it. If the folder is empty, just try to change the number of worksheets in new workbook, save it with click on OK and then change it again. Sometimes changing values helps. Regards, Nika Lampe "veryeavy" je napisal: Hi All, This should be an easy one, and as usual I am being lazy by asking. My colleague's (yup - that ole chestnut - ain't mine that's broke - no sirree) Excel won't behave when adding a workbook or adding a worksheet. Adding a workbook problem: Under Tools Options General the "Sheets in New Workbook" box says "2". When she adds a new workbook it has 3 worksheets. Adding a worksheet problem: Adds a new worksheet. Gets x3 worksheets added. TIA and Cheers, Matt -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i change a full excel sheet to proper after it has been ty. | Excel Worksheet Functions | |||
Empty full sheet charts | New Users to Excel | |||
How do I convert number into full text amount | Excel Discussion (Misc queries) | |||
Leaing to the next full number? | Excel Worksheet Functions | |||
My sheets keep growing larger full width and length How do I cont. | Excel Discussion (Misc queries) |