Excel 97 and 2007 on same computer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dk_ - 02 May 2008 22:49 GMT

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

Signature

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

Reply to this Message

Peo Sjoblom - 02 May 2008 23:24 GMT

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

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

Signature

Regards,

Peo Sjoblom

> How can I *re-set* Windows XP SP2 to open all of my Excel files
> (.xls.xlt.csv) in Excel 97 when double-clicking?
[quoted text clipped - 6 lines]
>
> -Dennis

Reply to this Message

dk_ - 03 May 2008 01:17 GMT

> 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

Signature

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

Reply to this Message

Jim Rech - 03 May 2008 14:46 GMT

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

Signature

Jim

>
>> You have to re-register the particular Excel version you want to open
[quoted text clipped - 14 lines]
>
> -Dennis

Reply to this Message

dk_ - 03 May 2008 21:06 GMT

> If you are comfortable using the registry editor (Start->Run: Regedit.exe)
> you can control which Excel opens XLS files like this:
[quoted text clipped - 3 lines]
> -Edit "(Default)" to the full path to the Excel.exe you want e.g. "c:\<full
> path>\Excel.exe" /e

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

> >> You have to re-register the particular Excel version you want to open
> >> excel
[quoted text clipped - 13 lines]
> >
> > -Dennis

Signature

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

Reply to this Message

Jim Rech - 03 May 2008 23:07 GMT

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>.

Signature

Jim

>
>> If you are comfortable using the registry editor (Start->Run:
[quoted text clipped - 44 lines]
>> >
>> > -Dennis

Reply to this Message

dk_ - 03 May 2008 23:50 GMT

> 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,

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

> >> If you are comfortable using the registry editor (Start->Run:
> >> Regedit.exe)
[quoted text clipped - 43 lines]
> >> >
> >> > -Dennis

Reply to this Message

Jim Rech - 03 May 2008 23:51 GMT

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.

Signature

Jim

>
>> If you are comfortable using the registry editor (Start->Run:
[quoted text clipped - 44 lines]
>> >
>> > -Dennis

Reply to this Message

dk_ - 04 May 2008 00:08 GMT

> 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,

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

> >> If you are comfortable using the registry editor (Start->Run:
> >> Regedit.exe)
[quoted text clipped - 43 lines]
> >> >
> >> > -Dennis

Reply to this Message

Jim Rech - 04 May 2008 17:09 GMT

>>I now see that I would have to do that for each file type for Excel

97. So, . . .

But how many types of files will you be opening in Excel 97? XLS, and?
Maybe CVS?

If I had to switch between versions frequently I'd try this:

-Set up the registry for Excel 97 and then select the Excel.Sheet.8 key in
Rededit and do a File, Export and save it as Excel97.Reg

Do the same for other versions. I'd copy both to the Desktop and then just
double-click the one you wanted to have control.

Signature

Jim

>
>> One addendum. Windows will use an open Excel if there is one, even if it
[quoted text clipped - 75 lines]
>> >> >
>> >> > -Dennis

Reply to this Message

dk_ - 04 May 2008 22:16 GMT

> >>I now see that I would have to do that for each file type for Excel
> 97. So, . . .
[quoted text clipped - 9 lines]
> Do the same for other versions. I'd copy both to the Desktop and then just
> double-click the one you wanted to have control.

Jim,

Very nice idea with the .reg exports! Thanks.

Regarding how many file types, probably only xls,csv,xlt, but I was thining
there may be some other type working in the background, but maybe that
doesn't happen.

Thanks again.

-Dennis

> >> One addendum. Windows will use an open Excel if there is one, even if it
> >> is
[quoted text clipped - 74 lines]
> >> >> >
> >> >> > -Dennis

Reply to this Message

Don Guillett - 04 May 2008 14:35 GMT

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.

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> If you are comfortable using the registry editor (Start->Run: Regedit.exe)
> you can control which Excel opens XLS files like this:
[quoted text clipped - 21 lines]
>>
>> -Dennis

Reply to this Message

Jim Rech - 04 May 2008 17:12 GMT

I'm on the run right now, Don, but I'll look at it later if no one beats me
to it. I assume changing the Open key per this thread doesn't do it?

Signature

Jim

> Jim & Peo,
>
[quoted text clipped - 30 lines]
>>>
>>> -Dennis

Reply to this Message

Jim Rech - 05 May 2008 00:42 GMT

It looks as if this key controls "Export to MS Excel" on my machine:

HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}\LocalServer32

Set "(Default)" to the path to your favored Excel version (include
/automation if you want it the way Excel does it) and rename "LocalServer32"
to "LocalServer32x" or whatever.

Yes, "LocalServer32" occurs twice - once as part of the path and again as
the actual entry itself.

Signature

Jim

> Jim & Peo,
>
[quoted text clipped - 30 lines]
>>>
>>> -Dennis

Reply to this Message