HomeTroubleshooting@RISK for Excel: Other Issues"The macro 'AdvTools5.xla!TBSenseMain' cannot be found."

8.38. "The macro 'AdvTools5.xla!TBSenseMain' cannot be found."

Applies to:
@RISK for Excel 5.0 and 5.5 only

Problem:
When I try to launch advanced sensitivity analysis, I get the error message

The macro 'AdvTools5.xla!TBSenseMain' cannot be found.

or a similar message. (Some users get "System error &H80004005 (-2147467259). Unspecified error" before that message.)

Solution:
Somehow your RefEdit control has become corrupt. This control is part of Microsoft Office, not part of @RISK. (Excel's Conditional Sum Wizard uses it, among others.)

If you are eligible to upgrade to the current version of @RISK, this is the simplest solution. Although this is not a bug in @RISK, it happens that @RISK 5.7 and later no longer use the RefEdit control, so by upgrading you avoid the problem.

If you are not eligible to upgrade, the workaround is to take a copy of RefEdit.dll from the same version of Excel on a known good computer, one where Advanced Sensitivity Analysis launches successfully:

  1. On your computer, close Excel if it is open.
  2. Open My Computer and navigate to C:\Program Files (x86)\Microsoft Office or C:\Program Files\Microsoft Office.
  3. Open the OFFICEnn folder under the Microsoft Office folder (OFFICE14 folder for Office 2010, OFFICE12 for Office 2007, OFFICE11 for Office 2003, and so on).
  4. Rename the existing RefEdit.dll to RefEdit_dll.bak, just in case you need to recover it.
  5. Put the copy of RefEdit.dll from the known good computer into the folder.
  6. Do a search on the C: drive for RefEdit.exd and delete all copies or rename them to RedEfit_exd.bak.
  7. Run a repair of Office by following the procedure in this article.

last edited: 2011-03-22

This page was: Helpful | Not Helpful