I'm not sure if this is a Windows question or Excel question, so I'm starting
here. A client has Win XP/Office 2003. She would like to be able to use the
File, New command to access Excel templates (.xlt files) that are saved on a
network drive. She would like these templates to appear on their own own tab
in the dialog box when clicking on "On my computer..." Any suggestions?
Thanks!
--
maryj

"maryj" wrote:

I'm not sure if this is a Windows question or Excel question, so I'm starting
here. A client has Win XP/Office 2003. She would like to be able to use the
File, New command to access Excel templates (.xlt files) that are saved on a
network drive. She would like these templates to appear on their own own tab
in the dialog box when clicking on "On my computer..." Any suggestions?

Click on ToolsOptions then select the General tab and change the Alternate
Startup file location as described in this extract from the help file
entitled "Guidelines for storing templates" :-

To use templates stored on a network file location, you can specify that
location as the alternate startup folder. Custom templates stored in the
XLStart folder or the alternate startup folder appear on the General tab in
the New dialog box (File menu).

Alternatively, as Excel is part of MS office, the default template folder
can be set in MS Word (Tools, Options, File Locations)

But this will open all those templates in the alternate startup location each
time she opens excel.



bigwheel wrote:

"maryj" wrote:

I'm not sure if this is a Windows question or Excel question, so I'm starting
here. A client has Win XP/Office 2003. She would like to be able to use the
File, New command to access Excel templates (.xlt files) that are saved on a
network drive. She would like these templates to appear on their own own tab
in the dialog box when clicking on "On my computer..." Any suggestions?

Click on ToolsOptions then select the General tab and change the Alternate
Startup file location as described in this extract from the help file
entitled "Guidelines for storing templates" :-

To use templates stored on a network file location, you can specify that
location as the alternate startup folder. Custom templates stored in the
XLStart folder or the alternate startup folder appear on the General tab in
the New dialog box (File menu).

Alternatively, as Excel is part of MS office, the default template folder
can be set in MS Word (Tools, Options, File Locations)

--

Dave Peterson

"Dave Peterson" wrote:

But this will open all those templates in the alternate startup location each
time she opens excel.

Strange, it didn't when I tried it ;-)

You're right. It didn't open it for me when I tested it. (I should have tried
it before my other post.)

bigwheel wrote:

"Dave Peterson" wrote:

But this will open all those templates in the alternate startup location each
time she opens excel.

Strange, it didn't when I tried it ;-)

--

Dave Peterson

So if you put templates in that alternate startup location, how did you get to
choose them when you did the File|New?



bigwheel wrote:

"Dave Peterson" wrote:

But this will open all those templates in the alternate startup location each
time she opens excel.

Strange, it didn't when I tried it ;-)

--

Dave Peterson

You can specify a workgroup template location in MSWord and excel will use it.


Inside MSWord
Tools|options|File Locations tab|
Workgroup templates



maryj wrote:

I'm not sure if this is a Windows question or Excel question, so I'm starting
here. A client has Win XP/Office 2003. She would like to be able to use the
File, New command to access Excel templates (.xlt files) that are saved on a
network drive. She would like these templates to appear on their own own tab
in the dialog box when clicking on "On my computer..." Any suggestions?
Thanks!
--
maryj

--

Dave Peterson

"Dave Peterson" wrote:

You can specify a workgroup template location in MSWord and excel will use it.


Inside MSWord
Tools|options|File Locations tab|
Workgroup templates

That's precisely what I'd said...
Alternatively, as Excel is part of MS office, the default template folder
can be set in MS Word (Tools, Options, File Locations)

Yes you did.


bigwheel wrote:

"Dave Peterson" wrote:

You can specify a workgroup template location in MSWord and excel will use it.


Inside MSWord
Tools|options|File Locations tab|
Workgroup templates

That's precisely what I'd said...
Alternatively, as Excel is part of MS office, the default template folder
can be set in MS Word (Tools, Options, File Locations)

--

Dave Peterson

BUT fellas, I believe that the OP is asking for a *separate* tab in the
<File <New window.

What you describe, adds the *contents* of the folder in the specified WORD
workgroups file to the "General" tab.
Also, WBs (templates) that are contained in the folder designated in XL's
Alternate StartUp Location will be displayed under the "General" tab.

There are several ways to add *separate* tabs to the <File <New window.
Since the OP mentioned Office, then going through Word might be the easiest.

All you have to do to create a separate tab is create a new folder *in* the
folder you designated as the WORD Workgroups folder.
A strange thing here though, is that this folder within a folder will *not*
display as a separate tab in the <File <New window *unless it is
populated*!!!

Create this folder within a folder, and see nothing when you go to <File
<New.
Add a WS to this folder, and it now becomes a tab, displayed in <File
<New.
And this WS can be an .xls OR .xlt file, and it still acts as a template,
opening a copy of the original, preserving the actual original from
revisions.

As many folders as you create within the Word Workgroups main folder will
display as that many *separate* tabs in the <File <New window, each
needing to be populated to be displayed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Dave Peterson" wrote in message
...
Yes you did.


bigwheel wrote:

"Dave Peterson" wrote:

You can specify a workgroup template location in MSWord and excel will
use it.


Inside MSWord
Tools|options|File Locations tab|
Workgroup templates

That's precisely what I'd said...
Alternatively, as Excel is part of MS office, the default template folder
can be set in MS Word (Tools, Options, File Locations)

--

Dave Peterson

"RagDyeR" skrev:

BUT fellas, I believe that the OP is asking for a *separate* tab in the
<File <New window.

What you describe, adds the *contents* of the folder in the specified WORD
workgroups file to the "General" tab.
Also, WBs (templates) that are contained in the folder designated in XL's
Alternate StartUp Location will be displayed under the "General" tab.

There are several ways to add *separate* tabs to the <File <New window.
Since the OP mentioned Office, then going through Word might be the easiest.

All you have to do to create a separate tab is create a new folder *in* the
folder you designated as the WORD Workgroups folder.
A strange thing here though, is that this folder within a folder will *not*
display as a separate tab in the <File <New window *unless it is
populated*!!!

Create this folder within a folder, and see nothing when you go to <File
<New.
Add a WS to this folder, and it now becomes a tab, displayed in <File
<New.
And this WS can be an .xls OR .xlt file, and it still acts as a template,
opening a copy of the original, preserving the actual original from
revisions.

As many folders as you create within the Word Workgroups main folder will
display as that many *separate* tabs in the <File <New window, each
needing to be populated to be displayed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Dave Peterson" wrote in message
...
Yes you did.


bigwheel wrote:

"Dave Peterson" wrote:

You can specify a workgroup template location in MSWord and excel will
use it.


Inside MSWord
Tools|options|File Locations tab|
Workgroup templates

That's precisely what I'd said...
Alternatively, as Excel is part of MS office, the default template folder
can be set in MS Word (Tools, Options, File Locations)

--

Dave Peterson

Thank you for good suggestions. Now my templates work in Excel. But as I
have many templates in Word too, when opering Excel I now get warnings for
all the ".dot" files!!!??? Any suggestions to solve this problem??

Regards Bodiller

"RagDyeR" skrev:

BUT fellas, I believe that the OP is asking for a *separate* tab in the
<File <New window.

What you describe, adds the *contents* of the folder in the specified WORD
workgroups file to the "General" tab.
Also, WBs (templates) that are contained in the folder designated in XL's
Alternate StartUp Location will be displayed under the "General" tab.

There are several ways to add *separate* tabs to the <File <New window.
Since the OP mentioned Office, then going through Word might be the easiest.

All you have to do to create a separate tab is create a new folder *in* the
folder you designated as the WORD Workgroups folder.
A strange thing here though, is that this folder within a folder will *not*
display as a separate tab in the <File <New window *unless it is
populated*!!!

Create this folder within a folder, and see nothing when you go to <File
<New.
Add a WS to this folder, and it now becomes a tab, displayed in <File
<New.
And this WS can be an .xls OR .xlt file, and it still acts as a template,
opening a copy of the original, preserving the actual original from
revisions.

As many folders as you create within the Word Workgroups main folder will
display as that many *separate* tabs in the <File <New window, each
needing to be populated to be displayed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Dave Peterson" wrote in message
...
Yes you did.


bigwheel wrote:

"Dave Peterson" wrote:

You can specify a workgroup template location in MSWord and excel will
use it.


Inside MSWord
Tools|options|File Locations tab|
Workgroup templates

That's precisely what I'd said...
Alternatively, as Excel is part of MS office, the default template folder
can be set in MS Word (Tools, Options, File Locations)

--

Dave Peterson