Excel 97 and 2007 on same computer

[dk_]

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

 

[Peo Sjoblom]

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_]

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

 

[Jim Rech]

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

 

[dk_]

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,

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

 

[Jim Rech]

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

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,

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_]

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

 

[Jim Rech]

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

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,

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_]

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

 

[Don Guillett]

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
(e-mail address removed)

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 Rech]

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.

 

[Jim Rech]

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?

--
Jim

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.

 

[dk_]

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.
[/QUOTE]


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

 

[Jim Rech]

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.

--
Jim

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.