XL: Running Multiple Versions of Microsoft Excel for Macintosh (182702)

MORE INFORMATION

This article lists some of the common problems that are associated with running multiple versions of Excel. However, you may encounter problems that are not listed in this article.

In most cases, the only solution to problems created by running multiple versions of Excel is to run only one version of Excel on your computer.

Double-Clicking Files in Finder Starts Earlier Version of Excel

When you double-click a Microsoft Excel workbook, chart, or add-in file in the Finder, the wrong version of Excel may be started, and the file is not opened. For example, double-clicking an workbook saved in the Microsoft Excel 98 Macintosh Edition file format starts Excel version 5.0.

This problem occurs because the installation program for Excel 5.0 sets the modified date of the program file for Excel 5.0 to the date of installation. If this date is later than the modified date of the program file for Excel 98, Excel 5.0 is started when you use the Finder to double- click an Excel workbook file.

To reduce the probability that this problem occurs, install Excel 98 and Excel 5.0 on separate hard disk partitions. If you keep Excel 98 files on the hard disk partition that contains Excel 98, this problem should not occur.

NOTE: This workaround may not work in all cases.

Inserting Microsoft Excel Objects into Other Programs

If you install multiple versions of Microsoft Excel on a single computer and you insert a Microsoft Excel Worksheet object into another program (for example, Microsoft Word), the latest version of Microsoft Excel is used when you insert the worksheet object.

For example, if you install the following programs on your computer and then insert a Microsoft Excel Worksheet object into a Microsoft Word document, an Excel 98 worksheet is added.

If you give a copy of a Word document containing a Microsoft Excel Worksheet object to someone who does not have Excel 98, and the person attempts to activate the object, the following error message appears: NOTE: When you click Object on the Insert menu in Microsoft Word or Microsoft PowerPoint, the following entries may appear in the Object type list: An Excel 98 worksheet or chart object is inserted into the document regardless of the list entry that you click.

Using Automation to Control Microsoft Excel

If you install multiple versions of Microsoft Excel on a computer and you attempt to use Automation to control a specific version of Microsoft Excel, it may be necessary to modify your Visual Basic for Applications code.

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. For example, if you run the following Visual Basic for Applications macro in Microsoft Word 97 while Excel 5.0 and Excel 98 are installed on your computer

   Sub AutomationTest()

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

   End Sub
				

you receive the following error message: To work around this problem, change the Set line to the following:

   Set xlApp = CreateObject("Excel.Application.8")
				

The macro starts an instance of Excel 98, displays the version number of Excel, then terminates Excel.

NOTE: You cannot use Automation to start Excel 5.0 if Excel 98 is installed on your computer.

Shared Programs

The Object dialog box may display more than one entry for each shared program; this behavior occurs because there may be multiple versions of the shared program on your computer.

Problems Using Microsoft Query

If both Microsoft Query version 1.0 and Microsoft Query version 8.0 are installed on your computer, you receive error messages when you use Microsoft Query 8.0. To use Microsoft Query 8.0, you must remove Microsoft Query 1.0 from your computer.

For additional information about this problem, please see the following article in the Microsoft Knowledge Base: