You are currently offline, waiting for your internet to reconnect

Running Multiple Versions of Microsoft Excel

This article was previously published under Q166692
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Although Microsoft does not recommend installing more than one version ofMicrosoft Excel on a computer, it is possible to install and use more thanone version. For example, you can install and use both Microsoft Excel 97and Microsoft Excel 7.0 on the same computer.

This article describes the problems you may encounter when you install morethan one version and offers advice about preventing the versions ofMicrosoft Excel from conflicting with each other.

Order of Installation

To install and use more than one version of Microsoft Excel on a singlecomputer, install earlier versions of Microsoft Excel first.

For example, if you want to use both Microsoft Excel 5.0 and MicrosoftExcel 97 on the same computer, you must install Microsoft Excel 5.0 FIRST.This is necessary because of the way registry keys, shared programs, andother settings are managed for each version of Microsoft Excel.

NOTE: The following sections assume that you installed the versions ofMicrosoft Excel in ascending order.

Running Multiple Versions of Microsoft Excel Simultaneously

Although it is possible to run more than one version of Microsoft Excelsimultaneously on the same computer, Microsoft strongly recommends that youavoid doing this. For example, if you want to start Microsoft Excel 5.0,first quit all other versions of Microsoft Excel that may be running.

Double-Clicking Files in the Windows Explorer

When you double-click a Microsoft Excel workbook (.xls) file, chart (.xlc)file, or add-in (.xla) file in Windows Explorer, the following rules apply:

  • If a version of Microsoft Excel is already running, the file is opened in the running version of Microsoft Excel.
  • If no version of Microsoft Excel is running, the file is opened in Microsoft Excel 5.0 if it is installed on your computer; if Microsoft Excel 5.0 is not installed, the file is opened in the version of Microsoft Excel that you most recently installed on your computer.

    See the "Reassociating Microsoft Excel Files" section for more information about this behavior.
NOTE: If you double-click a file that is not supported by the version ofMicrosoft Excel that is running or that is automatically started, youreceive the following error message:
<Filename>: file format is not valid.
If you receive this error message, start the later version of MicrosoftExcel. Then, open the file by double-clicking it or by using the Opendialog box (click Open on the File menu).

Reassociating Microsoft Excel Files

When you start Microsoft Excel 5.0, Microsoft Excel files (.xls, .xlc, and.xla files) are automatically associated with it.

When you start them, Microsoft Excel 7.0 and Microsoft Excel 97 are notautomatically associated Microsoft Excel files; they perform this task onlywhen you install these programs.

Because of this difference in behavior, if you start Microsoft Excel 5.0, aMicrosoft Excel file that you double-click is always opened in MicrosoftExcel 5.0, unless another version of Microsoft Excel is already running.

If you want to double-click a file and open it in a newer version ofMicrosoft Excel, you can associate Microsoft Excel files with MicrosoftExcel 7.0 or 97 by using either of the following methods.

Method 1

Run Microsoft Excel Setup or Microsoft Office Setup with the /y switch.Using /y instructs the Setup program to register all of the registry keysthat are used by Microsoft Excel and to associate Microsoft Excel fileswith the version of Microsoft Excel that you are installing.

Method 2

Use the File Types tab in the Options dialog box to associate MicrosoftExcel files with Microsoft Excel 7.0 or 97. To do this, use the followingsteps:

  1. Double-click My Computer.
  2. On the View menu, click Options. Then, click the File Types tab.
  3. In the list of registered file types, scroll down and click Microsoft Excel Worksheet. Then, click Edit.
  4. In the list of Actions, click Open. Then, click Edit.
  5. In the "Application used to perform action" box, change the path to the Microsoft Excel program file (Excel.exe) so that it refers to the Excel.exe file for Microsoft Excel 7.0 or Microsoft Excel 97.

    If you are unsure of the location for Excel.exe, click Browse to search for the file.
  6. Click OK. Then, click Close, and then click Close again to close the Options dialog box.
NOTE: If you use one of these methods and you start Microsoft Excel 5.0,Microsoft Excel files are automatically reassociated with Microsoft Excel5.0. There is no way to prevent this behavior from occurring. If you wantto ensure that a Microsoft Excel file is opened in a specific version ofMicrosoft Excel, start that version of Microsoft Excel BEFORE you open thefile, or use the Open dialog box to open files.

Inserting Microsoft Excel Objects into Other Programs

If you install multiple versions of Microsoft Excel on a single computerand you insert a Microsoft Excel Worksheet object into another program (forexample, Microsoft Word), the latest version of Microsoft Excel is usedwhen you insert the worksheet object.

For example, if you install the following programs on your computer

   Microsoft Word for Windows, version 6.0   Microsoft Excel for Windows, version 5.0   Microsoft Excel 97				

and then insert a Microsoft Excel Worksheet object into Microsoft Word, aMicrosoft Excel 97 worksheet is added.

Using Automation to Control Microsoft Excel

If you install multiple versions of Microsoft Excel on a computer, you mayexperience difficulty when you attempt to use Automation to control aspecific version of Microsoft Excel.

For example, if you run the following Visual Basic for Applicationssubroutine in Microsoft Word 97

   Sub AutomationTest()       Dim xlApp As Object       Set xlApp = CreateObject("Excel.Application")       MsgBox xlApp.Version       xlApp.Quit       Set xlApp = Nothing   End Sub				

the subroutine always creates an Automation session in the version ofMicrosoft Excel that you most recently installed. So, if you install bothMicrosoft Excel 5.0 and Microsoft Excel 97 on the same computer, themessage box in the example displays 8.0, the version number of MicrosoftExcel 97.

If you want to control a specific version of Microsoft Excel usingAutomation, you use the class names that are listed in the following table.

   Version of   Microsoft Excel   Class Name   -------------------------------------   97                Excel.Application.8   7.0               Excel.Application.5   5.0               Excel.Application.5				

NOTE: Microsoft Excel 5.0 and 7.0 both use the same class name,Excel.Application.5. Therefore, if Microsoft Excel 5.0 and 7.0 are bothinstalled on the same computer, Excel.Application.5 always applies toMicrosoft Excel 7.0. There is no way to prevent this behavior. BecauseMicrosoft Excel 5.0 and 7.0 both use the same file format and offer similarfeatures, you should be able to use Microsoft Excel 7.0 instead ofMicrosoft Excel 5.0.

Shared Programs

You should not experience any problems when you use shared programs, suchas Microsoft Equation Editor and Clip Gallery, with any version ofMicrosoft Excel. Note that the Object dialog box may display more than oneentry for each shared program; this behavior occurs because there may bemultiple versions of the shared program on the computer.

XL97 XL7 XL5 ole automation XL

Article ID: 166692 - Last Review: 08/17/2005 18:14:28 - Revision: 1.3

  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • kbhowto kbinfo kbprogramming KB166692