QI Macros Technical Support Questions

Excel 2016

 

NOTE: Microsoft has stopped supporting this version of Excel as of
October 13, 2020.

Therefore, QI Macros can no longer guarantee compatibility with Excel 2016.

While QI Macros may continue to function,
Microsoft will not provide updated security patches or upgrades.
Using macros in this setting will be at your own risk.

Common Questions

16.16.27 (20101200) | Released: October 13, 2020 (Release History)

To check which version you currently have installed, go into Excel and select the "Excel" drop-down menu > About Excel. If you are not up to date with the most recent version of Excel, check for updates within Excel by selecting the "Help" drop-down menu and choosing "Check for Updates."

The QI Macros install files are located in:

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

And the contents of the “Excel” folder should look like this:

qi-macros-install-files-mac-excel

NOTE: If your folder is missing the .xlam file or QITemplates folder, close Excel and reinstall QI Macros.

If you installed a trial or a purchased version and it immediately says the version is "Expired", this is because Microsoft Office has pending updates to either your Excel, the AutoUpdater, or both.

If this is occurring, follow the instructions below:

  1. Click the “Help” drop-down menu from your Excel ribbon and select “Check for Updates.”
  2. If there are pending updates to your AutoUpdater and/or Excel, select “Update.”
  3. Once the updates are completed, perform “Check for Updates” once more, to make sure there are no more pending updates.
  4. Completely quit out of Excel, reopen Excel and open a blank workbook – do you still receive a “trial expired” message?

If you do, e-mail support@qimacros.com or call: 1.888.468.1537.

If you receive a message saying the install cannot be opened:

mac-install-message-1

-or-

mac-install-message-2

Select the Apple icon in the top left corner of your Mac and choose System Preferences > Security & Privacy > General, and choose “Open Anyway” from the “Allow apps downloaded from” section:

mac-install-message-5

Next, select "OK," follow the prompts, and select "Enable Macros" when prompted.

Please note: If you have recently installed or are using macOS Sierra or newer, Apple has disabled the "Anywhere" option. With that, if you are not able to install QI Macros, go to your Applications folder > Utilities > Terminal > and input sudo spctl --master-disable. Press enter and then input your password – this provides the “Anywhere” option under System Preferences > Security & Privacy > “Allow apps downloaded from:” portion of your Mac device.

Once the "Anywhere" option has been enabled, re-run the QI Macros install with Excel completely closed. When finished, open Excel – you should now see the QI Macros menu in your Excel sub-ribbon.

If the QI Macros menu does not appear, contact support@qimacros.com or call: 1.888.468.1537 – we will send you the manual install files and instructions.

Other Questions | Error Messages

Visual Basic for Applications (VBA) was not enabled during the install of Microsoft Excel, or it became corrupted during install or during usage.

NOTE: VBA must be installed, in order to use QI Macros.

To troubleshoot, reinstall Excel and make sure VBA is enabled.

If you have reinstalled Excel and are still receiving this error message, e-mail support@qimacros.com or call 888.468.1537.

This is because Microsoft has released an update to Excel, that causes Excel to crash, when running QI Macros.

If this is occurring, follow the instructions below:

  1. Click the “Help” drop-down menu from your Excel ribbon and select “Check for Updates.”
  2. If there are pending updates to your AutoUpdater and/or Excel, select “Update.”
  3. Once the updates are completed, perform “Check for Updates” once more, to make sure there are no more pending updates.
  4. Completely quit out of Excel, reopen Excel and open a blank workbook – does Excel still crash when trying to create a control chart?

NOTE: To open Excel in Safe Mode, hold down on the "Shift" key while clicking on your Excel icon.

If you have pending updates, and Excel is still crashing when creating a control chart, e-mail support@qimacros.com or call: 1.888.468.1537.

This error occurs during installation when Operating System permissions are not set up correctly, or if the Carbon Registration Database is corrupted. This is due to either a OS install error or a Microsoft install error.

To troubleshoot this issue, you will need to reinstall Microsoft Excel, as the VBA (Visual Basic for Application) was not correctly included during initial Excel installation.

If after Excel reinstall, the error message continues to show, this means the VBA has still not been included w/ the Excel install, as the Excel installer has been corrupted.

You will then need to reinstall your OS to have Microsoft install correctly.

If you have reinstalled your OS and Excel, and you are still receiving this message, contact support@qimacros.com, or call: 888.468.1537.

This error occurs when your OS is damaged, and therefore cannot access the data available inside the installer.

To troubleshoot this issue, send an e-mail to: support@qimacros.com, and we will send you the manual install files and instructions.

This error occurs because Excel cannot find the QITemplates folder, which is part of the QI Macros install.

Normally, the QI Macros files are loaded in:

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

In International versions, Excel changed “Startup” to Oppstart (Norwegian), Demarre (French), etc., but does not populate the StartupPath variable needed to find it. It does, however, populate “AltStartupPath.”

To make the QI Macros work correctly in International versions of Excel:

  1. Make a new folder labeled QIMacros, and in that folder, make a folder called XLSTART. Once you have done so, place the QIMacros folder in the Documents folder.
  2. Next, open the following pathway: Macintosh HD : Users : User : Library : Group Containers : UBF8T346G9 : Office : User Content : Startup : Excel
  3. Once you have done so, move the qimacros.xlam file and QITemplates folder from the Excel folder to the XLSTART folder found in Documents : QIMacros.
  4. Next, open Excel and open a blank workbook.
  5. Click on the Excel drop-down menu in the top left and select Preferences > General.
  6. In the “At startup, open all files in:” textbox, press “Select” and point Excel to Documents : QIMacros : XLSTART
  7. Once this has been completed, completely quit out of Excel and reopen – QI Macros should now appear in Excel’s sub-ribbon menu.

However, you might receive the following message:

Error 68 - Device Unavailable

This error occurs, because the Control Chart Rules file is located in the Excel folder - NOT in the QITemplates folder:

qi-macros-install-files-mac

Move the Control Chart Rules file into the QITemplates folder, quit Excel and reopen. QI Macros and all of its components will now be fully available!

If you have completed all of these steps, and you are still receiving the error message, e-mail support@qimacros.com or call: 1.888.468.1537.

During installation, QI Macros will identify the International version of Excel you are using and load the appropriate language.

NOTE: This language will be used for the pull down menu and any prompts or error messages.

For more information on how to change your default language, click here.

Like the help files and user guides, these translations were done mechanically. If you find any errors or unclear translations, please e-mail us suggestions.

Still not seeing your Tech Support question? Visit our Archives link below:


Call or chat M-F 8 a.m. to 5 p.m. (MT) 888.468.1537


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, Monday through Friday, 8 a.m. to 5 p.m. MT. 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 e-mail any data or forms you are using to: support@qimacros.com

Note: Incomplete information will delay resolution of your problem.