

Download Details Download Now! Download to Online Storage

Using: x:Drive Driveway (What's Online Storage?) Works with

Excel 2000

Filename

atpy2k.exe Filesize

230 kb Est. Download Time

@28.8 2 mins Last Updated

17-Dec-1999 Languages Supported

US English

Return to Catalog

or Focus Center Excel 2000 Update: Analysis ToolPak Update for Leap Year Additional testing has revealed that a number of financial bond functions in the Microsoft Excel 2000 Analysis ToolPak (ATP) handle the year 2000 leap day improperly. The ATP is an optional add-in which is not enabled in a typical Excel installation. The affected ATP functions are: ACCRINT

COUPDAYBS

COUPDAYS

COUPDAYSNC

COUPPCD

COUPNCD

DURATION

MDURATION

ODDFPRICE

ODDFYIELD

PRICE

YIELD These functions are only affected when the bond's maturity, settlement, or first interest payment takes place on February 29, 2000. If you use any of the ATP functions listed above, you need to install this update. For more information about the ATP problem, read the Microsoft Knowledge Base article (Q247795) XL2000: Some Financial Functions May Return Incorrect Results with February 29, 2000. To install the ATP Update, you will need either Excel 2000 or Office 2000 installed on your computer.

To install this download: You may want to print this page to use as a reference when you are offline. Download the file from Office Update by clicking Download Now! at the top left of this page and following the instructions in the dialog boxes. Double-click the Atpy2k.exe program file on your hard disk to start the setup program. Follow the instructions on the screen to complete the installation. Instructions for use: Once you have installed the Analysis ToolPak Update, use Excel as you normally would. To remove this download: This update cannot be removed. The ATP Update replaces the Analysis ToolPak that is installed on your computer with Excel 2000. To sign-up for the Office Update Notification Email: The Microsoft Office Auto Update Notification is an Email List that users can join if they are interested in finding out when new updates are added to Office Update. The Notification Emails contain the name of the update, the URL where to get the update, a description of the update, and the products that are affected by the update. For support of this download: If you are experiencing problems with this download or the Office Update site, please review our Support Page for assistance.



Additional Information Languages Supported

All languages for which Office is available (including Office MultiLanguage Pack installations).

é © 2000 Microsoft Corporation.

All rights reserved. Terms of use. Disclaimer.

