Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Description of the Excel 2000 SR-1 Macro Modification security update: April 25, 2002
Article ID: 306604 - View products that this article applies to.
This article was previously published under Q306604
Microsoft has re-released an update to Microsoft Excel 2000 SR-1. This update addresses a vulnerability that might allow malicious code to run in an Excel file without warning. Under typical circumstances, you will see a warning in Excel 2000 when you open a document that contains macros. However, it is possible for a malicious user to modify the macros in such a way that a macro can run with no warning issued. This might cause damage to data or allow unauthorized retrieval of data from your computer when you visit a Web site or open an e-mail message. After you apply this update, a warning appears before an Excel file that contains macros is opened.
For more information about this issue, see the Microsoft Security Bulletin MS01-50: Malformed Excel or PowerPoint Document Can Bypass Macro Security
This update was re-released on April 25, 2002 to correct the issue discussed in the following KB article:
(http://support.microsoft.com/kb/318474/EN-US/ )XL2000: AutoFormat Method Does Not Work with Macro Modification Security Patch
This article describes how to download and install the Excel 2000 SR-1 Macro Modification Security Update.
For additional information about the latest service pack for Microsoft Office 2000, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/276367/EN-US/ )OFF2000: How to Obtain the Latest Office 2000 Service Pack
How to Download and Install the UpdateUse one of the following methods to install the update, as appropriate to your situation.
Client UpdateIf you installed Microsoft Office 2000 from a CD-ROM, follow these steps to download and install the client update:
Administrative UpdateIf you installed Office 2000 from a server location, the server administrator must update the server location with the administrative public update and deploy that update to your computer.
If you are the server administrator, follow these steps to download the administrative update:
304165This article contains standard instructions for installing an administrative public update. Or, you can see the following article in the Microsoft Office 2000 Resource Kit:
(http://support.microsoft.com/kb/304165/EN-US/ )OFF2000: How to Install an Update to Administrative Installations
How to Determine Whether the Public Update Is InstalledThis update makes changes to the Excel.exe file. The file properties for Excel.exe have been updated to show that the version is 184.108.40.20619. The updated Excel.exe file has a file size of 7,159,853 bytes.
To verify whether the installation of the update was successful, make sure that the last four digits of the version of the Excel.exe file on your system is equal to or later than 5519. By default, Excel.exe is in the following location on your computer:
C:\Program Files\Microsoft Office\OfficeTo check the last four digits, follow these steps:
Issues Fixed by the UpdateThe update fixes the issues described in the following Microsoft Knowledge Base articles:
(http://support.microsoft.com/kb/272189/EN-US/ )XL2000: JPN: Nested Group Objects in Excel 95 Workbook Are Displayed in Different Location
(http://support.microsoft.com/kb/268079/EN-US/ )XL2000: OLAP Data in Excel PivotTable Is Incorrect
(http://support.microsoft.com/kb/278679/EN-US/ )OFF2000: 'This Workbook (Document) Has Been Password Protected' When You Open Workbook or Document
(http://support.microsoft.com/kb/280825/EN-US/ )XL2000: Excel Quits Unexpectedly When You Use WorkbookBeforePrint Event
(http://support.microsoft.com/kb/279673/EN-US/ )XL2000: JPN: Excel Quits Unexpectedly If You Delete Data in Cell
(http://support.microsoft.com/kb/276603/EN-US/ )XL2000: KOR: Excel Quits Unexpectedly When You Use Replace Command with Long Formulas or Strings
(http://support.microsoft.com/kb/283838/EN-US/ )XL2000: Cannot Expand PivotTable If Data Is Not Saved with Table
(http://support.microsoft.com/kb/248207/EN-US/ )XL2000: Linked Files with Lookup Functions Updated Much More Slowly Than in Earlier Versions of Excel
(http://support.microsoft.com/kb/290570/EN-US/ )XL2000: Embedded Charts in PowerPoint Exhibit Odd Behavior After Being Edited
Other Issues Fixed in This ReleaseIn addition, the following issues are also fixed:
Embedded Charts Displayed in Default Colors When Opened in HTML Format from Internet Explorer
Embedded charts on a worksheet do not retain custom colors if the workbook is saved as HTML and opened in Microsoft Internet Explorer. The same HTML file if opened in Microsoft Excel 2000 displays the custom colors as expected.
Excel Fixed Size Chart Resized When Pasted into Word
If you set a chart to a custom size in Excel, copy the chart, and then paste the chart into Microsoft Word, the chart in the Excel file changes to the size of the window.
Save Worksheet with Chart in Excel 5.0/95 Format Causes Error
Some Microsoft Excel 95 files with charts cause an invalid page fault error when saved from Excel 2000 in Excel 95 format.
JPN: VBA Macro Run-time Error
When you attempt to make a worksheet visible in Japanese Excel from within a Visual Basic for Applications macro, the method fails with run-time error '1004': Method 'Visible' of object '_Worksheet' failed.
Custom Size Chart Resized After Being Edited in Word
When you edit a custom size Excel chart in-place in Word, the chart loses the custom size.
JPN: Bad Redraw with Freeze Panes Used with Outline Group
When you outline a group in Excel, and then freeze a column in that group, the column to the left of the frozen pane may be redrawn incorrectly if you are zoomed in at less that 100%. Not all of the digits are visible.
JPN: Excel Unexpectedly Quits on Horizontal Scrolling on Print Preview Page
If you scroll horizontally with a laptop computer's touch pad while no horizontal scroll bar is visible on the print preview page, Excel may unexpectedly quit.
Excel Uses All of CPU Time While Mouse Button Is Held Down
If you hold down the mouse button in a cell on an Excel worksheet, Excel uses all of the available CPU time.
Updating Linked Sheets on IIS Server Causing Error in Web Browser
When you update a link from one Excel sheet to another Excel sheet, you receive an error message stating "Unexpected error" if the files are located on a Microsoft Internet Information Services server with Basic Authentication and the files are opened in Internet Explorer.
JPN: Inserting [Calculated Field] with a Program That Hooks Windows Messaging Causes Excel to Unexpectedly Quit
When you click the Add Field button in the Insert Calculated Field dialog box, Excel unexpectedly quits whenever a program that hooks Windows messaging is running.
Change in Binary File Can Bypass Macro Controls
An Excel workbook stream can be altered in such a way that the macros in the file run without prompting a macro warning or being stopped by macro controls.