SBFM97: 'Run Time Error 13' Caused by Incorrect DAO Files

ID: Q185974

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Small Business Financial Manager 97 for Microsoft Excel 97

SYMPTOMS

When you attempt to perform a "Compare What-If Scenarios" analysis in the What-If Overview, the following error message appears:

   Run-time error '13':

   Type mismatch

When you click End, an hourglass appears. This hourglass does not disappear until you quit the Microsoft Excel program.

Note that you can still use the Microsoft Excel menus even though the pointer is shaped like an hourglass.

CAUSE

This problem occurs when you do the following:

You perform a Typical installation of Microsoft Excel 97 for Windows when you install it.
```
    -and-
```
You install Microsoft Small Business Financial Manager 97 for Microsoft Excel 97.

WORKAROUND

To work around this problem, follow these steps before you run the Compare What-If Scenarios analysis.

1. First, remove Small Business Financial Manager from your computer. To do

   this, follow these steps:

    a. Insert the Microsoft Small Business Financial Manager 97 compact
       disc (CD) into your CD-ROM drive.

    b. On the Start menu, point to Settings, and then click Control Panel.

    c. Double-click Add/Remove Programs. In the list of installed programs,
       click Microsoft Small Business Financial Manager 97, and then click
       Add/Remove.

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

    d. In the Financial Manager Setup dialog box, click Remove All.

    e. Click Yes in the Setup Message dialog box.

    f. Click Restart Windows.

2. Remove Microsoft Excel from your computer. To do this, follow these

   steps:

    a. Insert the Microsoft Excel 97 CD into your CD-ROM drive.

    b. On the Start menu, point to Settings, and then click Control Panel.

    c. Double-click Add/Remove Programs. In the list of installed programs,
       click Microsoft Excel 97, and then click Add/Remove.

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

    d. In the Microsoft Excel 97 Setup dialog box, click Remove All.

    e. Click Yes in the Setup Message dialog box.

    f. Click Restart Windows.

3. Rename all of the supporting files for Data Access Objects (DAO). To do

   this, follow these steps:

    a. On the Start button, point to Find, and then click Files Or Folders.

    b. In the Named box, type "dao*.*" (without the quotation marks). Click
       (C:) in the Look In list. Click to select Include subfolders. Click
       Find Now.

4. For each listed file, follow these steps:

   NOTE: Do not rename the Dao folder.

    a. Click to select a file in the list of files found.

    b. Click Rename on the File menu. Change the file name extension to
       ".old" (without the quotation marks).

       For example, if the selected file is named Dao350.dll, type
       "Dao350.old" (without the quotation marks) and press ENTER.

    c. When you have renamed all of the DAO files, close the Find window.

5. Reinstall Microsoft Excel 97.

6. Reinstall Microsoft Small Business Financial Manager 97.

MORE INFORMATION

The error message is caused by the presence of incorrect or mismatched DAO files. This commonly occurs when you perform a Typical installation of a stand-alone version of Microsoft Excel 97. A Typical installation does not install any Data Access components. When you then install Microsoft Small Business Financial Manager 97, the Setup program installs the Data Access components if they are not present on the computer. However, the installed files do not use correct file version.

Additional query words: XL97 SBFM97

Keywords          : kbdta xlsbfm xldao 
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: March 19, 1999