Excel 2003 - QI Macros Technical Support

Shopping cart

0 Product(s) in cart

Total $0.00

> Checkout

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2008

• QI Macros FAQs
• Excel FAQs
• SPC FAQs

Here are the technical support issues that apply to Excel 2003.

• No QI Macros Menu Appears (XL2002/2003)
• The formula you typed contains an error.
  (Excel 2003 SP3 only)

Excel 2002/2003 - No QI Macros Menu Appears

A. Click on HELP-ABOUT EXCEL
B. Click on Disabled Items
C. Enable qimacros.xla (2007) or qimacros.xlm (2006) or zqimenu.xlm (1997-2005) or any other macro.

You may have Macro Security set too high.
Click on Tools-Macros-Security and set to medium or low.

The formula you typed contains an error.

If you received this error, you have a copy of the QI Macros purchased before Dec 2006 and recently loaded Excel 2003 Service Pak 3. Unfortunately, this service pack is not compatible with these older versions of the QI Macros. Here are your options:

1. Uninstall the new release of Excel.
• Start-Control Panel-Add or Remove Programs (e.g., Excel 2003 SP3) or
• Start-All Programs-Accessories-System Tools-System Restore to an earlier date before the installation.
2. Purchase a QI Macros Upgrade

Run Time Error '1004': The Macro 'XXXXX' cannot be found.

Where XXXXX can be ANOVA1, TTESTM, etc.

Excel XP-2007
Customers have noticed and we were able to recreate a situation where Excel seems to lose track of the Analysis Toolpak.

If you get this error confirm the problem by clicking on the Tools menu and look for the Data Analysis (i.e., analysis toolpak) at the very bottom of the menu. You should not see it (left missing, right correct):

If you click on Tools-Addins, however, you will see that the Analysis Toolpak addin is checked. This is an Excel bug. The Toolpak is checked, but Excel doesn't seem to know it.

To correct this problem:

1. Uncheck the Analysis Toolpak in Tools-Addins
2. Exit Excel
3. Open Excel
4. Click on Tools-Addins and Check the Analysis Toolpak.
5. Confirm that the Data Analysis option is now available on the Tools Menu.

The Anova tools should now work properly.