QI Macros Technical Support Questions
PC

Common Questions
Channel
Version | Build
Release Date
Monthly
2009 | 13231.20514
November 10, 2020
Semi-Annual (Targeted)
2008 | 13127.20760
November 10, 2020
Semi-Annual
2002 | 12527.21330
November 10, 2020
Semi-Annual
1908 | 11929.20974
November 10, 2020

To check which version you currently have installed, open Excel and select File > Account > About Excel.

And click the following link to veiw Microsoft Office's Release History.

The QI Macros install files are located in:

C:\ Program Files \ QIMacros \ xlstart

And the contents of the “xlstart" folder should look like this:

install-file-location

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

You may have disabled Excel add-ins. To re-enable, go to File > Options > Trust Center > Add-ins and de-select the following box:

Excel 2010 Addin Ribbon Doesn't Do Anything

Once you have done so, completely quit out of Excel and reopen – is the QI Macros menu still non-responsive?

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

There may be a conflict with other add-ins. The solution is to find out which one:

  1. Start Excel in Safe Mode by holding down the CTRL key and starting Excel – this will not load any add-ins.
  2. Click on File > Options > Add-ins:

    Excel 2013 Manage Addins Menu
  3. First click on COM add-ins and uncheck any unused add-ins.
    (The Acrobat Add-in seems to be especially problematic, due the preview feature. You can save a PDF directly from Excel.)

    Excel COM Addins Menu
  4. Then, click on Excel Add-ins and de-select any unused add-ins.
    Also, uncheck “Solver Add-in” to speed up loading Excel, unless you need it. Most users do not!

    Excel Addins Menu
  5. Completely quit out of Excel and reopen. But this time, open normally – not in Safe Mode, and see if this clears the problem.
    If it does not, repeat until you find the conflicting add-in.

If Excel is still crashing during startup, e-mail support@qimacros.com or call: 1.888.468.1537

Other Questions | Error Messages

A small percentage of Excel users are finding that when they install Microsoft Office, VBA is not included. Unlike Office 2010, 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 while in Excel. If the Visual Basic Editor window does NOT open, VBA is not enabled or installed.

To double-check, open Excel and 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 365 > Change).

If that does not work, completely uninstall Microsoft Office, using these instructions.

This will remove any traces of the previously installed version of Microsoft Office. Once completed, run a “clean install” from your Microsoft Office installer or Office 365 account.

Now that Office has been reinstalled, open Excel – do you still receive the Runtime Error?

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

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-

  • Open Excel, open a blank workbook, and go to File > Options > Advanced. Scroll down to the “General” section and in the “At startup, open all files in” textbox, delete the pathway entry “C:\Program Files\QIMacros\xlstart”.

Next, reopen Excel – do you still receive the Runtime Error?

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

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-

  • Open Excel, open a blank workbook, and go to File > Options > Advanced. Scroll down to the “General” section and in the “At startup, open all files in” textbox, delete the pathway entry “C:\Program Files\QIMacros\xlstart”.

Next, reopen Excel – do you still receive the Runtime Error?

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

Excel is not able to open QI Macros using the preferred “Alternate Startup” install method. To troubleshoot this, manually move the install files by following these instructions:

  1. Completely quit out of Excel.
  2. Go to the following pathway: C:\Program Files\QIMacros\xlstart\
  3. Select both the qimacros.xlam file and QITemplates folder, then right-click > Cut
  4. Paste these onto your Desktop.
  5. Next, go to the following pathway, depending on your version of Excel:

    2016, 2019, Office 365: C:\Program Files (x86)\Microsoft Office\root\Office16\XLSTART\
    2013: C:\Program Files\Microsoft Office\root\Office15\xlstart\ (or) C:\Program Files\Microsoft Office 15\root\Office15\xlstart\
  6. Paste the qimacros.xlam file and QITemplates folder into the xlstart folder and then open Excel – QI Macros should now appear in your Excel sub-ribbon.

Alternatively, you can select Ctrl+Shift+Q to load the Add-In menu in your Excel ribbon:

ctrl-shoft-q-menu

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

add-ins-menu-drop-down-ctrl-shift-q

If you still do not see the QI Macros menu, e-mail support@qimacros.com or call: 1.888.468.1537.

You may have restricted access to Excel add-ins. Click on the "Application add-ins have been disabled" warning and follow these instructions to make QI Macros a trusted publisher:

security-warning-application-add-ins-have-been-disabled

enable-content-advanced-excel

Excel Trust Publisher

Once you have done so, completely quit out of Excel and reopen – do you still receive a security warning when you open Excel?

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

Your macro security settings may be too high. To fix, follow the instructions below:

  1. Open Excel and open a blank workbook.
  2. Select File > Options > Trust Center > Trust Center Settings:

    trust-center-settings
  3. Next, select “Macro Settings” – Excel default is “Disable all macros with notification.” To get the macros to run, given your security settings, you may need to set this to “Enable all macros”:

    disable-all-macros-setting

Once you have done so, completely quit out of Excel and reopen – is the macro still unresponsive?

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

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.