How can I *re-set* Windows XP SP2 to open all of my Excel files
(.xls.xlt.csv) in Excel 97 when double-clicking?

I also have Office 2007 installed inorder to sample the program, but not to
use as my primary office application at this time.

Thanks.

-Dennis

--
Dennis Kessler
http://www.denniskessler.com/acupuncture

You have to re-register the particular Excel version you want to open excel
files with

http://support.microsoft.com/kb/214388/en-us


--


Regards,


Peo Sjoblom



"dk_" <nobody@spamless.com> wrote in message
news:R%LSj.2715$NZ7.901@newsfe10.ams2...
> How can I *re-set* Windows XP SP2 to open all of my Excel files
> (.xls.xlt.csv) in Excel 97 when double-clicking?
>
> I also have Office 2007 installed inorder to sample the program, but not
> to
> use as my primary office application at this time.
>
> Thanks.
>
> -Dennis
>
> --
> Dennis Kessler
> http://www.denniskessler.com/acupuncture

In article <uA5qXNKrIHA.1164@TK2MSFTNGP04.phx.gbl>,
"Peo Sjoblom" <terre08@mvps.org> wrote:

> You have to re-register the particular Excel version you want to open excel
> files with
>
> http://support.microsoft.com/kb/214388/en-us


The method in this article of re-registering by specificying the path to the
version of Excel 97 (8) that I want to use does not make the change work.
Actually, the path is already pointing to the version I want to run. I'm
unning Windows XP. That article is for Windows 2000. I tried it.

Excel 97 will open the double clicked file, if Excel 97 is already running.
This helps a lot so far. Thanks.

-Dennis

--
Dennis Kessler
http://www.denniskessler.com/acupuncture

If you are comfortable using the registry editor (Start->Run: Regedit.exe)
you can control which Excel opens XLS files like this:

-Navigate to HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
-Delete or rename the "command" entry
-Edit "(Default)" to the full path to the Excel.exe you want e.g. "c:\<full
path>\Excel.exe" /e


--
Jim
"dk_" <nobody@spamless.com> wrote in message
news:maOSj.1042$8q4.274@newsfe15.ams2...
> In article <uA5qXNKrIHA.1164@TK2MSFTNGP04.phx.gbl>,
> "Peo Sjoblom" <terre08@mvps.org> wrote:
>
>> You have to re-register the particular Excel version you want to open
>> excel
>> files with
>>
>> http://support.microsoft.com/kb/214388/en-us
>
>
> The method in this article of re-registering by specificying the path to
> the
> version of Excel 97 (8) that I want to use does not make the change work.
> Actually, the path is already pointing to the version I want to run. I'm
> unning Windows XP. That article is for Windows 2000. I tried it.
>
> Excel 97 will open the double clicked file, if Excel 97 is already
> running.
> This helps a lot so far. Thanks.
>
> -Dennis
>
> --
> Dennis Kessler
> http://www.denniskessler.com/acupuncture

In article <#hv#jQSrIHA.1164@TK2MSFTNGP04.phx.gbl>,
"Jim Rech" <jrrech@live.com> wrote:

> If you are comfortable using the registry editor (Start->Run: Regedit.exe)
> you can control which Excel opens XLS files like this:
>
> -Navigate to HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
> -Delete or rename the "command" entry
> -Edit "(Default)" to the full path to the Excel.exe you want e.g. "c:\<full
> path>\Excel.exe" /e
>
>
> --
> Jim


Jim,

That did not work, (I just tried).

The full path was already correct in the (Default).

I also deleted the entry 'in' the (command), although I didn't delete
(command); I just deleted the contents of (command). Didn't work.

I set the command back to the way it was before I edited it, and Excel 2007
opens the .xls file.

Thanks.

-Dennis






> "dk_" <nobody@spamless.com> wrote in message
> news:maOSj.1042$8q4.274@newsfe15.ams2...
> > In article <uA5qXNKrIHA.1164@TK2MSFTNGP04.phx.gbl>,
> > "Peo Sjoblom" <terre08@mvps.org> wrote:
> >
> >> You have to re-register the particular Excel version you want to open
> >> excel
> >> files with
> >>
> >> http://support.microsoft.com/kb/214388/en-us
> >
> >
> > The method in this article of re-registering by specificying the path to
> > the
> > version of Excel 97 (8) that I want to use does not make the change work.
> > Actually, the path is already pointing to the version I want to run. I'm
> > unning Windows XP. That article is for Windows 2000. I tried it.
> >
> > Excel 97 will open the double clicked file, if Excel 97 is already
> > running.
> > This helps a lot so far. Thanks.
> >
> > -Dennis
> >
> > --
> > Dennis Kessler
> > http://www.denniskessler.com/acupuncture
>
>



--
Dennis Kessler
http://www.denniskessler.com/acupuncture

Dennis, my suggestion works unfailingly I can say from manu years of
experience. You cannot abridge it and then say it doesn't work. You have
to do exactly what I said. Were you to wager a million dollars I would fly
to your house for a show down<g>.


--
Jim
"dk_" <nobody@spamless.com> wrote in message
news:481cc5e0$0$3385$4c368faf@roadrunner.com...
> In article <#hv#jQSrIHA.1164@TK2MSFTNGP04.phx.gbl>,
> "Jim Rech" <jrrech@live.com> wrote:
>
>> If you are comfortable using the registry editor (Start->Run:
>> Regedit.exe)
>> you can control which Excel opens XLS files like this:
>>
>> -Navigate to HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
>> -Delete or rename the "command" entry
>> -Edit "(Default)" to the full path to the Excel.exe you want e.g.
>> "c:\<full
>> path>\Excel.exe" /e
>>
>>
>> --
>> Jim
>
>
> Jim,
>
> That did not work, (I just tried).
>
> The full path was already correct in the (Default).
>
> I also deleted the entry 'in' the (command), although I didn't delete
> (command); I just deleted the contents of (command). Didn't work.
>
> I set the command back to the way it was before I edited it, and Excel
> 2007
> opens the .xls file.
>
> Thanks.
>
> -Dennis
>
>
>
>
>
>
>> "dk_" <nobody@spamless.com> wrote in message
>> news:maOSj.1042$8q4.274@newsfe15.ams2...
>> > In article <uA5qXNKrIHA.1164@TK2MSFTNGP04.phx.gbl>,
>> > "Peo Sjoblom" <terre08@mvps.org> wrote:
>> >
>> >> You have to re-register the particular Excel version you want to open
>> >> excel
>> >> files with
>> >>
>> >> http://support.microsoft.com/kb/214388/en-us
>> >
>> >
>> > The method in this article of re-registering by specificying the path
>> > to
>> > the
>> > version of Excel 97 (8) that I want to use does not make the change
>> > work.
>> > Actually, the path is already pointing to the version I want to run.
>> > I'm
>> > unning Windows XP. That article is for Windows 2000. I tried it.
>> >
>> > Excel 97 will open the double clicked file, if Excel 97 is already
>> > running.
>> > This helps a lot so far. Thanks.
>> >
>> > -Dennis
>> >
>> > --
>> > Dennis Kessler
>> > http://www.denniskessler.com/acupuncture
>>
>>
>
>
>
> --
> Dennis Kessler
> http://www.denniskessler.com/acupuncture

In article <OtNwZoWrIHA.4476@TK2MSFTNGP06.phx.gbl>,
"Jim Rech" <jrrech@live.com> wrote:

> Dennis, my suggestion works unfailingly I can say from manu years of
> experience. You cannot abridge it and then say it doesn't work. You have
> to do exactly what I said. Were you to wager a million dollars I would fly
> to your house for a show down<g>.
>
>
> --
> Jim


Jim,

The only things that I can see that I didn't do exactly as you explained,
is...

1) I only deleted the contents of (command), and I did not close regedit.
2) I did not delete the (command) item.

but I did delete the contents of (command).

Are you sure you gave me the exact right path in regedit for this to work,
because that's where I did the editing.

Also, in (Default) the Excel 97 path was already entered as you recommended.

Thanks.

-Dennis




> "dk_" <nobody@spamless.com> wrote in message
> news:481cc5e0$0$3385$4c368faf@roadrunner.com...
> > In article <#hv#jQSrIHA.1164@TK2MSFTNGP04.phx.gbl>,
> > "Jim Rech" <jrrech@live.com> wrote:
> >
> >> If you are comfortable using the registry editor (Start->Run:
> >> Regedit.exe)
> >> you can control which Excel opens XLS files like this:
> >>
> >> -Navigate to HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
> >> -Delete or rename the "command" entry
> >> -Edit "(Default)" to the full path to the Excel.exe you want e.g.
> >> "c:\<full
> >> path>\Excel.exe" /e
> >>
> >>
> >> --
> >> Jim
> >
> >
> > Jim,
> >
> > That did not work, (I just tried).
> >
> > The full path was already correct in the (Default).
> >
> > I also deleted the entry 'in' the (command), although I didn't delete
> > (command); I just deleted the contents of (command). Didn't work.
> >
> > I set the command back to the way it was before I edited it, and Excel
> > 2007
> > opens the .xls file.
> >
> > Thanks.
> >
> > -Dennis
> >
> >
> >
> >
> >
> >
> >> "dk_" <nobody@spamless.com> wrote in message
> >> news:maOSj.1042$8q4.274@newsfe15.ams2...
> >> > In article <uA5qXNKrIHA.1164@TK2MSFTNGP04.phx.gbl>,
> >> > "Peo Sjoblom" <terre08@mvps.org> wrote:
> >> >
> >> >> You have to re-register the particular Excel version you want to open
> >> >> excel
> >> >> files with
> >> >>
> >> >> http://support.microsoft.com/kb/214388/en-us
> >> >
> >> >
> >> > The method in this article of re-registering by specificying the path
> >> > to
> >> > the
> >> > version of Excel 97 (8) that I want to use does not make the change
> >> > work.
> >> > Actually, the path is already pointing to the version I want to run.
> >> > I'm
> >> > unning Windows XP. That article is for Windows 2000. I tried it.
> >> >
> >> > Excel 97 will open the double clicked file, if Excel 97 is already
> >> > running.
> >> > This helps a lot so far. Thanks.
> >> >
> >> > -Dennis
> >> >
> >> > --
> >> > Dennis Kessler
> >> > http://www.denniskessler.com/acupuncture

One addendum. Windows will use an open Excel if there is one, even if it is
a different version than the registry is set for. So make sure all Excels
are closed to test this. Check you didn't edit the .5 or .12 key also.

--
Jim
"dk_" <nobody@spamless.com> wrote in message
news:481cc5e0$0$3385$4c368faf@roadrunner.com...
> In article <#hv#jQSrIHA.1164@TK2MSFTNGP04.phx.gbl>,
> "Jim Rech" <jrrech@live.com> wrote:
>
>> If you are comfortable using the registry editor (Start->Run:
>> Regedit.exe)
>> you can control which Excel opens XLS files like this:
>>
>> -Navigate to HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
>> -Delete or rename the "command" entry
>> -Edit "(Default)" to the full path to the Excel.exe you want e.g.
>> "c:\<full
>> path>\Excel.exe" /e
>>
>>
>> --
>> Jim
>
>
> Jim,
>
> That did not work, (I just tried).
>
> The full path was already correct in the (Default).
>
> I also deleted the entry 'in' the (command), although I didn't delete
> (command); I just deleted the contents of (command). Didn't work.
>
> I set the command back to the way it was before I edited it, and Excel
> 2007
> opens the .xls file.
>
> Thanks.
>
> -Dennis
>
>
>
>
>
>
>> "dk_" <nobody@spamless.com> wrote in message
>> news:maOSj.1042$8q4.274@newsfe15.ams2...
>> > In article <uA5qXNKrIHA.1164@TK2MSFTNGP04.phx.gbl>,
>> > "Peo Sjoblom" <terre08@mvps.org> wrote:
>> >
>> >> You have to re-register the particular Excel version you want to open
>> >> excel
>> >> files with
>> >>
>> >> http://support.microsoft.com/kb/214388/en-us
>> >
>> >
>> > The method in this article of re-registering by specificying the path
>> > to
>> > the
>> > version of Excel 97 (8) that I want to use does not make the change
>> > work.
>> > Actually, the path is already pointing to the version I want to run.
>> > I'm
>> > unning Windows XP. That article is for Windows 2000. I tried it.
>> >
>> > Excel 97 will open the double clicked file, if Excel 97 is already
>> > running.
>> > This helps a lot so far. Thanks.
>> >
>> > -Dennis
>> >
>> > --
>> > Dennis Kessler
>> > http://www.denniskessler.com/acupuncture
>>
>>
>
>
>
> --
> Dennis Kessler
> http://www.denniskessler.com/acupuncture

In article <#zuDsAXrIHA.2068@TK2MSFTNGP05.phx.gbl>,
"Jim Rech" <jrrech@live.com> wrote:

> One addendum. Windows will use an open Excel if there is one, even if it is
> a different version than the registry is set for. So make sure all Excels
> are closed to test this. Check you didn't edit the .5 or .12 key also.
>
> --
> Jim


Jim,

You were exactly correct in your first instructions! . . .
I just tried again, and I this time 'deleted' the entire (command) item.
Then double-clicking on the .xls files did in fact open Excel 97.

Thank you.


But*, ...I now see that I would have to do that for each file type for Excel
97. So, . . .

Q) Is there a better way to quickly or properly switch back and forth
between Excel 97 and Excel 2007 and have each run fully and properly?

I'm guessing that I would have to un-register and re-register each
application, each time. Is that correct? And will I loose my customized
setting in each if I do this?

Thanks much.

-Dennis



> "dk_" <nobody@spamless.com> wrote in message
> news:481cc5e0$0$3385$4c368faf@roadrunner.com...
> > In article <#hv#jQSrIHA.1164@TK2MSFTNGP04.phx.gbl>,
> > "Jim Rech" <jrrech@live.com> wrote:
> >
> >> If you are comfortable using the registry editor (Start->Run:
> >> Regedit.exe)
> >> you can control which Excel opens XLS files like this:
> >>
> >> -Navigate to HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
> >> -Delete or rename the "command" entry
> >> -Edit "(Default)" to the full path to the Excel.exe you want e.g.
> >> "c:\<full
> >> path>\Excel.exe" /e
> >>
> >>
> >> --
> >> Jim
> >
> >
> > Jim,
> >
> > That did not work, (I just tried).
> >
> > The full path was already correct in the (Default).
> >
> > I also deleted the entry 'in' the (command), although I didn't delete
> > (command); I just deleted the contents of (command). Didn't work.
> >
> > I set the command back to the way it was before I edited it, and Excel
> > 2007
> > opens the .xls file.
> >
> > Thanks.
> >
> > -Dennis
> >
> >
> >
> >
> >
> >
> >> "dk_" <nobody@spamless.com> wrote in message
> >> news:maOSj.1042$8q4.274@newsfe15.ams2...
> >> > In article <uA5qXNKrIHA.1164@TK2MSFTNGP04.phx.gbl>,
> >> > "Peo Sjoblom" <terre08@mvps.org> wrote:
> >> >
> >> >> You have to re-register the particular Excel version you want to open
> >> >> excel
> >> >> files with
> >> >>
> >> >> http://support.microsoft.com/kb/214388/en-us
> >> >
> >> >
> >> > The method in this article of re-registering by specificying the path
> >> > to
> >> > the
> >> > version of Excel 97 (8) that I want to use does not make the change
> >> > work.
> >> > Actually, the path is already pointing to the version I want to run.
> >> > I'm
> >> > unning Windows XP. That article is for Windows 2000. I tried it.
> >> >
> >> > Excel 97 will open the double clicked file, if Excel 97 is already
> >> > running.
> >> > This helps a lot so far. Thanks.
> >> >
> >> > -Dennis
> >> >
> >> > --
> >> > Dennis Kessler
> >> > http://www.denniskessler.com/acupuncture

Jim & Peo,

I hate to "hijack" this thread but a related question. I have 97,2003 & 2007
all on my computer. No partitions, etc.
When on a web page and I right click on the table>import to excel, xl2007
opens (before 2007 it was 2003). I would like to have it open in 2003 again.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Jim Rech" <jrrech@live.com> wrote in message
news:%23hv%23jQSrIHA.1164@TK2MSFTNGP04.phx.gbl...
> If you are comfortable using the registry editor (Start->Run: Regedit.exe)
> you can control which Excel opens XLS files like this:
>
> -Navigate to HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
> -Delete or rename the "command" entry
> -Edit "(Default)" to the full path to the Excel.exe you want e.g.
> "c:\<full path>\Excel.exe" /e
>
>
> --
> Jim
> "dk_" <nobody@spamless.com> wrote in message
> news:maOSj.1042$8q4.274@newsfe15.ams2...
>> In article <uA5qXNKrIHA.1164@TK2MSFTNGP04.phx.gbl>,
>> "Peo Sjoblom" <terre08@mvps.org> wrote:
>>
>>> You have to re-register the particular Excel version you want to open
>>> excel
>>> files with
>>>
>>> http://support.microsoft.com/kb/214388/en-us
>>
>>
>> The method in this article of re-registering by specificying the path to
>> the
>> version of Excel 97 (8) that I want to use does not make the change work.
>> Actually, the path is already pointing to the version I want to run. I'm
>> unning Windows XP. That article is for Windows 2000. I tried it.
>>
>> Excel 97 will open the double clicked file, if Excel 97 is already
>> running.
>> This helps a lot so far. Thanks.
>>
>> -Dennis
>>
>> --
>> Dennis Kessler
>> http://www.denniskessler.com/acupuncture
>
>