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:
- 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.
Additional query words: XL97 8.00 sbfm sbe sbfm97qb exe
Keywords: kbdownload kbprb KB165381