Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/175081

From BetaArchive Wiki
Knowledge Base


Article ID: 175081

Article Last Modified on 4/21/2001



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q175081

SYMPTOMS

If you use a financial function from the Analysis ToolPak in Microsoft Excel 97, and you pass a date greater than 12/31/2078 to the function, the function may return the #NUM! error value.

CAUSE

Even though Microsoft Excel 97 normally supports dates up to 12/31/9999, the latest date that you can use with the financial functions in the Analysis ToolPak in Microsoft Excel 97 is 12/31/2078.

RESOLUTION

This problem is corrected in the Analysis ToolPak included in the Microsoft Office 97 Service Release 1 (SR-1) Enterprise Update.

To resolve the problem described above, install Microsoft Office 97 Service Release 1 (SR-1) Enterprise Update. To do this, follow these steps:

  1. On the Start menu, point to Settings, and then click Control Panel.
  2. Double-click Add/Remove Programs. In the list of installed programs, click Microsoft Office 97, and then click Add/Remove. If you installed Microsoft Office from a CD, you are prompted to insert the first CD.


If a dialog box indicates that programs are running, quit the programs, and then click OK.

  1. In the Microsoft Office 97 Setup dialog box, click Remove All.
  2. When you are prompted to remove shared components, click Remove All.
  3. If you are prompted to restart the computer after Setup is finished, do so.
  4. Install Microsoft Office 97 Service Release 1 (SR-1) Enterprise Update.


STATUS

This problem was corrected in the Analysis ToolPak included with the Microsoft Office 97 Service Release 1 Enterprise Update. This problem no longer occurs in Microsoft Excel 2000.

MORE INFORMATION

If you install the Microsoft Office 97 Service Release 1 (SR-1) Patch, the Analysis ToolPak is not updated, and the problem still occurs.

REFERENCES

For more information about the Analysis ToolPak, click Contents And Index on the Help menu, click the Index tab in Microsoft Excel Help, type the following text

analysis


and then double-click the selected text to go to the "Ways to analyze statistics" topic.


Additional query words: XL97 atp y2k year2000

Keywords: kbprb KB175081