Excel 2007 - QI Macros Technical Support

Shopping cart

0 Product(s) in cart

Total $0.00

» Checkout

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

Most Common Technical Support Questions for Excel 2007

• No QI Macros Menu
• Run Time Error 1004 qimacros.xla could not be found
• Excel 2007 Service Paks not loaded
• My Computer Crashed and I Can't Find My CD or Install File

Installation Instructions and Troubleshooting

Installation Instructions

Where the QI Macros Files are installed on my PC?

Possible Install Issues or Error Messages

• Installation Wizard ran but I don't see QI Macros on my menu
• Object variable not set (Error 91)
• qimacros.xla is already open, reopening...
• Repairs to qimacros.xla. Excel was able to open the file by repairing or removing the unreadable content.

To Uninstall a QI Macros License or 30-Day Trial

The QI Macros is an Excel add-in and not a separate application. Therefore it does not uninstall using Add/Remove programs. Instead follow the instructions below:

• Run Uninstall File: Close Excel and click here to download and run the uninstall file
• Uninstall manually: Follow these instructions to delete the QI Macros files on your computer
• QI Macros still shows up under Add /Remove Programs after I uninstall manually

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

Other Issues

Problems When Running a Macro

• Macro does not run - nothing happens
• Missing X Axis Date Labels
• R Chart lines all start at zero
• X Charts - cannot show Ghost point, process change, delete point, etc.

Problems When Opening a Template

• Gage R&R Template: A formula in this worksheet contains one or more invalid references.
• XmR Dashboard: Circular Reference after Ghosting a point or showing a process change.

Excel 2007 Issues with Fixes

• Excel Formula Bar Flickers
• Excel 2007 slow to start up
• Excel 2007 crashes when data entered (Vista)
• Excel installation files corrupted causing weird behavior

The 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 Pak loaded.
• search Microsoft's Support page or
• contact us via email at support@qimacros.com or phone

Tech Support Archives

We have found that many customer questions are actually about Excel or statistics, not the QI Macros. If you have these kinds of questions, check these FAQ pages:

• Excel FAQs
• SPC FAQs

Installation Instructions

1. Close Excel
2. Double click on the QI Macros setup.exe file to run the installation wizard.
3. Answer the prompts
4. Open Excel, you should see "QI Macros" on your menu bar.

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. Click here for instructions to re-enable the files.

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 Fill-in-the-blanks Templates from the pull down menu.

Where do I find the of QI Macros Files on My PC?

The QI Macros is loaded in the XLStart folder at c:\Program Files\Microsoft Office\Office12\Xlstart. Yyour XL Start folder should contain the following files.

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.

No QI Macros Menu Appears or

Run Time Error 1004: QIMacros.xla could not be found

One of two things has happened:

1. Excel disabled one of the QI Macros files.
2. QIMacros.xla did not get installed properly.

1. Excel disabled one of the QI Macros files.
   To enable the disabled file (qimacros.xla, QIMacros2010menu.xlam or QIMacros2007menu.xlam):
   • Click on the Office Button in the top left corner of Excel and Select Excel Options.
   • Then Click on Add-Ins in the left-hand column.
   • Then Click on Manage at the bottom of the screen and select Disabled Items:
   
   

• Then Click on the GO button next to your selection to see all disabled items:
  
  
  
• Click on each of the qi macros disabled items and click Enable.
  
  
• Once you've enabled all of the QIMacros disabled items, exit Excel and then re-open it.
  
  
1. QIMacros.xla did not get loaded.

   Go to c:\Program Files\Microsoft Office\Office(10,11,12)\Xlstart and view the contents of the XLstart folder, it should look like this:

   

   If your XLStart folder contains some kind of temporary file, delete the temporary file and see if this solves the problem. If your folder is missing the .xla file, then close Excel and reinstall the QI Macros. If your XLStart folder contains the files, then Excel has disabled them. See step 1 above.

Excel 2007 Service Paks not loaded

Excel 2007 Service Paks correct many of the bugs that were released in the original version of Excel 2007. Many of these fixes affect Excel's charting capabilities so you will want to ensure that you have them loaded. To date, Microsoft has released two service paks for Excel 2007.

To check your version and update to the latest service pak:

1. Click on the Office Icon in the top left corner, then Excel Options, then Resources.
2. The bottom line entitled "About Microsoft Excel 2007" will tell you which service pak you have loaded (should be SP2). To load the latest service paks or to check if you need updates, click on "Check for Updates" in the top line.

qimacros.xla is already open, reopening...

There's three possibilities:

I. The XLSTART folder is also in the Excel Options - Advance - At Startup, open all files in...(see below).
If so, clear this field:

II. Excel gets confused if it thinks the macros are an addin and in the xlstart folder.

1. Click on the Office button and click on Excel Options.
2. Select Addins and click on the "Go..." button:
   
   
   
3. Uncheck the QI Macros Addin button:
   
   
   
4. Close Excel and start it again.

III. A registry key, "OPEN", is causing Excel to open the qimacros.xla file twice.

1. Start-Run-Regedit
2. Search for "qimacros.xla"
3. If you see a key "OPEN" that is forcing Excel to open the qimacros.xla, delete it:
   

Object variable not set (Error 91)

Your QI Macros 2006 or earlier version is not compatible with Excel 2007. You need to purchase a new QI Macros license.

Repairs to qimacros.xla. Excel was able to open the file by repairing or removing the unreadable content.

QI Macros code is written in Visual Basic. When you install the QI Macros and then open Excel, you will receive this error when "Visual Basic for Application" was not installed with MS Office 2007-2010.

In order to fix this issue, you need to install Visual Basic as follows:

1. Close Excel
2. Go into Control Panel on your PC by clicking on "Start" and then Control Panel.



3. In the Control Panel, choose "Add or Remove Programs" (Programs and Features in Vista).
4. Select Microsoft Office in the list and click on the Change button.



5. Another window will open with a list of options, choose "Add or Remove Features."



6. Open the "Office Shared Features" list by clicking on the "+" next to it. Select "Visual Basic for Applications" and set it to "Run from My Computer." Then click continue.



7. You will then get a window that shows you the progress of the Configuration Process. This will take a couple of minutes and then you should receive a "Configuration Successful" window. Click Close and then reopen Excel.

To Uninstall the QI Macros

Uninstall using the uninstall file: Close Excel and click here to run the uninstall file

Note: In Windows 7 with 32 bit versions of Excel (all versions except 2010) you will find the files in Program Files x86 vs Program Files

Uninstalling the 30-Day trial:

If you uninstall the 30-day trial, you will not be able to reinstall it again. If you need more time to evaluate the software, send an email to support@qimacros.com and ask for an extension.

QI Macros still shows up under Add /Remove Programs after I uninstall manually:

The QI Macros has been uninstalled. If you want to remove it from your Add /Remove Programs list, close Excel and run the Uninstall File

Macro Does Not Run - Nothing Happens

Your macro security settings may be too high. Click on the Office Button and Excel Options (bottom):

Then click on Trust Center Settings (bottom right):

Excel 2007-2010 defaults to disabling all macros with notification. So to get the macros to run, set macro security to Enable All Macros:

Missing X Axis Date Labels

This appears to be an Excel 2007 bug.

To show all dates, right click on the axis and choose Format Axis. Then check the Date Axis checkbox.

R chart lines all start at zero

While Excel 97-2003 all default to showing blank cells as "gaps" in charts, some (but not all) versions of XL2007 show blanks as zeros, which causes all lines to start at zero:

1. While I have not been able to figure out how to change Excel 2007's default, here's what to do to correct the graph. Click on Chart-Design-Select Data:
   
   
   
2. Click on Hidden and Empty Cells button at the bottom of the menu:
   
   
   
3. You should see that Excel is defaulting to showing empty cells as zero, not gaps. Click on Gaps button and then OK.
   
   
   
4. Excel will hide the blanks and correct the chart.
   

X Charts cannot Ghost point or show process change

On the sheet where the X and R charts are embedded together, Excel 2007 does not "trap" the clicking of a point. This is an Excel 2007 bug (doesn't seem to be in earlier versions).

To work around this, click on the X chart or R Chart sheets and make your changes there.

GageR&R: A formula in this worksheet contains one or more invalid references.

Excel 2007 does not recognize #NA as valid cell contents. The QI Macros use this to control the format of GageR&R charts.

This is a known problem in Excel 2007: http://support.microsoft.com/kb/931389

Just hit "ok" and ignore the message as there is nothing wrong with the template or its formulas.

XmR Dashboard: Circular Reference after Ghosting a point or showing a process change.

Chart Menu items mistake "Average" in cell X1 on the chart sheets as being a Range Chart, not part of the Histogram. (First noticed June 2010.)

Open c:\program files\microsoft office\office12\xlstart\QITemplates\XmRDashboard.xlt

Change cell X1 in XmR Average and XmR Median sheets to "AveMean". Save the templates.

Excel 2007 Formula Bar Flickers

Delete the contents of "c:\documents and settings\%username%\application data\microsoft\excel" and reboot the computer. The folder contents will be re-created the next time you open Excel. The problem should not return.

Excel 2007 Slow To Start

Delete the contents of "c:\documents and settings\%username%\application data\microsoft\excel" and restart Excel.

Also delete c:\program files\microsoft office\office12\xlstart\PDFMaker.xla (the Adobe Acrobat addin which works for XL2003 and earlier).

Excel 2007 crashes in Vista when data entered

Sometimes old addins from prior versions of Excel can cause problems for Excel 2007.

Click on Excel Options - Addins and uncheck anything other than the Analysis Toolpak. In the example below, we unchecked LinkedIn Outlook Toolbar and Lookup Wizard and Excel 2007 started working again.

Excel installation files corrupted causing weird behavior

Lately I've noticed a number of weird behaviors cropping up in Excel 2007 (e.g., Excel's chart menu appears on a worksheet instead of a chart sheet). When we repair Excel, everything (including the QI Macros) starts running better. To repair your installation of Excel:

Click on Options-Resources-Diagnose. You may need your installation CD to complete this process.

Free Training Resources

QI Macros Lessons and How to Articles

QI Macros Example Videos

QI Macros 1 hr Webinar Recording

QI Macros Formulas

QI Macros User Guide

Engineering Statistics On Line Handbook