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

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

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