The Excel 2002 Update: October 16, 2002 offers you the latest stability and security features to Microsoft® Excel 2002. This update helps prevent users from unintentionally updating links to external data within Excel spreadsheets. The Excel 2002 Update: October 16, 2002 is part of Microsoft's continuing effort to provide the latest product updates to customers.
Toolbox The full-file version of the Excel 2002 Update: October 16, 2002, consists of one Windows Installer patch file (MSP format) packaged in a self-extracting executable (Exc1003a.exe). You can find this downloadable file on the Office XP Resource Kit Downloads page.
Localized versions of this update are listed later in this article.
Note The full-file version of the Excel 2002 update will install successfully on Office XP SP1 or SP2 installations.
Strategies for updating your Excel 2002 installations
The recommended method for distributing the Excel 2002 update is first to update your administrative installation point, and then recache and reinstall Excel on your users' computers to apply the changes. This is the standard update procedure presented for all previous Office XP updates, and it's still the most effective way to distribute software in a security-enhanced environment. Details on using this method are covered below in the section "Applying the Excel 2002 update to an administrative installation point."
An alternative to the administrative update strategy is to apply the binary (client) version of the Excel 2002 update directly to users' computers within your organization. This approach may be useful if you have experienced synchronization problems between your administrative installation points and your client computers. Details on this strategy are covered in the topic Distributing Office 2000 Client Updates to Users. The client version of the Excel 2002 update is available from the Office Update Web site.
Note Normally, the installation of client update files requires that the computer be running Windows Installer version 2.0 or higher. For the Excel 2002 update, a special version of the file is available to support computers running Windows Installer 1.1. Information on deploying this file is covered below in the section "Using client update files with Windows Installer 1.1."
A third option is to apply the full-file updates directly to client computers. This method is an efficient way to ensure that all users have the most current version of the software when you do not know which updates users have applied. In addition, users can apply a full-file patch even if they do not have access to the administrative source. However, these client computers remain out of sync with the updated source until they reinstall Office from the original installation point.
Details on this strategy, and a more complete comparison of the three update methods, can be found in the article Strategies for Updating Office 2000 Installations.
Applying the Excel 2002 update to an administrative installation point
The full-file administrative update file for the Excel 2002 update is a Microsoft Windows Installer patch (MSP file) you apply to your administrative share by using a command line with specific parameters. The following table lists the MSP file.
| MSP file name |
Description |
| EXCELff.msp |
Updates both SP1 and SP2 versions of Excel 2002 |
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
- Download the Exc1003a.exe and double-click the file name to extract the MSP file.
- 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 the task.
- On the Start menu, click Run and then type the command line for Windows Installer with the appropriate options for Excel 2002. 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]
You must run the command line separately for each MSP file you apply to the administrative installation point — you cannot reference multiple MSP files on the same command line. 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 client computers that use the administrative image. Any new client installations from the administrative installation image will automatically include the Excel 2002 update.
Note If you originally installed Excel 2002 on a client computer from an updated 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.
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 /qb
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. |
| /qb |
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.
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
- 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.
- Open the Software Installation snap-in within the Group Policy Object (GPO) that you are using to manage the existing Office installation.
- 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.
Using client update files with Windows Installer 1.1
If you plan to install the Excel 2002 update on a client computer using Windows Installer 1.1, you will need to deploy a special version of the file. The regular client version of this update requires the use of Windows Installer 2.0. This requirement applies if any client installation of Microsoft Office has been updated with two service packs using client patches.
The Excel 2002 Update: October 16, 2002 for Windows Installer 1.1 provided here can be applied to client installations which have been previously updated using administrative images, without requiring an update to Windows Installer 2.0. For more information on using client updates such as this one, see Distributing Office 2000 Client Updates to Users.
Toolbox The Excel 2002 Update: October 16, 2002, for Windows Installer 1.1 client installations is a self-extracting executable (Exc1003n.exe). You can find this downloadable file on the Office XP Resource Kit Downloads page.
Localized versions of this download are listed below.
Avoid patching problems by upgrading to Windows Installer 2.0
If you installed Microsoft Office XP from the Office CD and subsequently installed both Office XP Service Pack 1 and Office XP Service Pack 2, then Windows Installer 1.1 will prevent you from installing any future updates. Organizations that deployed Office XP from an administrative installation point and subsequently applied client updates (binary patches) for both Office XP SP1 and SP2 will encounter the same Windows Installer 1.1 limitation.
This problem is easily avoided by upgrading to Windows Installer 2.0. (Office XP shipped with Windows Installer 1.1). Windows Installer 2.0 is included by default in Microsoft Windows XP and Windows 2000 Service Pack 3. For organizations running a previous version of Windows, it is available as a separate download from the Microsoft Download Center:
Windows Installer 2.0 for Windows 95, Windows 98, and Windows ME
Windows Installer 2.0 for Windows NT 4.0 (SP-6) and Windows 2000
Localized versions
Localized versions of this update are available in the following languages and can be downloaded from the Office XP Resource Kit Localized Tools page:
| Arabic |
German |
Portuguese (Portugal) |
| Bulgarian |
Greek |
Romanian |
| Chinese (Pan) |
Hebrew |
Russian |
| Chinese (Simplified) |
Hungarian |
Slovak |
| Chinese (Trad.) |
Italian |
Slovenian |
| Croatian |
Japanese |
Spanish |
| Czech |
Korean |
Swedish |
| Danish |
Latvian |
Thai |
| Dutch |
Lithuanian |
Turkish |
| Estonian |
Norwegian |
Ukrainian |
| Finnish |
Polish |
|
| French |
Portuguese (Brazil) |
|
Files changed by the Excel 2002 update
The following table lists the file changed by the Excel 2002 full-file update. If you need to confirm whether a share has been updated, you can check the file version number.
| File |
Version |
| Excel.exe |
10.0.4524.0 |
Related links
For an overview of the Excel 2002 update: October 16, 2002, see Overview of Excel 2002 SP-2 Update: October 16, 2002 in the Microsoft Knowledge Base.
For general information on applying an administrative update, see Deploying Product Updates from an Administrative Installation Point in the Office XP Resource Kit.