A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Template on Server 2008



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2010, 08:49 PM posted to microsoft.public.excel.misc
widman
external usenet poster
 
Posts: 125
Default Template on Server 2008

I've put an Excel template (.xlt)(Excel 2003 sp3) in a public folder on a
server that is running server 2008.

I put shortcuts to it on several windows machines and some open it as a
worksheet adding a 1 to the end of the name, as it normally would as a local
file, but some machines open it as a template.
Windows XP as xls in Excel 2003
Windows XP as xls en Excel 2007
Windows Vista 32, one as xls and one as xlt en Excel 2003
Windows Vista 64 as xlt en Excel 2003

Obviously I need them to open as xls. How?
Ads
  #2  
Old June 2nd, 2010, 09:37 AM posted to microsoft.public.excel.misc
Steve Dunn
external usenet poster
 
Posts: 192
Default Template on Server 2008

Sounds like the file associations on those machines have lost their default
selection for .xlt files. Try using a program like: FileTypesMan. All
you'll need to do is find .xlt in the list of filetypes, select it,
double-click New in the bottom pane, and make sure Default Action is
selected.

Unfortunately, you'll need to do this on each machine that is having
problems.

http://download.cnet.com/FileTypesMa...-10806311.html

HTH
Steve D.


"widman" wrote in message
...
I've put an Excel template (.xlt)(Excel 2003 sp3) in a public folder on a
server that is running server 2008.

I put shortcuts to it on several windows machines and some open it as a
worksheet adding a 1 to the end of the name, as it normally would as a
local
file, but some machines open it as a template.
Windows XP as xls in Excel 2003
Windows XP as xls en Excel 2007
Windows Vista 32, one as xls and one as xlt en Excel 2003
Windows Vista 64 as xlt en Excel 2003

Obviously I need them to open as xls. How?


  #3  
Old June 2nd, 2010, 02:15 PM posted to microsoft.public.excel.misc
widman
external usenet poster
 
Posts: 125
Default Template on Server 2008

On the right track, but on the XP machine I check to open with Excel instead
of a converter that it has as default, and check to always open with Excel,
but it does not change.

On the Vista 64 machine, it opens with the converter and when I browse I
can't find Excel. Seraching it only finds the shortcut in
C:\ProgramData\Microsoft\StartMenu, and I can't find that with the browse or
microsoft office.

"Steve Dunn" wrote:

Sounds like the file associations on those machines have lost their default
selection for .xlt files. Try using a program like: FileTypesMan. All
you'll need to do is find .xlt in the list of filetypes, select it,
double-click New in the bottom pane, and make sure Default Action is
selected.

Unfortunately, you'll need to do this on each machine that is having
problems.

http://download.cnet.com/FileTypesMa...-10806311.html

HTH
Steve D.


"widman" wrote in message
...
I've put an Excel template (.xlt)(Excel 2003 sp3) in a public folder on a
server that is running server 2008.

I put shortcuts to it on several windows machines and some open it as a
worksheet adding a 1 to the end of the name, as it normally would as a
local
file, but some machines open it as a template.
Windows XP as xls in Excel 2003
Windows XP as xls en Excel 2007
Windows Vista 32, one as xls and one as xlt en Excel 2003
Windows Vista 64 as xlt en Excel 2003

Obviously I need them to open as xls. How?


  #4  
Old June 2nd, 2010, 02:52 PM posted to microsoft.public.excel.misc
Steve Dunn
external usenet poster
 
Posts: 192
Default Template on Server 2008

When file associations are first set up, the context menu (which opens when
you right-click on a file) can have several items, in the case of an Excel
template the top two are usually Open and New. Although they both use Excel
to open the file, the difference is that Open will open it as an editable
template, and New will open it as a new file based on the template. This is
the problem you originally described, and can be solved by making sure that
New is the default action.

However, if you have introduced a converter, you have probably destroyed the
original associations and you need to re-instate them. This can be in
addition to the converter. For Open try:

"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e

and for New try:

"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e /n

You will have to change Office12 (for Excel 2007) to reflect the installed
version, I think Excel 2003 is in Office11.

Then decide which you want as the default action.

HTH
Steve D.



"widman" wrote in message
...
On the right track, but on the XP machine I check to open with Excel
instead
of a converter that it has as default, and check to always open with
Excel,
but it does not change.

On the Vista 64 machine, it opens with the converter and when I browse I
can't find Excel. Seraching it only finds the shortcut in
C:\ProgramData\Microsoft\StartMenu, and I can't find that with the browse
or
microsoft office.

"Steve Dunn" wrote:

Sounds like the file associations on those machines have lost their
default
selection for .xlt files. Try using a program like: FileTypesMan. All
you'll need to do is find .xlt in the list of filetypes, select it,
double-click New in the bottom pane, and make sure Default Action is
selected.

Unfortunately, you'll need to do this on each machine that is having
problems.

http://download.cnet.com/FileTypesMa...-10806311.html

HTH
Steve D.


"widman" wrote in message
...
I've put an Excel template (.xlt)(Excel 2003 sp3) in a public folder on
a
server that is running server 2008.

I put shortcuts to it on several windows machines and some open it as a
worksheet adding a 1 to the end of the name, as it normally would as a
local
file, but some machines open it as a template.
Windows XP as xls in Excel 2003
Windows XP as xls en Excel 2007
Windows Vista 32, one as xls and one as xlt en Excel 2003
Windows Vista 64 as xlt en Excel 2003

Obviously I need them to open as xls. How?



  #5  
Old June 2nd, 2010, 04:43 PM posted to microsoft.public.excel.misc
widman
external usenet poster
 
Posts: 125
Default Template on Server 2008

The converter is "Microsoft Open XML Converter". No matter how many times I
tell it to open xlt files with Excel, even when it shows that Excel will open
it, the file opens as xlt through this microsoft program.




"Steve Dunn" wrote:

When file associations are first set up, the context menu (which opens when
you right-click on a file) can have several items, in the case of an Excel
template the top two are usually Open and New. Although they both use Excel
to open the file, the difference is that Open will open it as an editable
template, and New will open it as a new file based on the template. This is
the problem you originally described, and can be solved by making sure that
New is the default action.

However, if you have introduced a converter, you have probably destroyed the
original associations and you need to re-instate them. This can be in
addition to the converter. For Open try:

"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e

and for New try:

"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e /n

You will have to change Office12 (for Excel 2007) to reflect the installed
version, I think Excel 2003 is in Office11.

Then decide which you want as the default action.

HTH
Steve D.



"widman" wrote in message
...
On the right track, but on the XP machine I check to open with Excel
instead
of a converter that it has as default, and check to always open with
Excel,
but it does not change.

On the Vista 64 machine, it opens with the converter and when I browse I
can't find Excel. Seraching it only finds the shortcut in
C:\ProgramData\Microsoft\StartMenu, and I can't find that with the browse
or
microsoft office.

"Steve Dunn" wrote:

Sounds like the file associations on those machines have lost their
default
selection for .xlt files. Try using a program like: FileTypesMan. All
you'll need to do is find .xlt in the list of filetypes, select it,
double-click New in the bottom pane, and make sure Default Action is
selected.

Unfortunately, you'll need to do this on each machine that is having
problems.

http://download.cnet.com/FileTypesMa...-10806311.html

HTH
Steve D.


"widman" wrote in message
...
I've put an Excel template (.xlt)(Excel 2003 sp3) in a public folder on
a
server that is running server 2008.

I put shortcuts to it on several windows machines and some open it as a
worksheet adding a 1 to the end of the name, as it normally would as a
local
file, but some machines open it as a template.
Windows XP as xls in Excel 2003
Windows XP as xls en Excel 2007
Windows Vista 32, one as xls and one as xlt en Excel 2003
Windows Vista 64 as xlt en Excel 2003

Obviously I need them to open as xls. How?


  #6  
Old June 2nd, 2010, 10:10 PM posted to microsoft.public.excel.misc
Steve Dunn
external usenet poster
 
Posts: 192
Default Template on Server 2008

When you right-click on the file in Windows Explorer, do you get the "New"
option? You may have to be resigned to always using that, rather than
double-clicking.


"widman" wrote in message
...
The converter is "Microsoft Open XML Converter". No matter how many times
I
tell it to open xlt files with Excel, even when it shows that Excel will
open
it, the file opens as xlt through this microsoft program.




"Steve Dunn" wrote:

When file associations are first set up, the context menu (which opens
when
you right-click on a file) can have several items, in the case of an
Excel
template the top two are usually Open and New. Although they both use
Excel
to open the file, the difference is that Open will open it as an editable
template, and New will open it as a new file based on the template. This
is
the problem you originally described, and can be solved by making sure
that
New is the default action.

However, if you have introduced a converter, you have probably destroyed
the
original associations and you need to re-instate them. This can be in
addition to the converter. For Open try:

"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e

and for New try:

"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e /n

You will have to change Office12 (for Excel 2007) to reflect the
installed
version, I think Excel 2003 is in Office11.

Then decide which you want as the default action.

HTH
Steve D.



"widman" wrote in message
...
On the right track, but on the XP machine I check to open with Excel
instead
of a converter that it has as default, and check to always open with
Excel,
but it does not change.

On the Vista 64 machine, it opens with the converter and when I browse
I
can't find Excel. Seraching it only finds the shortcut in
C:\ProgramData\Microsoft\StartMenu, and I can't find that with the
browse
or
microsoft office.

"Steve Dunn" wrote:

Sounds like the file associations on those machines have lost their
default
selection for .xlt files. Try using a program like: FileTypesMan.
All
you'll need to do is find .xlt in the list of filetypes, select it,
double-click New in the bottom pane, and make sure Default Action is
selected.

Unfortunately, you'll need to do this on each machine that is having
problems.

http://download.cnet.com/FileTypesMa...-10806311.html

HTH
Steve D.


"widman" wrote in message
...
I've put an Excel template (.xlt)(Excel 2003 sp3) in a public folder
on
a
server that is running server 2008.

I put shortcuts to it on several windows machines and some open it
as a
worksheet adding a 1 to the end of the name, as it normally would as
a
local
file, but some machines open it as a template.
Windows XP as xls in Excel 2003
Windows XP as xls en Excel 2007
Windows Vista 32, one as xls and one as xlt en Excel 2003
Windows Vista 64 as xlt en Excel 2003

Obviously I need them to open as xls. How?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.