QI Macros Technical Support Questions

Get Technical Support for Your Version of Excel

Most Common QI Macros QuestionsTech Support

No QI Macros Menu Appears

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:
  •  Install files would be located in C:\Program Files\QIMacros\xlstart - there should be a QITemplates folder, along with a qimacros.xlam file.
If the necessary files are located in the proper location:
  • Check to see if Excel removed the "At startup, open all files in" pathway when Excel was closed. To do so, open Excel and select File > Options > Advanced.
  • In the Advanced portion of Excel, scroll down to "General" and look to see if C:\Program Files\QIMacros\xlstart\ is inputted in the "At startup, open all files in" section:

alt-startup-pathway

  • If this window is blank, input the startup pathway listed above, press OK, close Excel and reopen Excel - you should now see the QI Macros menu in your Excel ribbon.
However, if your QI Macros license was purchased prior to September of 2017, the QI Macros install files would be located here:
  • 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 .xlam 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.

Go into Excel and select File > Options > Trust Center > Trust Center Settings > Macro Settings and choose "Enable all macros".

In Excel 2007, click on the Office Button > Excel Options > Trust Center > Trust Center Settings > Add-ins, and uncheck both boxes.

MAC: QI Macros Menu does not Appear or has Disappeared after Excel and/or OS Updates

This is because Microsoft has updated Excel and removed QI Macros as an add-in. This does not mean the QI Macros install files have been removed, it just means that you need to manually add QI Macros as an Excel add-in. To do so, follow the instructions below:

1.) Open Excel, click Tools from the Excel ribbon and select “Excel Add-Ins.” Do you see QI Macros listed as an add-in?

2.) If not, click “Browse” and search your Mac for the file, qimacros.xlam. Were you able to find it?

3.) If so, select the qimacros.xlam file and press “Open” – QI Macros should now appear as an add-in in your Excel Add-Ins list. If it does, press “OK”.

4.) QI Macros menu will load into Excel and should now appear in your Excel sub-ribbon.

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

What Do I Do With My Data?

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:

qi-macros-menu

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:\Program Files\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.

Macintosh Installation Instructions

  1. Completely quit out of Excel and locate the QI Macros installation file.
  2. Double-click the QIMacros.dmg file to begin the installation wizard. Then, right-click on the Install CD icon (ctrl-click):
  3. qi-macros-mac-installer

  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 QI Macros.
  6. qi-macros-mac-installation-wizard

    qi-macros-mac-installation-wizard-complete

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

qi-macros-install-files-mac-excel

QI Macros Menu does not Appear or has Disappeared after Excel and/or OS Updates

This is because Microsoft has updated Excel and removed QI Macros as an add-in. This does not mean the QI Macros install files have been removed, it just means that you need to manually add QI Macros as an Excel add-in. To do so, follow the instructions below:

1.) Open Excel, click Tools from the Excel ribbon and select “Excel Add-Ins.” Do you see QI Macros listed as an add-in?

2.) If not, click “Browse” and search your Mac for the file, qimacros.xlam. Were you able to find it?

3.) If so, select the qimacros.xlam file and press “Open” – QI Macros should now appear as an add-in in your Excel Add-Ins list. If it does, press “OK”.

4.) QI Macros menu will load into Excel and should now appear in your Excel sub-ribbon.

64-bit Windows workstations

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.

Symantec 14 blocks the download of the QI Macros Install file

If you are trying to download the QI Macros Installation file and Symantec 14 is blocking the download, visit the following links for more information on how to circumvent this matter:

Restore a Quarantined File
Exclude a File
Create Exceptions
Report a Suspected False Positive

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.xlam file in C:\Program Files\QIMacros\xlstart\

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 a .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 2010-2013-2016 does not 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 (XL2010-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

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.

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.