Prev: Check data range and return false value if a cell is blank
Next: Information for Pivot Table
From: Steve Dunn on 2 Jun 2010 17:10
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" <widman(a)discussions.microsoft.com> wrote in message
news:00FDF267-C3C3-4858-9FD6-FE00EE679CD5(a)microsoft.com...
> 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?
>> >>
>>

First  |  Prev  | 
Pages: 1 2
Prev: Check data range and return false value if a cell is blank
Next: Information for Pivot Table