QI Macros Technical Support Questions

NOTE: You may encounter a message stating "Developer cannot be verified" during installation. This is addressed in the steps below.

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:
• Open the QIMacros folder, then the Mac folder, and double-click the “QIMacrosMac.zip” file:
  
  
• Next, hold down the CTRL button on your keyboard and click on the “QIMacrosMac” file:
  
  
• Select "Open" from the list of options that appear:
  
  

---

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

-or-



• Select "Cancel", and then go to the Apple icon in the top left corner of your Mac device and in macOS Catalina thru Ventura, select “System Preferences” > “Security & Privacy” > “General” and choose, “Open Anyway”:
  
  

In macOS Sonoma and Sequoia, select "System Settings" > "Privacy & Security" > scroll down to "Security" and choose, "Open Anyway."

NOTE: If the installer does not begin, press ctrl+click on the install file and select "Open" to restart the installer.

---

• Next, follow the installation steps.
• You will then be asked to '"Enable Macros" to Activate QI Macros'. Select "OK" and “Enable Macros” when prompted:
  
  
  
  

  *AND*

  
  
  

  *YOU MAY ALSO BE ASKED*

  
  
  

  Select "Allow."

3. Once install is complete, open Excel, open a blank workbook, and look for the QI Macros menu in your Excel sub-ribbon:
   
   

No QI Macros Menu? Click here for tier 2 support options.

Due to security settings within your Excel, QI Macros has been disabled

Microsoft has updated Excel and removed QI Macros as an add-in

Microsoft Excel and/or Microsoft’s AutoUpdater has pending updates

Gallery of Templates is not Disabled

To re-enable QI Macros:

1. Open Excel, open a blank workbook and select the “Tools” drop-down menu from your Excel ribbon. Then select “Excel Add-Ins”:
   
   
2. Does “QI Macros SPC Software for Excel” appear in the “Add-ins available” window? And if so, is it selected?
   
   

If it is not selected, click the box, press “OK” and completely quit out of Excel and reopen – you should now see the QI Macros menu in your Excel sub-ribbon.

If QI Macros does not appear in the Add-ins window:

1. Click “Browse” and search your Mac for the file, qimacros.xlam. Were you able to find it?
2. If so, select the qimacros.xlam file and press “Open” – “QI Macros SPC Software for Excel” should now appear as an add-in in your Excel Add-Ins list. If it does, press “OK”.
3. The QI Macros menu will automatically load into Excel and should now appear in your Excel sub-ribbon.

To check for updates in Excel:

1. If the QI Macros menu still does not appear in your Excel sub-ribbon, 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 now see the QI Macros menu In your Excel sub-ribbon?

Gallery of Templates is not disabled:

If the QI Macros menu does not appear in the Excel sub-ribbon after install, make sure the Gallery of Templates is disabled, when opening Excel.

To turn off the Gallery of Templates, go to Excel: Preferences:

General:

and deselect "Open Excel Workbook Gallery when application opens."

Once you have disabled the Gallery, COMPLETELY quit out of Excel and reopen – you should now see the QI Macros menu in your Excel sub-ribbon.

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

Menu still not appearing? Click here for tier 2 support options.

If your QI Macros is more than two years old, we recommend upgrading to the latest version of QI Macros, with the latest functionality!

Click here if you have purchased a QI Macros license within the past 5 years.

Note: If your QI Macros is more than a year old, it may not be compatible with the latest version of Excel.

If you can't find your Install file and your QI Macros version is less than 5 years old, you may be able to retrieve your license by using one of the following methods:

• If you have your order ID (or invoice number) and password and purchased within the past (30) days, click here to enter and download your setup file.
• You may also use your e-mail and zip code to find your setup file - click here to enter and download your file.
• If we cannot find your setup file because your e-mail isn't in our database, we can look it up! E-mail support@qimacros.com or call 888.468.1537.

Still not able to restore QI Macros? Click here for tier 2 support options.

If you are trying to run the Control Chart Wizard or Control Chart Templates Wizard on a Mac and Excel crashes or doesn't produce a Control Chart, there is a known VBA bug in Microsoft Excel 16.87-16.90.

To troubleshoot, simply rollback your version of Excel from 16.87-16.90 to 16.86. If you would prefer not to do a rollback, the other options would be:

1. To either wait for the next Excel update to be released, to see if this VBA issue has been resolved.
2. Utilize the "CC Wizard Templates On/Off" toggle found in the Control Charts (SPC) > Control Charts Rules menu. Turning this option "Off" will no longer open the associated Control Chart template when you use the Control Chart Wizard:
   
   
3. Update the Security Preferences in Excel. To do so, click on the Excel drop-down in the top left corner and select Preferences > Security. Then, change the Security settings to "Enable all macros":
   
   
4. Once you have done so, rerun the Control Chart Wizard.

However, if you would like to rollback, see instructions below:

1. Visit this link to download 16.86 for Excel.
2. Once you have downloaded the installer package, go to your Applications folder, right-click on “Microsoft Excel” and select “Move to Trash” – do not permanently delete from your Trash just yet.
3. Next, double-click on the 16.86 installer package and follow the install prompts.
4. Once the install has been completed, open Excel and check to make sure 16.86 is now up and running by clicking on the Excel drop-down and selecting “About Excel.”

When you install a new version of Excel, QI Macros isn’t automatically linked – you must reinstall QI Macros using your QI Macros install file.

Note: If your QI Macros is more than a year old, it may not be compatible with the latest version of Excel.

If you can't find your Install file and your QI Macros version is less than 5 years old, you may be able to retrieve your license by using one of the following methods:

• If you have your order ID (or invoice number) and password, click here to enter and download your setup file.
• You may also use your e-mail and zip code to find your setup file, click here to enter and download your file.
• If we cannot find your setup file because your e-mail isn't in our database, we can look it up for a fee. E-mail support@qimacros.com or call 888.468.1537.

Still not able to reinstall QI Macros? Click here for tier 2 support options.

Uninstall QI Macros using the uninstall file:

1. Completely quit out of Excel.
2. Click here to download and run the uninstall file.
• If you receive a message saying the install cannot be opened:
  
  

-or-



• Select "Cancel", and then go to the Apple icon in the top left corner of your Mac device and select “System Preferences” > “Security & Privacy” > “General” and choose, “Open Anyway”:
  
  
3. Once the uninstall file has completed, open Excel - you should no longer see QI Macros in your Excel sub-ribbon.

If your Anti-Virus software blocks the uninstall file from running:

1. Completely quit out of Excel.
2. Remove the qimacros.xlam file found in:
   

   HD\Users\User\Library\GroupContainers\UBF8T346G9.Office\UserContent\Startup\Excel

(if your Library is not visible, click on the "Go" drop-down menu from your Finder ribbon and simultaneously select the "Alt/Option" button.

3. Or open a new Finder window, search for the qimacros.xlam file on "This Mac" and delete any instances of the .xlam file.
4. Once you have removed the qimacros.xlam file, open Excel - you will receive the following message:
   
   
5. Open a blank workbook in Excel and select Tools > Excel Add-Ins. In the add-ins window, de-select any instance(s) of QI Macros from the "add-ins available" list:
   
   
6. You will be asked if you wish to "delete from list" - select "Yes":
   
   

30-Day Trial Note: If you uninstall the 30-day trial, you will not be able to re-install it.

Still not able to uninstall QI Macros? Click here for tier 2 support options.