Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Excel 2002 Update: June 19, 2002
 

The administrative version of the Excel 2002 Update: June 19, 2002, prevents Excel from potentially running macros without warning.


Toolbox   The Excel 2002 update consists of one Windows Installer patch file (MSP format) packaged in a self-extracting executable (Exc1002a.exe). You can find this downloadable file on the Office XP Resource Kit Downloads page.

Localized versions of this update are listed in a table later in this article.


Applying the Excel 2002 update to an administrative installation point

You apply the Excel 2002 update to your administrative share by using a command line with specific parameters. The following table lists the MSP files included in this update.

MSP file name Description
EXCEL_Admin.msp Administrative version of the Excel 2002 update.

Before you install the Excel 2002 update on either an administrative installation point or a stand-alone computer, the current installation of Excel 2002 must be updated to version SP1.


 Note    For best results, the update should be applied from the computer that contains the administrative installation point. Make sure the files on the administrative installation point are not in use when you apply the update. Copy the updated administrative installation image to all installation points after you back up any custom transform, Setup.ini, or other custom files.


To apply the Excel 2002 update to an administrative installation point
  1. Download Exc1002a.exe and double-click the file name to extract the MSP file.
  2. Connect to the administrative installation point.

    Note that you must have write access to the administrative installation point on the server and the appropriate privileges to carry out this task.

  3. On the Start menu, click Run and then type the command line for Windows Installer with the appropriate options for the Excel 2002 update. Use the following syntax:
    [start] msiexec /p [path\name of update MSP file] 
    /a [path\name of MSI file]
    SHORTFILENAMES=TRUE /qb /L*v [path\name of log file]
    

The following table describes the command-line options.

Command-line option Description
[start] Required only for Microsoft Windows® 98 systems where Msiexec is not directly in the path.
msiexec Executable file name for Windows Installer.
/p Enables Windows Installer to apply an update to an existing installation.
[path\name of update MSP file] Path and file name of the MSP file for the update.
/a Enables Windows Installer to perform an administrative installation of a product on a network share.
[path\name of MSI file] Path and file name to updated MSI file on the administrative image. For example: \\server\share\Proplus.msi
SHORTFILENAMES=TRUE Directs Windows Installer to create all file names and folders with MS-DOS-compatible file names. Required when you run Windows Installer from the command line.
/qb Sets the user interface to the basic level (simple progress and error handling). This switch is optional on the command line.
/L*v Turns on logging and sets a path for the log file. The * flag causes the switch to log all information. This switch is optional on the command line.
[path\name of log file] Path and file name of the Windows Installer log file. Used only with the /L*v switch.

Updating client computers from an administrative installation point

After you update your administrative installation point, you must recache and reinstall Excel 2002 on existing client computers that use the administrative image. Any new client installations from the administrative installation image will automatically include the Excel 2002 update.

To update an existing client installation from an administrative installation point, run the following command line on the client computer:

start msiexec /i [path to updated .msi file on the admin image]
REINSTALL=[list of features] 
REINSTALLMODE=vomu /q

You can run this command line by creating a logon script, distributing it as a batch file, deploying it by using Systems Management Server, or using other software installation tools. The following table describes the command-line options.

Command-line option Description
[start] Required only for Windows 98 systems where Msiexec is not directly in the path.
msiexec Executable file name for Windows Installer.
/i Enables Windows Installer to apply an update to an existing installation.
[path to updated .msi file on the administrative image] Path and file name of the Microsoft Installer package (MSI file) on the administrative installation point.
REINSTALL=[list of features] Specifies whether you want to reinstall specific features or reinstall all applications on the administrative image.
REINSTALLMODE=vomu Triggers the recache and reinstallation on the client computer.
/q Suppress the End User License Agreement dialog box so administrators or end users will not be prompted by this dialog box.

For the Excel 2002 update, the value for [list of features] is as follows:

EXCELFiles

Optionally, you can substitute the parameter REINSTALL=ALL to reinstall all Office XP components on the client computer.


 Note    If you originally installed 2002 on a client computer from an administrative installation point, you must follow the recache and repair procedure described above to update that client. If you update the client directly by using the end-user patch from the Office Update Web site, the client and administrative images become out-of-sync, which may cause future updates to fail.

As an alternative, you can deploy the Excel 2002 update within your organization by distributing the version for client computers from local servers. For more information about this strategy, see Distributing Office 2000 Client Updates to Users.


Applying the Excel 2002 update under Windows 2000 or Windows XP

If your administrative installation point and all of your client computers are running Microsoft Windows 2000 or Windows XP, you can use IntelliMirror® technology to manage the installation of the update.


 Note    Be sure to test all software updates in a controlled setting before modifying your administrative installation point or deploying the new version throughout your organization.


To deploy a QFE fix or update under Windows 2000 or Windows XP
  1. Apply the update (MSP file) to the original Office administrative installation point.

    You will need to run the command line separately if you apply more than one MSP file to the administrative installation point — you cannot reference multiple MSP files on the same command line.

  2. Open the Software Installation snap-in within the Group Policy Object (GPO) you are using to manage the existing Office installation.
  3. In the details pane, right-click the Office package, point to All Tasks, and then click Redeploy application.

    The next time the Group Policy is applied to the designated users or computers, the updated files are copied to their computers.

Note that you can redeploy a package only if it is being managed by Group Policy — that is, only if you originally installed it by using IntelliMirror software installation and maintenance, or if you brought it into a managed state under Windows 2000 or Windows XP.

Localized versions

Localized versions of the Excel 2002 update are available in the following languages and can be downloaded from the Office XP Resource Kit Localized Tools page:

Arabic German Portuguese (Brazil)
Bulgarian Greek Portuguese (Portugal)
Chinese (Pan) Hebrew Romanian
Chinese (Simplified) Hungarian Russian
Chinese (Trad.) Italian Slovak
Croatian Japanese Slovenian
Czech Korean Spanish
Danish Latvian Swedish
Dutch Lithuanian Thai
Estonian Norwegian Turkish
Finnish Polish Ukranian
French

Related links

For a list of specific changes included in the Excel 2002 update, see Overview of Excel 2002 Update: June 19, 2002 in the Microsoft Knowledge Base.

For the client version of the Excel 2002 update, please see Excel 2002 Update: June 19 2002 - included in the Office XP Update: Service Pack 2 (SP2)on the Microsoft Office Update Web site.

For general information on applying an administrative update, see Deploying Product Updates from an Administrative Installation Point in the Office XP Resource Kit.

For an inventory tool that helps administrators determine, from a central location, the status Office 2000 updates applied to client computers, see Office Update Inventory Tool 2.1 Checks Installations for Updated Status in the Office XP Resource Kit.

© 2009 Microsoft Corporation. All rights reserved.