Microsoft KB Archive/164285

= SBFM97: Restore Wizard Values Does Not Recalculate Worksheet =

Article ID: 164285

Article Last Modified on 11/17/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q164285



SYMPTOMS
When you change values in the Lease Analysis of a What-If Scenario, and then click Restore Wizard Values, Microsoft Excel may not completely recalculate values in the worksheet.



CAUSE
The behavior occurs when the following conditions are true:

 You click What-If Wizard on the Accounting menu and perform a Buy vs. Lease analysis. -and-

 You change any of the following data options on the worksheet:

Number of Months Asset Held

Estimated Resale Value

Opportunity Cost of Capital

Depreciation Rate

-and-

 You click Restore Wizard Values.



RESOLUTION
To resolve this problem, force the worksheet to fully recalculate values by pressing F9.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: 2.00 97 XL97 sbfm

Keywords: kbprb KB164285

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.