QI Macros Technical Support Questions

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

Most Common QI Macros Questions

• No QI Macros Menu
• Run Time Error 1004 qimacros.xla could not be found
• My Computer Crashed and I Can't Find My CD or Install File

Tech Support Pages Specific to Your Version of Excel

Tech Support Archives - rare issues and issues with older versions of the QI Macros

Installation Instructions and Troubleshooting

Possible PC Install issues

• Installation Wizard ran but I don't see QI Macros on my menu
• Won't install in correct Version of Excel
• 64-bit Windows workstations
• WinZip asks for user name and password

To Uninstall a QI Macros License or 30-Day Trial

The QI Macros is an Excel add-in and not a separate application. Therefore it does not uninstall using Add/Remove programs. Instead follow the instructions below:

• Run Uninstall File: Close Excel and click here to download and run the uninstall file
• Uninstall manually: Follow these instructions to delete the QI Macros files on your computer
• QI Macros still shows up under Add /Remove Programs after I uninstall manually

30 Day Trial Note: Even if you uninstall the 30 day trial you will not be able to re-install it. If you need more time to evaluate the QI Macros, send an email to support@qimacros.com and ask for a 30 day trial extension.

Other Issues

• Problems When Opening Excel
  • Excel quits after loading QI Macros and Risk Solver or other Addin
  • Antivirus prevents loading qimacros.xla
  • No QI Macros Menu Appears and there's a Run Time Error
  • Repeated messages to upgrade because QI Macros over one year old.
  • Excel has corrupted files causing all kinds of weird behavior
    
• Problems When Running Charts or Opening Templates
  • Run Time Error 1004 QIMacros.xla could not be found
  • Macro does not run - nothing happens XL 2007
  • Histogram - Cp, Cpk, etc are off the chart to the right
  • p and u chart - can't switch from skyline to wave format
  • XmR Dashboard stops at 24 charts.
  • Can Run The Macros, but Can't Load a Template
  • Excel crashes when running a chart
  • Runtime Error 91
    
  How do I?
  • Determine What Version of Excel I Have?
  • Turn Off the QI Macros When I Open Excel

Tech Support Archives

Free Training and Other Resources

• Free lessons and how to articles
• Free getting started and how to run a chart sample videos
• Other Free QI Macros Training Resources
• QI Macros formulas
• QI Macros software validation
• QI Macros FAQs on pricing, licensing, compatibility, etc.

We have found that many customer questions are actually about Excel or statistics, not the QI Macros. If you have these kinds of questions, check these FAQ pages:

• Excel FAQs
• SPC FAQs
• Problems running a training DVD
• DVD VHS formats

Problems With Microsoft Windows or Excel
If you have any other problems...page faults, can't compile, etc. we have found that it's rarely a QI Macros problem. So, click here to look for answers in Microsoft Support.

If you still can't find the answer, please complete the following trouble reporting form. Thanks.

Trouble Reporting Form

No QI Macros menu appears or

Run Time Error 1004, qimacros.xla could not be found

Excel has disabled one or more of the QI Macros files. The process for enabling a file is different depending on your version of Excel.

• Excel 2010 Instructions
• Excel 2007 Instructions
• Excel 2003 Instructions
• Excel 2002 Instructions - Hold down Ctrl-Shift Keys and press "Q". This will manually load the menus in Excel 97-2003.

If there are no disabled files check to see if the QI Macros are installed

• Window 7 machines: Go to c:\ Program Files(x86) \Microsoft Office\ Office(10,11,12)\ Xlstart
• Windows Vista and XP: Go to c:\ Program Files\ Microsoft Office \Office(10,11,12)\ Xlstart

View the contents of the XLstart folder, it should look like this:

• If your XLStart folder contains some kind of temporary file, delete the temporary file and see if this solves the problem.
• If your folder is missing the .xla file, then close Excel and reinstall the QI Macros.
• If your XLStart folder contains the files, then Excel has disabled them. See above instructions

If Excel Continues to Disable the file

You may have Macro Security set too high.
Click on Tools-Macros-Security and set to medium or low.

You may have Addin security set too high in Excel 2007-2010. Click on the Office Button-Excel Options-Trust Center-Trust Center Settings-Addins, and uncheck both boxes.

My Computer Crashed and I Can't Find My Install File

If you purchased the QI Macros in the last 12 months, we can look up your record and send you a replacement file for only $35. If we find that you purchased over 12 months ago, we will need to change your order to an upgrade.

If you have purchased within the last 12 months

Installation Instructions for a PC

1. Close Excel
2. Double click on the QI Macros setup.exe file to run the installation wizard.
3. Answer the prompts
4. Open Excel, you should see "QI Macros" on your menu bar.

If the installation wizard ran correctly and you don't see QI Macros on your menu bar, Excel may have disabled the file. Its easy to re-enable the file. See instructions below depending on your version of Excel.

• Excel 2010 Instructions
• Excel 2007 Instructions
• Excel 2003 Instructions

Test data for the charts is located at c/qimacros/test data. You can use these spreadsheets or your own data to practice with the charts.

Basically you just select your data, go up to the menu bar and select the chart you want to run. Templates like the FMEA, Gage RR and DOE can be accessed by choosing the Fill-in-the-blanks Templates from the pull down menu.

Where do I find the of QI Macros Files on My PC?

The QI Macros is loaded in the XLStart folder at c:\Program Files\Microsoft Office\Office(10,11,12)\Xlstart. Depending our your version of Excel and the QI Macros your XL Start folder should contain the following files.

Excel 2007 and 2010	Excel 2003 and Earlier

If you are having problems accessing the menu or templates and your XLStart folder contains some kind of temporary file, delete the temporary file and see if this solves the problem.

Installation Instructions for a Mac

QI Macros purchased in Sep 2011 and before

QI Macros purchased during Oct 2011 and after

1. Close Excel and locate the QI Macros installation file



On your CD	Download from Internet in your Downloads folder



2. Click on the QIMacros.mpkg file to begin the installation wizard.




3. Input your password if asked (this is the password you set up and have to input whenever you install any software on your Mac).



4. Then follow the prompts to install the QI Macros.

5. Open Excel and see the QI Macros on your menu.

Where do I find the of QI Macros Files on My Mac?

The QI Macros files are loaded in:

Applications : Microsoft Office (2011 or 2004) : Office : Startup : Excel

QI Macros Don't Install in Correct Version of Excel

If you have two or more versions of Excel on your PC, the installer assumes that you want to put the QI Macros in the most recent version.

If you buy a new machine, for example, that comes with a 60-day trial of the latest Office programs and then install Office 2000, XP, or 2003, Windows still wants you to try the new version!

Find out where the QI Macros were installed by searching on qimacros.xla and copy them to the correct folder.

• Excel 2010 - c:\program files\microsoft office\office14\xlstart
• Excel 2007 - c:\program files\microsoft office\office12\xlstart
• Excel 2003 - c:\program files\microsoft office\office11\xlstart
• Excel 2002 - c:\program files\microsoft office\office10\xlstart
• Excel 2000 - c:\program files\microsoft office\office\xlstart

Installation Problems - 64 bit Machines

The QI Macros setup.exe file will work on 32-bit and 64-bit machines for both Excel 32-bit and 64-bit.

There may still be things we don't quite understand. If you install and don't get a menu or some other odd behavior. Give us a call and we can get online together to check it out.

How to Determine Your Operating System and Version of Excel

We have created an excel file that you can download and run. It will tell you what operating system and version of Excel is loaded on your computer (PC or Mac - except Excel 2008).

1. Download the PC / Mac Check file
2. Save the file to your computer
3. Double click on the file to open it
4. If it asks you if you want to enable the macros in the file - answer "Yes" or "Enable Macros"
5. The file will run and display the results in a window.

XmR Dashboard stops at 24 Charts

Excel has a physical limit of 124 charts per workbook.
Since there are 4 charts on each XmR sheet, each time we copy it and add one to the dashboard you end up with 5 more charts (24*5=120).
Solution: Before you create the dashboard:

1. Delete the other XmR sheet (median or range)
2. Delete the Histogram, probability plot and even the range chart from the remaining XmR sheet.
3. This will allow you to create up to 60 charts on the dashboard.
4. If you need more than 60 charts
• Right click on any sheet name and select "view Code".
• Change the code in XmR-Dashboard.xls, Module1,Create_Dashboard_XmR:
  from "ActiveSheet.ChartObjects(1).Copy" to "ActiveSheet.ChartObjects(1).Cut"
  Rather than make a copy, this will move the chart to the dashboard, minimizing the number of charts in the workbook.
• Create the Dashboard

Excel crashes when running a chart

This can happen when there is an invalid or no default chart type.

Solution: Set the default chart type to column chart (Excel's default):

1. Create a chart by selecting data and inserting a column chart:

2. Right click on the chart and choose Change Chart Type:

3. Set Column Chart as Default Chart Type:

4. Exit Excel and start Excel.

5. Run a chart using the QI Macros.

Runtime Error 91

This can happen when there are merged cells in your data.

Select the cells, right click to change format and remove merge.

Getting repeated upgrade message after a year

The QI Macros can't update your windows registry. When I added the reminder we didn't know that IT departments can lock the registry.

Solutions
1. Have your administrator reinstall from your QI Macros Setup File.
2. Download this file and have your administrator run it to update the registry.

To Uninstall the QI Macros

Uninstall using the uninstall file: Close Excel and click here to run the uninstall file

Uninstall by deleting the QI Macros files manually:

PC Users - remove the qimacros.xla and QIMacros2010menu.xlam files in:

• Excel 2010 - c:\program files\microsoft office\office14\xlstart
• Excel 2007 - c:\program files\microsoft office\office12\xlstart
• Excel 2003 - c:\program files\microsoft office\office11\xlstart
• Excel 2002 - c:\program files\microsoft office\office10\xlstart
• Excel 2000 - c:\program files\microsoft office\office\xlstart

Note: In Windows 7 with 32 bit versions of Excel (all versions except 2010) you will find the files in Program Files x86 vs Program Files

Mac Users: Remove the qimacros.xla file in:

• Excel 2011 - Applications/Microsoft Office 2011/Office/Startup/Excel
• Excel 2004 - Applications/Microsoft Office 2004/Office/Startup/Excel

Uninstalling the 30-Day trial:

If you uninstall the 30-day trial, you will not be able to reinstall it again. If you need more time to evaluate the software, send an email to support@qimacros.com and ask for an extension.

QI Macros still shows up under Add /Remove Programs after I uninstall manually:

The QI Macros has been uninstalled. If you want to remove it from your Add /Remove Programs list, close Excel and run the Uninstall File

Excel quits after loading QI Macros and Risk Solver 9.5 or other addin

Addins sometimes use the same procedure names which confuses Excel.

If you have recently upgraded Risk Solver or other Addin, the July 2009 release of the QI Macros was revised to prevent these most of these kinds of conflicts.

Workaround: Open Excel (to load addins), then open files.
Double clicking on a file to start Excel will still result in Excel quitting unexpectedly.
I have spoken with Excel techsupport and they have no insights or workarounds.

Order an upgrade (item #232) at www.qimacros.com/products.php.

Antivirus software prevents loading qimacros.xla

For some reason, Norton Antivirus prevents loading qimacros.xla.

First, check trusted locations (XL 2007/2010) to make sure the xlstart folder is trusted.

If not, you can run Live Update to get the latest version of the Office Plugin
or you may have to turn off the Office plugin for Norton Antivirus:

Open the antivirus software, click on Options - Miscellaneous and uncheck the Office Plugin. See: http://support.microsoft.com/kb/329820

Excel installation files corrupted causing weird behavior

Lately I've noticed a number of weird behaviors cropping up in Excel (e.g., Excel's chart menu appears on a worksheet instead of a chart sheet). When we repair Excel, everything (including the QI Macros) starts running better. To repair your installation of Excel:

Excel 2010

Start - Control Panel - Microsoft Office 2010 - Change - Repair

Excel 2007

Click on Options-Resources-Diagnose. You may need your installation CD to complete this process.

Excel 2000-2003

Click on Help-Detect and Repair. You may need your installation CD to complete this process.

WinZip asks for User Name and Password

Solution: Use Windows-Compressed (zipped) Folders tool to extract the contents. Right click on the zip file and choose Open With-Compressed (zipped) Folders:

No QI Macros Menu and there's a Run Time Error

It's possible that Visual Basic For Applications (VBA) was not installed or is disabled. To check, right click on any sheet name and look at the menu. If "View Code" is grayed out (see below), VBA is disabled or not installed.

To enable VBA, you may need to 1) get into the registry (per Microsoft) or 2) install VBA.

If VBA is installed, it may be disabled. If one of the following DWORD registry keys exists and has a value that is greater than 0, VBA is disabled. Change it back to zero:
Microsoft Office 2010
HKLM\Software\Microsoft\Office\14.0\Common\VBAOff
HKCU\Software\Microsoft\Office\14.0\Common\VBAOff
HKCU\Software\Policies\Microsoft\Office\14.0\Common\Vbaoff

Microsoft Office 2007
HKLM\Software\Microsoft\Office\12.0\Common\VBAOff
HKCU\Software\Microsoft\Office\12.0\Common\VBAOff
HKCU\Software\Policies\Microsoft\Office\12.0\Common\Vbaoff

Microsoft Office 2003
HKLM\Software\Microsoft\Office\11.0\Common\VBAOff
HKCU\Software\Microsoft\Office\11.0\Common\VBAOff
HKCU\Software\Policies\Microsoft\Office\11.0\Common\Vbaoff

Microsoft Office XP
HKLM\Software\Microsoft\Office\10.0\Common\VBAOff
HKCU\Software\Microsoft\Office\10.0\Common\VBAOff HKCU\Software\Policies\Microsoft\Office\10.0\Common\Vbaoff

To Install Visual Basic for Applications

1. Exit Excel and Open the Control Panel

2. Add/remove programs - Microsoft Office 20??- Add/remove features

3. Choose Advanced Customization of Applications

3. Click on Shared Features

4. Install Visual Basic For Applications

5. Start Excel

Turn Off Macros Temporarily

Macro Does Not Run XL 2007-2010

Click on the Office Button and Excel Options (bottom):

Then click on Trust Center Settings (bottom right):

Excel 2007 defaults to disabling all macros with notification. So to get the macros to run, set macro security to disable all macros except digitally signed macros. The QI Macros have been digitally signed since February, 2010:

p and u chart - can't switch from skyline to wave format

The QITemplates folder may be read only (IT departments do this sometimes, see below). This makes it impossible to update the ControlChartRules.xls file which keeps the formatting rules. To correct this, have IT make the folder read/write, then redo the p/u format change.

Cp, Cpk, etc are off the chart to the right

The most recent version of the QI Macros fixes this in most instances. If you have an older version of the QI Macros you might consider purchasing an upgrade.

If you have a recent version of the QI Macros, you may experience this problem when your spec limits are far apart but your data is clustered together. In order to make room for the spec limits, the macro may have pushed the metrics too far to the right. You can select and move the text boxes as follows:

1. Make sure your drawing toolbar is open (usually appears at the bottom of your spreadsheet). If it is not, select View/Toolbars/Drawing.
2. Click on the arrow to change your cursor.



3. Click and drag over the text boxes to select them.



4. Move the boxes back on the page.
5. Click on the arrow to change your cursor back to normal.

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