Description of the Excel 2002 security patch: November 11, 2003

Microsoft has released a patch to Microsoft Excel 2002. This patch fixes a vulnerability under certain scenarios where an Excel 2002 file can be modified in such a way that a macro that includes Microsoft Excel 4.0 Macro Language (XLM) commands could run with no macro security warning issued. Additionally, many other issues are fixed as described later in this article. This Excel 2002 patch is part of the continued effort by Microsoft to provide the latest product updates to customers.

This article describes how to download and install the Microsoft Excel 2002 Security Patch: KB830350.

This security patch was first included in Office XP Service Pack 3. For additional information about the latest service pack for Office XP, click the following article number to view the article in the Microsoft Knowledge Base:

How to Download and Install the Patch

Important Before you install this patch, make sure that the following requirements have been met:

• Microsoft Windows Installer 2.0
  Before you install this patch, you must install Windows Installer 2.0 or later. For additional information about this requirement, see the "Windows Installer Patch Requirements" section of this article.
• Microsoft Office XP Service Pack 2 (SP-2)
  Before you install this patch, install Office XP SP-2.
  
  For additional information about how to install Office XP Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
  325671� OFFXP: Overview of the Office XP Service Pack 2

Client Patch

If you installed Excel 2002 from a CD-ROM, you have the following two options:

• Use the Microsoft Office Product Updates Web site to automatically install all the latest updates that include all available service packs and public updates.
• Install only the Excel 2002 Security Patch: KB830350 by following the steps that are described later in this article.

Note Microsoft recommends that you install the client patch by using the Office Product Updates Web site. The Office Product Updates Web site detects your particular installation of Microsoft Office and prompts you to install exactly what you must have to make sure that your Office installation is completely up-to-date.

Office Product Updates Web Site

To have the Office Product Updates Web site detect the required updates that you must install on your computer, visit the following Microsoft Web site: After detection is complete, you receive a list of recommended updates for your approval. Click Start Installation to complete the process.

Install Only the Excel 2002 Security Patch: KB830350

The following file is available for download from the Microsoft Download Center:
Release Date: November 11, 2003

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

After you click the link to download the patch, follow these steps:

1. Click Save to save the Officexp-kb830350-client-enu.exe file to the selected folder.
2. In Microsoft Windows Explorer, double-click Officexp-kb830350-client-enu.exe.
3. If you are prompted to install the patch, click Yes.
4. Click Yes to accept the License Agreement.
5. Insert your Office XP CD-ROM when you are prompted to do so, and then click OK.
6. When you receive a message that indicates that the installation was successful, click OK.

Note After you install the patch, you cannot remove it. To revert to an installation before the patch was installed, you must remove Office XP, and then install it again from the original CD-ROM.

Administrative Patch

If you installed your Office XP product from a server location, the server administrator must update the server location with the administrative patch and deploy that update to your computer.

The following file is available for download from the Microsoft Download Center:
Release Date: November 11, 2003

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

If you are the server administrator, after you click the link to download the administrative patch follow these steps:

1. Click Save to save the Officexp-kb830350-fullfile-enu.exe file to the selected folder.
2. In Windows Explorer, double-click Officexp-kb830350-fullfile-enu.exe.
3. If you are prompted to install the patch, click Yes.
4. Click Yes to accept the License Agreement.
5. In the Type the location where you want to place the extracted files box, type c:\KB830350, and then click OK.
6. Click Yes when you are prompted to create the folder.
7. If you are familiar with the procedure for updating your administrative installation, click Start, and then click Run.
   
   Type the following command in the Open box
   msiexec /a Admin Path\MSI File /p C:\KB830350\MSP File SHORTFILENAMES=TRUE
   where Admin Path is the path of your administrative installation point for Office XP (for example, C:\OfficeXP), MSI File is the .msi database package for the Office XP product (for example, Proplus.msi), and MSP File is the name of the administrative patch (for example, EXCELff.msp).
   
   Note You can append /qb+ to the command line so that the Office XP Administrative Installation dialog box and the End User License Agreement dialog box do not appear.
8. To deploy the patch to the client workstations, click Start, and then click Run.
   
   Type the following command in the Open box
   msiexec /i Admin Path\MSI File REINSTALL=Feature List REINSTALLMODE=vomu
   where Admin Path is the path of your administrative installation point for Office XP (for example, C:\OfficeXP), MSI File is the MSI database package for the Office XP product (for example, Proplus.msi), and Feature List is the list of feature names (case sensitive) that have to be reinstalled for the patch. To install all features, you can use REINSTALL=ALL, or you can install the features that are listed in the following table.

For additional information about how to update your administrative installation and deploy to client workstations, click the following article number to view the article in the Microsoft Knowledge Base: This article contains standard instructions for installing an administrative public update. You can also see the following article in the Microsoft Office Resource Kit. To do so, visit the following Microsoft Web site:

How to Determine If the Patch Is Installed

The patch contains updated versions of the following files:To determine the version of Microsoft Excel that is installed on your computer, follow these steps.

Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.

1. Click Start, and then click Search.
2. In the Search Results pane, click All files and folders under Search Companion.
3. In the All or part of the file name box, type Excel.exe, and then click Search.
4. In the list of files, right-click the Excel.exe file, and then click Properties.
5. On the Version tab, determine the version of Excel that is installed on your computer.

For additional information about how to determine the version of Excel that is installed on your computer, click the following article number to view the article in the Microsoft Knowledge Base: Note If the Excel 2002 Security Patch: KB830350 is already installed on your computer, you receive the following error message when you try to install the Excel 2002 Security Patch: KB830350:

Windows Installer Patch Requirements

To install the patch that is described in this article requires Windows Installer 2.0 or later. Both Microsoft Windows XP and Microsoft Windows 2000 Service Pack 3 (SP3) include Windows Installer 2.0 or later.

To install the latest version of the Windows Installer for Microsoft Windows 95, Microsoft Windows 98, and Microsoft Windows Millennium Edition (Me), visit the following Microsoft Web site: To install the latest version of the Windows Installer for Microsoft Windows NT 4.0 and Windows 2000, visit the following Microsoft Web site:

List of Issues That Are Fixed by the Patch

The Excel 2002 Security Patch: KB830350 fixes the issues that are described in the following Excel 2002 Post-Service Pack 2 Hotfix Packages: The Excel 2002 Security Patch: KB830350 fixes the issues that are described in the following Microsoft Knowledge Base articles: The Excel 2002 Security Patch: KB830350 fixes the following issues that were previously not documented in the Microsoft Knowledge Base:

• You cannot access an FTP Web aite when you Auto Republish a file.
• Data is missing in a password-protected file.
• Excel quits unexpectedly when you click Print Preview.
• Excel stops responding when you edit a long formula.
• Excel cannot complete the task when you use Track Changes.
• Combo box values revert to the default value.
• You cannot update links to files on a secure Web server.
• You receive macro error messages when you set properties on a Pivot Table.
• You receive an "Unexpected Error" error message in Web browser with Basic Authentication.
• Excel quits unexpectedly when you run a macro to insert page breaks.
• Drawing objects are moved or resized when you save a workbook.
• Incorrect file origin is listed when you open a text file.
• Error message "Unable to derive parameter information..." when you query an SQL server.
• Excel quits unexpectedly when an OLAP cube contains Null values.
• Shared workbook quit unexpectedly when you try to save.
• You receive an error message in Excel 2002.

You Cannot Access an FTP Web Site When You Auto Republish a File

When you save changes to a published Web site in Excel 2002, you may receive the following error message:

Data Is Missing in a Password-Protected File

When you open your password-protected Excel file, all the data in the file is missing.

Excel Quits Unexpectedly When You Click Print Preview

In Excel 2002, if you open a XML spreadsheet from an Office XP Spreadsheet Web Component, when you click Print Preview on the File menu, Excel may unexpectedly quit.

Excel Stops Responding When You Edit a Long Formula

In Excel 2002, when you try to edit a long formula in a cell that contains a link, Excel may stop responding (hang).

Excel Cannot Complete the Task When You Use Track Changes

When you use Track Changes and select the option to highlight changes on a new worksheet, you may receive the following error message:

Combo Box Values Revert to the Default Value

If an Excel 2002 worksheet contains two or more ActiveX combo boxes, and you change the value of the first combo box, and then make a change to another combo box, the first box may revert to its default value.

You Cannot Update Links to Files on a Secure Web Server

You cannot update links in a Microsoft Excel workbook that is located on a secure Web server that uses Web Folders. For example, you may experience one of the following behaviors:

• When you click Links on the Edit menu to update the links automatically, you may receive an error message that is similar to the following:
  Source file not found.
• When you open the workbook to update the links automatically, the links are not updated to the most current values. A #REF! error may appear in the cells.

You Receive Macro Error Messages When You Set Properties on a Pivot Table

In Excel 2002, when you run a macro code that has been converted from an earlier version of Excel, you may receive the following error messages when the macro is setting the properties of a Pivot Table:

You Receive an "Unexpected Error" Error Message in Web Browser with Basic Authentication

When you update a link from one Excel sheet to another Excel sheet, you may receive an "Unexpected error" error message if the files are located on an IIS Server with Basic Authentication and are opened in Microsoft Internet Explorer.

Excel Quits Unexpectedly When You Run a Macro to Insert Page Breaks

When you run a Microsoft Visual Basic for Applications (VBA) macro to insert page breaks in your Excel worksheet, Excel may quit unexpectedly after you receive the following error message:

Drawing Objects Are Moved or Resized When You Save a Workbook

When you save a workbook while a different workbook is the active workbook, drawing objects that are placed on a chart may move or may be resized.

Incorrect File Origin Is Listed When You Open a Text File

When you open a text file (*.txt) in Excel 2002, the Text Import Wizard may list an incorrect file origin (for example: Chinese Simplified, Japanese, or Cyrillic).

Error Message "Unable to Derive Parameter Information... " When You Query an SQL Server

In Excel 2002, when you query a Microsoft Windows 2000 SQL server, you may receive the following error messages:When you click OK, you receive the following error message:

Excel Quits Unexpectedly When an OLAP Cube Contains Null Values

If you save and close a Excel 2002 file that contains a Null values dimension from an OLAP cube in the page field of a Pivot Chart, when you reopen your workbook, Excel may quit unexpectedly.

Shared Workbook Quit Unexpectedly When You Try to Save

When you open or save a shared Excel 2002 workbook, Excel may quit unexpectedly, and you may receive the following error message:

You Receive an Error Message in Excel 2002

You receive the following Excel 2002 error message: When you view the data in the error report, the report contains an error signature that is similar to one of the following error signatures:Additionally, other program versions, module versions, and offsets are possible.