QI Macros Technical Support

Most Common Support Questions for Excel 2016


QI Macros Menu does not Appear in Excel

This is because your Microsoft security settings has removed the Alternate Startup pathway in Excel, once closed:

Download, open, enable and select the "Click Here to Add QI-Macros" button in the following file: Add-QIMacros.xlsm

  1. Once you have done so, completely quit out of Excel and reopen.
  2. Do you now see the QI Macros menu in your Excel ribbon? If not, see manual instructions below.

Manual way to restore QI Macros Add-in:

  1. Open Excel and select File > Options > Advanced
  2. In the Advanced section, scroll down to the "General" portion, and in the "At startup, open all files in" textbox, input the following: C:\Program Files\QIMacros\xlstart\
  3. Press "OK," close Excel and reopen - you should now see the QI Macros menu in your Excel ribbon.

Common Problems & Questions

I upgraded to Excel 2016. Why can't I see the QI Macros on my menu?

If you have a version of the QI Macros from 2015 to 2019, you might consider upgrading to the latest version of QI Macros.

Otherwise, when you install a new version of Excel, the QI Macros aren't automatically moved to the new startup folder. You can reinstall from your backup CD or if you no longer have it, you will have to do this manually.

How to Move the QI Macros

You may be able to move the old files to the new location using this tool: XLUpgrade.bat. Download and double click on it to move your files - then open Excel.

How to Move QI Macros Manually

1. Navigate to C:\Program Files\QIMacros\xlstart
- Excel 2010 files are in c:\Program Files(x86)\Microsoft Office\Office14\xlstart or c:\Program Files (x86)\Microsoft Office\Office14\xlstart
- Excel 2013 files are in c:\Program Files\Microsoft Office 15\root\Office15\xlstart or c:\Program Files(x86)\Microsoft Office\Office15\xlstart
- Excel 2016 files are in c:\Program Files(x86)\Microsoft Office\root\Office16\xlstart or c:\Program Files (x86)\Microsoft Office\Office16\xlstart

Note: If you had to reinstall using an older QI Macros installer, your files may be in c:\xlstart.
Or you can upgrade to the latest version of QI Macros, if your license is eligible.

2. Copy the files and folders shown below:


3. Navigate to one of the following pathways, depending on which version of Excel you have:

C:\Program Files(x86)\Microsoft Office\root\Office16\xlstart (or)
C:\Program FIles(x86)\Microsoft Office\Office16\xlstart (or)
C:\Program Files\Microsoft Office\root\Office16\xlstart (or)
C:\Program Files\Microsoft Office\Office16\xlstart
NOTE: You may have to create an xlstart directory

4. Paste the files and templates into Excel 2016's xlstart folder.

5. Restart Excel.

Warning: If your version of QI Macros is older than December 2012, you will need to upgrade your QI Macros. Older versions are not compatible with Office 2016.

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

Installation Instructions and Troubleshooting

How Do I Install QI Macros on My Computer?

1. Completely close out of Excel.

Don't just close a file; completely exit/quit out of Excel.

2. Download and run the QI Macros Installation File.

  • Right-click on the QIMacros.zip file and select "Extract All":


  • Once the items are extracted, open the PC folder and then double-click on the .exe file to launch the installer:

  • Follow the prompts:



    3. Start Excel—look for the QI Macros tab on Excel's menu:


    No QI Macros Menu? Click the PC Troubleshooting Link Below:

  • No QI Macros menu appears

    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.

    • In Excel, click on File, Options and then on Add-Ins in the left-hand column.
    • Then Click on Manage Excel Add-ins at the bottom of the screen and click on the arrow next to the box and select Disabled Items:

    • Then Click on the GO button next to your selection to see all disabled items:

      disabled excel addin
    • Click on each of the qi macros disabled items and click Enable.
    • Once you've enabled all of the QI Macros disabled items, exit Excel and start Excel 2016. The qimacros.xlam file should open automatically.

    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:


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

    Or, the installer might not have been able to locate the proper Excel pathway. With that, it would have placed the necessary install files directly onto your C drive, in a folder labeled, "XLSTART." If so, copy the contents of the XLSTART folder (qimacros.xlam and QITemplates folder) and paste them into the following pathway:

    • Excel 2016: C:\Program Files (x86)\Microsoft Office\root\Office 16\XLSTART or C:\Program Files\Microsoft Office\Office 16\XLSTART
      c:\program files\qimacros\xlstart - In mid-September 2017, we began using this folder for all installations in all versions of Windows and Excel 2010-2019, Office 365.

    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

    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.

    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.

    Excel "Start Up" window does NOT appear

    If you open Excel 2016, and the "start up" window does not appear, this is an indicator that your version of Office needs to be Repaired:


    To repair, go to your Control Panel and select Programs > Programs and Features > Microsoft Office 2016 > Change > Quick Repair.

    Once the repair has completed, open Excel - you will see the QI Macros in your Excel ribbon.

    Runtime Error '52': Bad file name or number

    If you are receiving a Runtime Error 52, this is because the necessary QI Macros install files are located in two separate places on your device. With that, QI Macros does not know which location to open the files from.

    To troubleshoot this matter, remove the qimacros.xlam file and QITemplates folder from C:\Program Files\QIMacros\xlstart or remove this pathway from the "At startup, open all files in" textbox in the General section, found in Excel - File > Options > Advanced.

    No QI Macros Menu Appears in Office ProPlus/Pro Plus

    If you have run the install and the QI Macros menu does not appear in your Excel ribbon, and you have Office Pro Plus/ProPlus, select Ctrl+Shift+Q to load the Add-In menu in your Excel ribbon.

    There, you will find the QI Macros drop-down menu.

    Where do I find the QI Macros files on my PC?

    QI Macros is loaded in the XLStart folder at c:\program files\qimacros\xlstart (September 2017) or c:\Program Files(x86)\Microsoft Office\root\Office16\xlstart. Your XLStart folder should contain the following files:



    If you installed Office 2016 32-bit on Windows 64-bit, look here:
    c:\program files (x86)\microsoft office\root\office16\xlstart

    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.

    VBA is not Installed?

    A small percentage of Office 2016 users are finding that when they install Microsoft Office, VBA is not included. Unlike Office 2010 or 2007, you are not able to go into the Control Panel and simply select what features you want to include or disable in your Office Suite – VBA is supposed to be automatically included.

    To check, select Alt+F11. If the Visual Basic Editor window does NOT open, VBA is not enabled or installed.

    To double-check, select File > Options > Customize Ribbon > Developer. If "Developer" is not included in your Main Tabs list, add it from the "All Commands" list. And once added, the Visual Basic and Macros buttons should be clickable.

    If they are not clickable, open the Registry Editor, select Ctrl+F and search for VBAOff. If an entry is found, look to see if the Value Data is set to 1. 1 = VBA is disabled, 0 = VBA is enabled. If it is set to 1, change the Value Data to 0, with Excel completely closed. Press OK, open Excel, and select Alt+F11 - does the Visual Basic Editor open? If so, VBA is now enabled!

    However, if VBA is not included, Microsoft says the workaround is to perform a Quick Repair via the Control Panel (Control Panel > Programs > Programs and Features > Microsoft Office 2016 > Change).

    If that does not work, completely uninstall Microsoft Office, using their “Fix It” tool.

    This  will remove any traces of the previously installed version of Microsoft Office. Once completed, run a “clean install” of your 2016 Office.

    Running Windows 10 S?

    Please note that QI Macros is not compatible with Windows 10 S. If you have this Operating System installed, and want to install QI Macros, you must upgrade to Windows 10 Pro: Windows 10 S to Windows 10 Pro

    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, visit the following link for detailed instructions.

    30-day Trial Note: 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 e-mail to support@qimacros.com and ask for a 15-day trial extension.

    Other Issues or Error Messages

    QI Macros is an Excel add-in. Therefore, many of the error messages you may receive are Excel error messages caused by your Excel configuration or security settings. Always make sure you have the latest service pak loaded.

    We have included the most common errors here. If you can't find the error message and fix you are looking for:

    • make sure you have the most recent Excel Service Pack loaded
    • search Microsoft's Support page or
    • contact us via e-mail at or phone at 1-888-468-1537

    Tech Support Archives

    Rare issues and issues with older versions of the QI Macros


    Purchase QI Macros SPC Software for Excel or a QI Macros Upgrade through our secure shopping cart or try a free, 30-day trial!