QI Macros Technical Support Questions

Get Technical Support for Your Version of Excel

Most Common QI Macros QuestionsTech Support

No QI Macros menu appears
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 QI Macros is installed
  • Window 10 machines: Go to c:\ Program Files(x86)\ Microsoft Office\ root\ Office 16\ Xlstart -or- c:\ Program Files\ Microsoft Office 15\ root\ Office 15\ xlstart
  • Window 7 and 8 machines: Go to c:\ Program Files(x86)\ Microsoft Office\ Office (10,11,12,14,16)\ Xlstart -or- c:\ Program Files\ Microsoft Office 15\ root\ Office 15\ xlstart
  • Windows Vista and XP: Go to c:\ Program Files\ Microsoft Office\ Office (10,11,12,14,16)\ Xlstart

Note: If the necessary install file are not located in any of the pathways listed above, see if they are perhaps found in the following pathway: c:\ Users\ AppData\ Local\ VirtualStore\ Program Files (x86)\ Microsoft Office\ Office (11,12,14,15,16)\ XLSTART

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

qi-macros-install-file-location

 

  • 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 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-2013-2016. Click on the Office Button-Excel Options-Trust Center-Trust Center Settings-Addins, and uncheck both boxes.

I got a new computer or my computer crashed. How do I restore QI Macros?

Reinstall from your CD or downloaded installation file.
Note: if your QI Macros is over a year old it may not be compatible with the latest version of Excel.
If you can't find your CD or Install file and your QI Macros version is less than 5 years old you may be able to get it here:

I Can't Find My CD or Install File! Can you look it up?

If you purchased QI Macros in the last five years, we can look up your record and send you a replacement file for only $35.
(Click here see if you can download it online for free.)
Note: if your QI Macros is over 2 years old it may not be compatible with the latest version of Excel.

Upgrade a previously purchased QI Macros license to take advantage of new time saving features and functionality.

QI Macros Upgrade - One License per Computer - $99


If you have purchased within the last five years, we can look up your order for a fee:

QI Macros Replacement File - $35

We will send you a download link after we look up your invoice - No Shipping or Customs Duties (#R232)

If it has been over five years, you will need to purchase new license.

QI Macros - One License per Computer - $249 - Adjust quantities in the shopping cart


30-Day Trial Download File Not Recognized

If your computer does not recognize the 30-day trial download file, this means the file itself has been converted from a .exe to a .dat. Simply add the .exe extension to the file by renaming it. Once the file is updated, double-click the download and follow the prompts to install QI Macros.

When the Installation Wizard has completed, open Excel - you will find the QI Macros menu in your Excel ribbon.

Quick Workaround for Excel Problems: Start Excel in Safe Mode by holding down the CTRL key and starting Excel. This will prevent Excel from opening any add-ins including QI Macros.

Installation Instructions and Troubleshooting

PC Installation Instructions

  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 Lean Six Sigma Templates from the pull down menu.

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

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

Excel 2007 and 2010
Excel 2003 and Earlier
Excel 2007 & 2010
Excel 2003 & earlier
Excel 2013
Excel 2013

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.

Macintosh Installation Instructions

QI Macros purchased in September 2011 and before

QI Macros purchased during October 2011 and after:

  1. Close Excel and locate the QI Macros installation file:

    On your CD

    Download from Internet in your Downloads folder
    CD Download
  2. Click on the QIMacros.mpkg file to begin the installation wizard.
  3. Macintosh Step 1

  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):

    Macintosh Step 2

  5. Then follow the prompts to install QI Macros.
  6. Open Excel and see QI Macros on your menu.
Where do I find the of QI Macros Files on My Mac?

For Excel 2016, the QI Macros files are loaded in:

Macintosh HD : Users : User : Library : Group Containers : UBF8T346G9.Office : User Content : Startup : Excel

For Excel 2011, the QI Macros files are loaded in:

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

Macintosh Excel Files Step 1Macintosh Excel Files Step 2

 

Installation Wizard ran but I don't see QI Macros on my menu

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 QI Macros is installed
  • Window 10 machines: Go to c:\ Program Files\ Microsoft Office\ root\ Office 16\ Xlstart -or- c:\ Program Files\ Microsoft Office 15\ root\ Office 15\ xlstart
  • Window 7 and 8 machines: Go to c:\ Program Files(x86) \Microsoft Office\ Office(10,11,12, 14)\ Xlstart -or- c:\ Program Files\ Microsoft Office 15\ root\ Office 15\ xlstart
  • Windows Vista and XP: Go to c:\ Program Files\ Microsoft Office \Office(10,11,12, 14)\ Xlstart

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

install-file-location

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

Won'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 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 2016 - c:\ program files(x86)\ microsoft office\ root\ office16\ xlstart
  • Excel 2013 - c:\ program files\ microsoft office 15\ root\ office15\ xlstart
  • Excel 2010 - c:\ program files(x86)\ microsoft office\ office14\ xlstart
  • Excel 2007 - c:\ program files(x86)\ 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

64-bit Windows workstations

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.

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:

Extract Files

 

qimacros-30-day-trial.exe file is not a Win32 valid application

The file you're attempting to run is corrupt or missing.

Solution:
Delete the file and try downloading and running it again.
It's possible that the file became corrupted during the download.

To Uninstall a QI Macros License or 30-Day Trial

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

Uninstall QI Macros Manually

PC Users

Remove the qimacros.xla(m) files in:

  • Excel 2016 - c:\program files(x86)\microsoft office\root\office16\xlstart
  • Excel 2013 - c:\program files\microsoft office 15\root\office15\xlstart
  • 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, 8, and 10 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.xlam file in:

  • Excel 2016 - Macintosh HD\Users\User\Library\GroupContainers\UBF8T346G9.Office\UserContent\Startup\Excel
  • Excel 2011 - Applications\Microsoft Office 2011\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 e-mail to support@qimacros.com and ask for an extension.

QI Macros still shows up under "Add /Remove Programs"

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

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 QI Macros, send an e-mail to support@qimacros.com and ask for a 30-day trial extension.

Other Common Issues

Problems When Opening Excel

Excel stops working when you double click on an XL2003 (.xls) File

If you are using File Preview in Windows Explorer, you'll notice that it shows that the file cannot be previewed or you will get an error, ""This file can't be previewed because of an error in the Microsoft Office Excel previewer":

Excel this file cannot be previewed

 

This means that Excel 2007-2010-2013-2016 don't know what to do with it. When you double click on the file, Excel will stop working, but if you wait, it will normally open up.

Excel has stopped working

Workarounds: You can turn off Windows Explorers preview screen
Or, you can save the file as a .xlsx (XL2007-2016) format.

Or, Excel just needs to open one of these files from the File Menu. So:
1. Start Excel.
2. Open one of the files in Documents/QI Macros Test Data (e.g., AIAG SPC.xls).
3. Resave the file.

Once you've opened and saved an xls file, Windows Explorer seems to remember how to preview it, and you will be able to double click on any file to open it.

Excel File Preview

If this doesn't work, Microsoft's workaround is to have Excel save thumbnails: http://support.microsoft.com/kb/2257542

1. Open Excel, click on the File tab, choose Info
2. In the right hand pane click on Properties dropdown arrow
3. click on Advanced Properties and choose Summary Tab

Excel 2010 advanced Properties


4. Place a check mark in the "Save Thumbnails for All Excel Documents":


Excel 2010 save all thumbmails

 

Excel quits after loading QI Macros and Risk Solver or other Add-in

Addins sometimes use the same procedure names which confuses Excel.

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

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

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

Antivirus prevents loading qimacros.xla(m)

For some reason, Norton Antivirus prevents loading qimacros.xla(m).

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

Trusted Locations

 

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

AntiVirus Plugin

No QI Macros Menu Appears and there's a Run Time Error (or) Error: "The version of this file is not compatible with the version of Windows you're running."

the version of this file is not compatible with the version of Windows

Most likely, the problem is 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:
  4. Click on Shared Features:
  5. Install Visual Basic For Applications:
  6. Start Excel.

Repeated messages to upgrade because QI Macros is more than one year old

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.

Upgrade a previously purchased QI Macros license to take advantage of new time saving features and functionality.

QI Macros Upgrade - One License per Computer - $99


Excel has corrupted files causing all kinds of 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 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.

Problems When Running Charts or Opening Templates

Macro does not run - nothing happens XL 2007

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. QI Macros has been digitally signed since February of 2010:

 

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

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

Upgrade a previously purchased QI Macros license to take advantage of new time saving features and functionality.

QI Macros Upgrade - One License per Computer - $99


If you have a recent version of 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:

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.

 

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 (Runtime Error 91)

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

Problems Viewing the QI Macros Training CD

Training CD does not run when using Internet Explorer 9

If you are running Internet Explorer 9 and you are unable to view the QI Macros training CD videos on your browser:

  • Click Tools on your Internet Explorer menu
  • Select Internet Options from the drop-down list
  • Click on the Security Tab
  • Uncheck the “Enabled Protected Mode” checkbox
  • Click OK to close the Internet Options window

 

You should now be able to watch the videos on the training CD. This is a known problem that occurs on some installations of IE9.

How Do I?

Determine What Version of Excel I Have?

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:

How Do I Turn Off QI Macros When I Open Excel

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.

Tech Support Archives

Find information about rare issues & issues with older versions of 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.

Trouble Reporting Form

If you can't find the answer to your problem on this page, please search our site:

If you cannot find an answer after searching our site, please complete the following trouble reporting form. We will respond within 24 hours, M-F. Thank you.


Can you run a chart with data in c:\program files\qimacros\testdata?:










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)


 

Purchase QI Macros SPC Software for Excel or a QI Macros Upgrade through our secure shopping cart or try a free, QI Macros 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.