Insert a custom MS Excel WORKSHEET into a WORKBOOK?

[AJ Doyle]

I have created a range of custom Worksheets. When I want to insert them into
a new Workbook, I cannot find the files as there is now browse option. Other
MS products allow you to set the source folder for such custom documents, but
I cant see how to do this.

When I try and insert a worksheet, there are a range of random files I can
insert, but not the ones I want!

Hope somebody can help.

Adam

 

[Gord Dibben]

You cannot insert files into a workbook as worksheets.

You can have one(1) customized worksheet template named SHEET.xlt in your
XLSTART folder which will be the default for Insert>Sheet.

If you are talking about creating a new workbook from a customized workbook
Template, no problem.

Store them in the usual location.

C:\Documents and Settings\username\Application Data\Microsoft\Templates


Gord Dibben MS Excel MVP