QI Macros Technical Support Questions

home · products · services · search · view cart · contact  
 
        
 
Shopping cart  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


Tech Support Pages Specific to Your Version of Excel

Excel 2010 Tech Support Macintosh Tech Support
Excel 2007 Tech Support Excel 2000 Tech Support
Excel 2003 Tech Support Excel 97 Tech Support
Excel 2002 Tech Support  

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


Installation Instructions and Troubleshooting

PC Users
Mac Users
Installation Instructions for a PC Installation Instructions for a Macintosh
Where the QI Macros Files are installed on my PC? Where the QI Macros Files are installed on my Mac?

Possible PC Install issues


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:

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

Tech Support Archives

Rare issues and issues with older versions of the QI Macros

Free Training and Other Resources

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:

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

Can you run a chart with data in c:\qimacros\testdata?: Yes No
Your name: Required
Company:
Phone: Required
Email: Required
Required
Required
Required

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


Problem Description: Required

If you've encountered a problem with your data...

Please email any data or forms you are using to: support@qimacros.com Note: Incomplete information will delay resolution of your problem


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.

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

QI Macros Replacement File - We will send you a download link after we look up your invoice - No Shipping or Customs Duties (#R232) $35


If it has been over 12 months, you will need to purchase the upgrade (see upgrade history) with a backup CD and User Guide.
QI Macros Upgrade - One License Per Computer - Download with backup CD and user guide (#232) $99 + S&H
QI Macros Upgrade - One License Per Computer - Download Only - No Shipping or Customs Duties (#W232) $99

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.

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

  2. On your CD

    Download from Internet in your Downloads folder

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



  4. Input your password if asked (this is the password you set up and have to input whenever you install any software on your Mac).
  5. Then follow the prompts to install the QI Macros.

  6. 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.

QI Macros Upgrade - One License Per Computer - Download with backup CD and user guide (#232) $99 + S&H
QI Macros Upgrade - One License Per Computer - Download Only - No Shipping or Customs Duties (#W232) $99

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

If you have installed a trial of WinZip on your computer and it expired, WinZip has become the default program to open zipped files. You might consider removing WinZip.

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

Press the ESCAPE Key
When you start Excel, any files that are located in the XLStart folder or the alternate startup folder begin to open. You can press ESCAPE after the files start to open to prevent any additional files from opening.

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.

QI Macros Upgrade - One License Per Computer - Download with backup CD and user guide (#232) $99 + S&H
QI Macros Upgrade - One License Per Computer - Download Only - No Shipping or Customs Duties (#W232) $99

 

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

 

QI Macros 30-day Trial
Name:   
Email*
How did you hear about us? *

We hate spam as much as you do, so we never share your email with anyone for any reason.

 

 
home | products | services | search | sitemap | Shopping cart view cart | contact
QI Macros | Excel SPC Software | SPC Software Free Trial
Control Charts | c Chart | np Chart | p Chart | u Chart
ImR Chart | XmR Chart | XMedianR Chart | XbarR Chart | XbarS Chart | EWMA Chart
Anom Chart | Cusum Chart | Levey Jennings Chart | Moving Average Chart
Histograms | Pareto Chart | Scatter Plot | Run Chart
Box Whisker Plot | Dot Plot | Multivari Chart

Lean Six Sigma Training | Lean Six Sigma Training Denver
Lean Six Sigma Consulting | Lean Six Sigma Consulting Denver
Lean Six Sigma Training Systems | Do-It-Yourself Lean Six Sigma Training