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.
Excel has disabled the one of the QI Macros files. To re-enable the file:
- Click on HELP-ABOUT EXCEL
- Click on Disabled Items
- 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.
This problem was caused by Service Pack 2. Upgrade to Service Pack 3.
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:
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.