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


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q185974

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:

    1. Insert the Microsoft Small Business Financial Manager 97 compact disc (CD) into your CD-ROM drive.
    2. On the Start menu, point to Settings, and then click Control Panel.
    3. 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.
    4. In the Financial Manager Setup dialog box, click Remove All.
    5. Click Yes in the Setup Message dialog box.
    6. Click Restart Windows.
  2. Remove Microsoft Excel from your computer. To do this, follow these steps:

    1. Insert the Microsoft Excel 97 CD into your CD-ROM drive.
    2. On the Start menu, point to Settings, and then click Control Panel.
    3. 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.
    4. In the Microsoft Excel 97 Setup dialog box, click Remove All.
    5. Click Yes in the Setup Message dialog box.
    6. Click Restart Windows.
  3. Rename all of the supporting files for Data Access Objects (DAO). To do this, follow these steps:

    1. On the Start button, point to Find, and then click Files Or Folders.
    2. In the Named box, type dao*.*. 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.

    1. Click to select a file in the list of files found.
    2. Click Rename on the File menu. Change the file name extension to .old.

      For example, if the selected file is named Dao350.dll, type Dao350.old and press ENTER.
    3. 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.
Modification Type:MajorLast Reviewed:11/17/2000
Keywords:kbprb KB185974
©2002 Microsoft Corporation. All rights reserved.