Excel 2000 - 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 2000

• No QI Macros Menu Appears
• QI Macros Menu Shows Up Twice
• Run-time Automation Error
• My Computer Crashed and I Can't Find My CD or Install File
• The arrows on histograms move around

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

QI Macros may have installed in a newer version of Excel (e.g., XP or 2003).

The QI Macros always install in the most current version of Excel. Click on Start and look for Excel or Excel 2003. Then open this version of Excel up and see if the QI Macros appear on the menu bar.

If you want the QI Macros to appear in Excel 2000, either re-run the installtation wizard and select that version of Excel when prompted or do a search on qimacros.xla and then copy that file and the QI Templates folder found with it to:

(c:\program files\microsoft office\office\xlstart)

XL 2000 may have failed to autoload the QI Macros Menu.
You may have Macro Security set too high.
Click on Tools-Macros-Security and set to medium or low.

Alternate: If you've recentlly upgraded Excel,

1. You may have to reinstall the QI macros for the new version
2. If you use a desktop shortcut to start Excel, it may still be pointing to the old version of Excel. Go to c:\program files\microsoft office\office10 and create a new shortcut from Excel.exe

QI Macros Menu shows up twice

Windows 2000: For some reason, Windows 2000 "auto opens" the macro twice. It won't affect your performance and either menu will work. I've opened a ticket with Microsoft.

Excel 2000 - Run-Time Error - Automation

Unfortunately, this is an Excel bug, but they no longer supply the "hot fix" to correct the problem. Here is what Microsoft has to say. http://support.microsoft.com/kb/813120

You will have to upgrade Excel to get around this problem.
Microsoft dropped public support for Excel 2000 several years ago.

The arrows on histograms move around

Excel 2000 and 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:

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