The QI Macros install files are located in:

C:\ Program Files \ QIMacros \ xlstart

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

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:

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:
   
   
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.)
   
   
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!
   
   
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

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 their “Fix It” tool.

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:

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

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:

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:
   
   
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”:
   
   

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

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.