#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Template

We have saved a template file to a shared folder on our server (jobpack.xlt).
It is accessed via a link on our company intranet. Some users click the
link and the file opens as jobpack1.xls, but other users click the same link
and the file is loaded as the template (jobpack.xlt). We'd like to have ALL
users get the jobpack1.xls results when they click. Any idea what we need to
do to make this happen?

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,758
Default Template

I bet it's really jobpack1 (w/o the .xls).

But it sounds like windows/excel is slightly confused on how to treat the .xlt
extension.

I'd have the "offending" users try this:

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

slagmandoza wrote:

We have saved a template file to a shared folder on our server (jobpack.xlt).
It is accessed via a link on our company intranet. Some users click the
link and the file opens as jobpack1.xls, but other users click the same link
and the file is loaded as the template (jobpack.xlt). We'd like to have ALL
users get the jobpack1.xls results when they click. Any idea what we need to
do to make this happen?

Thanks!


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Template

Dave,

Thanks for the suggestion. We'll give it a try.

Thanks!



"Dave Peterson" wrote:

I bet it's really jobpack1 (w/o the .xls).

But it sounds like windows/excel is slightly confused on how to treat the .xlt
extension.

I'd have the "offending" users try this:

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

slagmandoza wrote:

We have saved a template file to a shared folder on our server (jobpack.xlt).
It is accessed via a link on our company intranet. Some users click the
link and the file opens as jobpack1.xls, but other users click the same link
and the file is loaded as the template (jobpack.xlt). We'd like to have ALL
users get the jobpack1.xls results when they click. Any idea what we need to
do to make this happen?

Thanks!


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Template

Tried, but didn't help. Anything else I might try?

Thanks!

"slagmandoza" wrote:

Dave,

Thanks for the suggestion. We'll give it a try.

Thanks!



"Dave Peterson" wrote:

I bet it's really jobpack1 (w/o the .xls).

But it sounds like windows/excel is slightly confused on how to treat the .xlt
extension.

I'd have the "offending" users try this:

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

slagmandoza wrote:

We have saved a template file to a shared folder on our server (jobpack.xlt).
It is accessed via a link on our company intranet. Some users click the
link and the file opens as jobpack1.xls, but other users click the same link
and the file is loaded as the template (jobpack.xlt). We'd like to have ALL
users get the jobpack1.xls results when they click. Any idea what we need to
do to make this happen?

Thanks!


--

Dave Peterson

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,758
Default Template

This is a windows setting, so you'll have to do this on each pc.

I'd close excel (just because!).

(This is for winXP--but it'll be similar to other versions of windows)
Open windows explorer
Tools|Folder Options|File Types Tab
Scroll down to XLT Microsoft Excel Template
Select that.
Click on the Advanced button
Make sure that New is bolded (if it isn't select New and click "set as default"

Ok your way out and test it out.

(I was hoping that /regserver would do the same as this.)

slagmandoza wrote:

Tried, but didn't help. Anything else I might try?

Thanks!

"slagmandoza" wrote:

Dave,

Thanks for the suggestion. We'll give it a try.

Thanks!



"Dave Peterson" wrote:

I bet it's really jobpack1 (w/o the .xls).

But it sounds like windows/excel is slightly confused on how to treat the .xlt
extension.

I'd have the "offending" users try this:

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

slagmandoza wrote:

We have saved a template file to a shared folder on our server (jobpack.xlt).
It is accessed via a link on our company intranet. Some users click the
link and the file opens as jobpack1.xls, but other users click the same link
and the file is loaded as the template (jobpack.xlt). We'd like to have ALL
users get the jobpack1.xls results when they click. Any idea what we need to
do to make this happen?

Thanks!

--

Dave Peterson


--

Dave Peterson


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Template

No - already set as you described! ANything else worth a shot?

Thanks!

"Dave Peterson" wrote:

This is a windows setting, so you'll have to do this on each pc.

I'd close excel (just because!).

(This is for winXP--but it'll be similar to other versions of windows)
Open windows explorer
Tools|Folder Options|File Types Tab
Scroll down to XLT Microsoft Excel Template
Select that.
Click on the Advanced button
Make sure that New is bolded (if it isn't select New and click "set as default"

Ok your way out and test it out.

(I was hoping that /regserver would do the same as this.)

slagmandoza wrote:

Tried, but didn't help. Anything else I might try?

Thanks!

"slagmandoza" wrote:

Dave,

Thanks for the suggestion. We'll give it a try.

Thanks!



"Dave Peterson" wrote:

I bet it's really jobpack1 (w/o the .xls).

But it sounds like windows/excel is slightly confused on how to treat the .xlt
extension.

I'd have the "offending" users try this:

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

slagmandoza wrote:

We have saved a template file to a shared folder on our server (jobpack.xlt).
It is accessed via a link on our company intranet. Some users click the
link and the file opens as jobpack1.xls, but other users click the same link
and the file is loaded as the template (jobpack.xlt). We'd like to have ALL
users get the jobpack1.xls results when they click. Any idea what we need to
do to make this happen?

Thanks!

--

Dave Peterson


--

Dave Peterson

  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,758
Default Template

I got nothing!

Slagmendoza wrote:

No - already set as you described! ANything else worth a shot?

Thanks!

"Dave Peterson" wrote:

This is a windows setting, so you'll have to do this on each pc.

I'd close excel (just because!).

(This is for winXP--but it'll be similar to other versions of windows)
Open windows explorer
Tools|Folder Options|File Types Tab
Scroll down to XLT Microsoft Excel Template
Select that.
Click on the Advanced button
Make sure that New is bolded (if it isn't select New and click "set as default"

Ok your way out and test it out.

(I was hoping that /regserver would do the same as this.)

slagmandoza wrote:

Tried, but didn't help. Anything else I might try?

Thanks!

"slagmandoza" wrote:

Dave,

Thanks for the suggestion. We'll give it a try.

Thanks!



"Dave Peterson" wrote:

I bet it's really jobpack1 (w/o the .xls).

But it sounds like windows/excel is slightly confused on how to treat the .xlt
extension.

I'd have the "offending" users try this:

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

slagmandoza wrote:

We have saved a template file to a shared folder on our server (jobpack.xlt).
It is accessed via a link on our company intranet. Some users click the
link and the file opens as jobpack1.xls, but other users click the same link
and the file is loaded as the template (jobpack.xlt). We'd like to have ALL
users get the jobpack1.xls results when they click. Any idea what we need to
do to make this happen?

Thanks!

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Template (Creating a Function in the template) Té Excel Worksheet Functions 3 March 6th 09 07:17 AM
How do I distribute a template created with Template Wizard ? Sofia Excel Discussion (Misc queries) 0 June 20th 07 04:51 PM
NCAA tournament brackets template from Template gallery. smcclements Excel Worksheet Functions 2 March 16th 07 02:33 PM
I want to create a template like invoice template in excel. Rahul Gupta[_2_] Excel Programming 7 May 12th 05 02:50 AM
Excel template to load automatically as the default template? David Excel Discussion (Misc queries) 1 March 21st 05 12:24 PM


All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"