SBFM97: What-If Scenario Name Does Not Appear in Overview (165381)
The information in this article applies to:
- Microsoft Excel 97 for Windows
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:
- Open the saved What-If workbook.
- Click a function, such as Profitability.
- 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. - 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: 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.
| Modification Type: | Minor | Last Reviewed: | 8/5/2004 |
|---|
| Keywords: | kbdownload kbprb KB165381 |
|---|
|