Microsoft KB Archive/165381

= SBFM97: What-If Scenario Name Does Not Appear in Overview =

Article ID: 165381

Article Last Modified on 8/5/2004

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q165381



SYMPTOMS
When you open a What-If workbook, the scenario you saved is not listed in the What-If Scenario list of saved scenarios.



CAUSE
This problem occurs when all of the following conditions are true:


 * You import Quickbooks accounting data. -and-


 * You create a What-If Analysis, and then save and close the workbook. -and-


 * You update the Quickbooks accounting data, and then open the saved workbook



WORKAROUND
To work around this problem, use the following steps:


 * 1) Open the saved What-If workbook.
 * 2) Click a function, such as Profitability.
 * 3) In the dialog box for the function, in the Choose a Category for Analysis box, click Product, and then click OK.

Note that you do not need to make any changes to this page.
 * 1) Click What-If Overview to go back to the Overview page. Save the workbook.

This step updates the analysis with the updated accounting information. The saved scenario appears in the What-If Scenario list.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem has been fixed in the updated versions of the Quickbooks driver and Msapp.dll.

The following file is available for download from the Microsoft Download Center:

Sbfm97qb.exe

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.



MORE INFORMATION
For additional information, please see the following article in the Microsoft Knowledge Base:

164747 SBFM97: Error Updating Accounting Data

Additional query words: XL97 8.00 sbfm sbe sbfm97qb exe

Keywords: kbdownload kbprb KB165381

-

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

© Microsoft Corporation. All rights reserved.