Software

Update your Excel 2000 ToolPak for leap year

If you've migrated your users to Office 2000, here's the link to the page where you can get the update for Excel 2000.

If you’ve made the move from Office 95 or 97 to Office 2000, chances are you’re going to need to install this update for Excel 2000’s ToolPak. Here’s the scoop.

Fixes for financial calculations
Microsoft has announced that a number of financial bond functions in the Excel 2000 Analysis ToolPak (ATP) handle the year 2000 leap day improperly. The ATP is an optional add-in that is not enabled in a typical Excel installation, but if you have installed that add-in, here are the functions that are affected:
  • 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 took place on February 29, 2000. If you use any of the functions listed above, you need to get the update from Microsoft’s Excel 2000 Update page .
If you’d like to share your experiences in updating to Office 2000, please post a comment below or send us a note .
If you’ve made the move from Office 95 or 97 to Office 2000, chances are you’re going to need to install this update for Excel 2000’s ToolPak. Here’s the scoop.

Fixes for financial calculations
Microsoft has announced that a number of financial bond functions in the Excel 2000 Analysis ToolPak (ATP) handle the year 2000 leap day improperly. The ATP is an optional add-in that is not enabled in a typical Excel installation, but if you have installed that add-in, here are the functions that are affected:
  • 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 took place on February 29, 2000. If you use any of the functions listed above, you need to get the update from Microsoft’s Excel 2000 Update page .
If you’d like to share your experiences in updating to Office 2000, please post a comment below or send us a note .
0 comments

Editor's Picks