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

Copyright © 2011

Technical Support Questions Specific to Excel 2003

• No QI Macros Menu Appears
• The formula you typed contains an error - (Excel 2003 SP3 only)
• Outlook could not track the program used to open this document
• Pop Out Menus missing (XL 2003)

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

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.

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 new QI Macros license on our shopping cart. (You need to purchase a new license not an upgrade)

Outlook could not track the program used to open this document

The customer who had this problem was running Microsoft Exchange Server with Outlook and trying to double click on a readonly Excel file to open it (see below). It worked with read/write Excel files, but not readonly files.

Without the QI Macros installed, they could do this on either readonly or read/write Excel files. With the QI Macros installed, however, they got the error message, probably because Excel opens the qimacros.xla file from xlstart before opening the server file.

Solution: After much research, we changed how the QI Macros start (not opening the options file) and turned off AutoSave (below). The problem was corrected by the two changes.
The QI Macros change will be in the March 2011 release.

We don't know if this is a problem in other versions of Excel.

Pop Out Menu Missing

Excel 2003: Example above shows main menu, but no choices, just a blue square.

Cause: If Excel or Windows crashes it may leave a ~tmp...xla file in the XLStart folder. This file gets loaded instead of the qimacros.xla file. To check this, right click on a sheet name and choose view code. There should only be one QIMacrosSPCforExcel2007 (qimacros.xla) listing in XL97-2003. (XL2007 will have a qimacrosmenu.xlam for the ribbon.)

Solution: Close Excel. Go to c:\program files\microsoft office\office11\xlstart and remove the ~tmp...xla. Reopen Excel and the problem should be gone.

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