QI Macros Technical Support

Most Common Support Questions for Excel 2002 (XP)

Common Problems & Questions


NOTE: Microsoft has stopped supporting this version of Excel, therefore QI Macros is no longer compatible with Excel 2002.

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:

  1. Click on HELP-ABOUT EXCEL
  2. Click on Disabled Items
  3. 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.

Run Time Error 13 - Type Mismatch

This problem was caused by Service Pack 2. Upgrade to Service Pack 3.

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 the 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)

We have found that many customer questions are actually about Excel or statistics, not the QI Macros.

Check these FAQ pages:
Purchase QI Macros SPC Software for Excel or a QI Macros Upgrade through our secure shopping cart or try a free, 30-day trial!

If you do not know your Win/Mac/Excel Version, click here to download an Excel file that will check the information for you. Look in your Downloads folder, open the Excel file, copy the information in the window (shown below) and place it in the problem description.