Excel 2002 - 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 work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

Technical Support Questions Specific to Excel 2002 (XP)

• No QI Macros Menu Appears
• Macro Not Found Message
• Run Time Error 13 - Type Mismatch
• The arrows on histograms move around
• I can't change the sheet name of the chart

We have found that many customer questions are actually about Excel or statistics, not the QI Macros. Check these FAQ pages:

• QI Macros FAQs
• Excel FAQs
• SPC FAQs

No QI Macros Menu Appears or Macro Not Found Message

Excel has disabled the one of the QI Macros files. To re-enable the file:

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.

Excel 2002 - Run Time Error 13 - Type Mismatch

This problem was caused by Service Pack 2. Upgrade to Service Pack 3.
http://support.microsoft.com/kb/821292

The arrows on histograms move around

Excel 2000 and 2002 (Excel XP)
In both 2000 and XP, once you create a histogram with USL and LSL and control limits, if you save the file and reopen it, Excel moves the arrows and text fields to the left.

Excel seems to remember where to put the arrows and text, but doesn't display them properly. If you open the file in 2003 or 2007, the histogram displays correctly. If you click on File-Print Preview in Excel 2000 or XP, you'll see that they should print properly:

You can use the Drawing toolbar's selection arrow to select and reposition the arrows. Use the selection tool to click on an arrow and move everthing back to it's original position:

Or, once you've created a chart, you can "protect" the sheet to lock the arrows in place:

I can't change the sheet name of a chart

In Excel XP (System release 0), if you type a name that's too long for the sheet name, Excel reverts to the original name.

1. Use a shorter name

2. Upgrade to System Release 3 (SR3)

Free Training Resources

QI Macros Lessons and How to Articles

QI Macros Example Videos

QI Macros 1 hr Webinar Recording

QI Macros Formulas

QI Macros User Guide

Engineering Statistics On Line Handbook