Update your Excel 2000 ToolPak for leap year
Takeaway: 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 .
SponsoredWhite Papers, Webcasts, and Downloads
- BitLocker: Is It Really Secure? Global Knowledge
- Simple Tricks to Ace the Subnetting Portion of Any Certification Exam Global Knowledge
- Eleven Myths about 802.11 Wi-Fi Networks Global Knowledge
- 7 Things Every System Administrator Should Know About OpenSSH Global Knowledge
- 2007 IT Salary and Skills Survey: What Impacts Salaries? Global Knowledge
Article Categories
- Security
- Security Solutions, IT Locksmith
- Networking and Communications
- E-mail Administration NetNote, Cisco Routers and Switches
- CIO and IT Management
- Project Management, CIO Issues, Strategies that Scale
- Desktops, Laptops & OS
- Windows 2000 Professional, Microsoft Word, Microsoft Excel, Microsoft Access, Windows XP,
- Data Management
- Oracle, SQL Server
- Servers
- Windows NT, Linux NetNote, Windows Server 2003
- Career Development
- Geek Trivia
- Software/Web Development
- Web Development Zone, Visual Basic, .NET
