Microsoft KB Archive/834691

From BetaArchive Wiki

Article ID: 834691

Article Last Modified on 1/9/2007



APPLIES TO

  • Microsoft Office Excel 2003



SUMMARY

Microsoft has released an update to Microsoft Office Excel 2003. This update fixes a problem in Excel 2003 that can cause the RAND(), RANDBETWEEN(), SLOPE(), INTERCEPT(), FORECAST(), and STEYX() functions to return values that are not correct. This update fixes the problem so that these functions generate the correct results.

This update was first included in Microsoft Office 2003 Service Pack 1.

For additional information about the latest service pack for Office 2003, click the following article number to view the article in the Microsoft Knowledge Base:

870924 How to obtain the latest service pack for Office 2003


INTRODUCTION

This article describes how to download and install the Excel 2003 Update: KB834691.

MORE INFORMATION

How to download and install the update

Client update

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

  • Use the Microsoft Office Updates Web site to automatically install all the latest updates that include all available service packs, security patches, and updates.
  • Install only the Excel 2003 Update: KB834691 by following the steps that are described later in this article.

Note Microsoft recommends that you install the client update by using the Office Updates Web site. The Office 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 Updates Web site



To have the Office Updates Web site detect the required updates that you must install on your computer, visit the following Microsoft Web site:

Click Check for Updates. 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 2003 Update: KB834691



To download and install the client update, follow these steps:

  1. The following file is available for download from the Microsoft Download Center:

    [GRAPHIC: Download]Download the Excel 2003 Update: KB834691 client package now.
    Release Date: March 23, 2004

    For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

    119591 How to Obtain Microsoft Support Files from Online Services

    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.

    Note To obtain a localized client version of the Excel 2003 Update: KB834691, visit the following Microsoft Web site:

  2. Click Open to start the download and installation of the Excel 2003 Update: KB834691.
  3. If you are prompted to install the update, click Yes.
  4. Click Yes to accept the license agreement.
  5. Insert your Office 2003 CD-ROM if 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 update, you cannot remove it. To revert to an installation before the update was installed, you must remove Microsoft Office 2003, and then install it again from the original CD-ROM.

Administrative update

If you installed Excel 2003 from a server location, the server administrator must update the server location with the administrative update and deploy that update to your computer.

If you are the server administrator, follow these steps to download the administrative update:

  1. In Microsoft Windows Explorer, create a folder on drive C, and then name the folder kb834691.
  2. The following file is available for download from the Microsoft Download Center:

    [GRAPHIC: Download]Download the Excel 2003 Update: KB834691 full file package now.
    Release Date: March 23, 2004

    For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

    119591 How to Obtain Microsoft Support Files from Online Services

    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.
    Note To obtain a localized full-file version of Excel 2003 Update: KB834691, visit the following Microsoft Web site:

  3. Click Save to save the update installation file (for example, Office2003-kb834691-fullfile-enu.exe) to the kb834691 folder.
  4. Click Start, and then click Run.
  5. In the Open box, type cmd, and then click OK.
  6. At the command prompt, type the following lines, and then press ENTER after each line:

    cd\kb834691

    Office2003-kb834691-fullfile-enu.exe /c /t:c:\kb834691

  7. Click Yes to accept the license agreement.
  8. 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 AdminPath\MSI File /p C:\kb834691\MSP File SHORTFILENAMES=TRUE

    In this command, Admin Path is the path of your administrative installation point for Office 2003 (for example, C:\Office2003), MSI File is the .msi database package for the Office 2003 product (for example, Pro11.msi), and MSP File is the name of the administrative update.

    Note You can append the /qb+ switch to the command line so that the Office 2003 Administrative Installation dialog box and the End User License Agreement dialog box do not appear.
  9. To deploy the update to the client workstations, click Start, click Run, and then type the following command in the Open box:

    msiexec /i AdminPath\MSI File REINSTALL=Feature List REINSTALLMODE=vomu

    In this command, Admin Path is the path of your administrative installation point for Office 2003 (for example, C:\Office2003), MSI File is the MSI database package for the Office 2003 product (for example, Pro11.msi), and FeatureList is the list of feature names (case sensitive) that have to be reinstalled for the update. To install all features, you can use REINSTALL=ALL, or you can install the following feature:

    EXCELFiles

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:

829197 HOW TO: Install updates to an administrative installation of Office 2003


This article contains standard instructions for installing an administrative update. You can also view the following article in the Microsoft Office Resource Kit. To do so, visit the following Microsoft Web site:

Known issues that occur when you install the Excel 2003 Update: KB834691

Developers may not be able to access some Office assemblies after installing the update. This issue does not affect solutions that are already developed.

Note This issue is known to occur on computers that have Microsoft .Net Framework and Microsoft Windows Server 2003 or Microsoft Windows XP installed.

How to determine whether the update is installed

The update contains updated versions of the following files:

   File name     Version
   -------------------------
   Excel.exe     11.0.6113.0

To determine the version of Excel 2003 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, under Search Companion, click All files and folders.
  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 Excel.exe, and then click Properties.
  5. On the Version tab, determine the version of Excel 2003 that is installed on your computer.

For additional information about how to determine the version of Excel 2003 on your computer, click the following article number to view the article in the Microsoft Knowledge Base:

821549 HOW TO: Check the version of Office 2003


Note If the Excel 2003 Update: KB834691 is already installed on your computer, you receive the following error message when you try to install the Excel 2003 Update: KB834691:

This update has already been applied or is included in an update that has already been applied.

List of issues fixed by the update

The Excel 2003 Update: KB834691 fixes the issues that are described in the following Microsoft Knowledge Base article:

833855 Excel 2003 hotfix package: February 29, 2004


Keywords: kboffice2003sp1fix kbfunctions kbfix kbbug kboffice2003presp1fix kbinfo kbupdate KB834691