KB: Errors when accessing Microsoft Excel 97 dialogs

---

KB#: 051
Last updated: March 01 2006

---

The information in this article applies to:

• BigShot 2.xx

When BigShot is running, errors may occur when accessing certain Microsoft Excel 97 dialogs. These errors are caused by known problems in Microsoft Active Accessibility (MSAA), which is utilized by BigShot to monitor and track on-screen events.

These problems can be resolved by upgrading to Microsoft Excel 2000, or by disabling BigShot's support for MSAA. Note: BigShot will not track on-screen events if support for MSAA is disabled.

Known Excel 97 dialog errors (when running BigShot)

• Excel Chart Wizard (Insert > Chart)
  When launching the Excel 97 Chart Wizard, an "illegal operation" error will occur.
• Format Cells dialog (Format > Cells > Number)
  When clicking in the Numbers tab of the Format Cells dialog, a repeated "Your entry cannot be used" error will occur.
• Go To dialog (Edit > Goto)
  When clicking in the Go To dialog, a repeated "Reference is not valid" error will occur.
• Goals Seek dialog (Tools > Goals Seek)
  When clicking in the Goals Seek dialog, a repeated "Cell must contain a formula" error will occur. Note: A system reboot is usually required to escape this error.
• Table dialog (Data > Table)
  When attempting to enter a row and column in the Table dialog, a repeated "Reference is not valid" error will occur.