Template on Server 2008
in [General]
|
From: widman on 1 Jun 2010 15:49 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?
From: Steve Dunn on 2 Jun 2010 04:37 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/FileTypesMan/3000-2094_4-10806311.html HTH Steve D. "widman" <widman(a)discussions.microsoft.com> wrote in message news:8765C568-B122-4BAF-8CA3-4A0AEF821935(a)microsoft.com... > 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?
From: widman on 2 Jun 2010 09:15 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/FileTypesMan/3000-2094_4-10806311.html > > HTH > Steve D. > > > "widman" <widman(a)discussions.microsoft.com> wrote in message > news:8765C568-B122-4BAF-8CA3-4A0AEF821935(a)microsoft.com... > > 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? >
From: Steve Dunn on 2 Jun 2010 09:52 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" <widman(a)discussions.microsoft.com> wrote in message news:B638A6FD-A73F-418A-B731-B175EA01D195(a)microsoft.com... > 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/FileTypesMan/3000-2094_4-10806311.html >> >> HTH >> Steve D. >> >> >> "widman" <widman(a)discussions.microsoft.com> wrote in message >> news:8765C568-B122-4BAF-8CA3-4A0AEF821935(a)microsoft.com... >> > 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? >>
From: widman on 2 Jun 2010 11:43 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" <widman(a)discussions.microsoft.com> wrote in message > news:B638A6FD-A73F-418A-B731-B175EA01D195(a)microsoft.com... > > 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/FileTypesMan/3000-2094_4-10806311.html > >> > >> HTH > >> Steve D. > >> > >> > >> "widman" <widman(a)discussions.microsoft.com> wrote in message > >> news:8765C568-B122-4BAF-8CA3-4A0AEF821935(a)microsoft.com... > >> > 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? > >> >
|
Next
|
Last
Pages: 1 2 Prev: Check data range and return false value if a cell is blank Next: Information for Pivot Table |