Excel 2007 - QI Macros Technical Support

home · products · services · search · view cart · contact  
 
  NAVIGATION        
 
Shopping cart  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 help people think!

Copyright © 2009



 

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:

What were you doing when you received the error?

Description of Problem with Link to Fix

Root Cause

Installed the QI Macros and Opened Excel
Run Time Error 1004: qimacros.xla could not be found Macros did not get properly loaded or are disabled by Excel
Run Time Error 1004: "Cells" method failed of "_Global" object Excel SP1 bug
Repairs to qimacros.xla. Excel was able to open the file by repairing or removing the unreadable content. Visual Basic is not installed
Excel is trying to open the QI Macros twice.

Recent Excel security update has disabled the QI Macros.

I Want to Uninstall the QI Macros Uninstall by removing files in your XLStart folder.

Ran a Macro or Used a Template
GageR&R: A formula in this worksheet contains one or more invalid references. Excel 2007 does not recognize #NA as valid cell contents. Excel 2007 bug.
Macro does not run - nothing happens XL 2007 Macro security settings are too high
X Charts - cannot use Ghost point, delete point, etc. Excel bug with easy workaround
R Chart lines all start at zero Excel graphing defaults need to be overriddent
Excel bug

There's incorrect code in the XL2007 menu.

Ran Anova or Other Statistical Tool

Run Time Error 1004: The Macro "xxx" cannot be found (where xxx is ttestm, anova1, etc)

Excel can't find its Analysis Toolpak.

Other Excel 2007 Issues
Weird Excel behavior with fix
Excel 2007 slow to start up Weird Excel behavior with fix
Excel 2007 crashes when data entered (Vista) Old add ins may need to be deleted
Delete old menu file

We have found that many customer questions are actually about SPC, Excel or statistics, not the QI Macros. Check these FAQ and training pages:

Technical support issues and fixes that apply to Excel 2007.

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.

 

Runtime error 1004
"Cells" method failed of "_Global" object.

Excel 2007's error handling routine seems to have glitches in SP1. I have implemented a workaround as of 9/9/08. Load Service Pak 2 if you have not done so.


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 an Excel 2007 bug.


Macro Does Not Run - Nothing Happens (XL 2007)

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 defaults to disabling all macros with notification. So to get the macros to run, set macro security to Enable All Macros:

Run Time Error '1004': The Macro 'XXXXX' cannot be found. Where XXXXX can be ANOVA1, TTESTM, etc.

Excel XP-2007
Customers have noticed and we were able to recreate a situation where Excel seems to lose track of the Analysis Toolpak.

If you get this error confirm the problem by clicking on the Data menu and look for the Data Analysis. You should see what is shown below:

If you click on Excel Options-Addins, however, you will see that the Analysis Toolpak addin is checked. This is an Excel bug. The Toolpak is checked, but Excel doesn't seem to know it.

To correct this problem:

  1. Uncheck the Analysis Toolpak in Tools-Addins
  2. Exit Excel
  3. Open Excel
  4. Click on Tools-Addins and Check the Analysis Toolpak.
  5. Confirm that the Data Analysis option is now available on the Tools Menu.


The Anova tools should now work properly.

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

One of two things has happened:

  1. Excel 2007 disabled qimacros.xla or QIMacros2007menu.xlam.
  2. QIMacros.xla did not get installed properly.
  1. Excel 2007 disabled qimacros.xla or QIMacros2007menu.xlam.
    To enable the qimacros.xla 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 start Excel 2007. The qimacros.xla file should open automatically.

  2. 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.

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.

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.

Error Message: qimacros.xla is already open, reopening...

There's two 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:

XL2007 Alternate Startup is set to XLStart

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.

R chart lines all start at zero

While Xl97-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.

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

Excel 2007 sometimes sees invalid references were there are none.
This is a known problem in Excel 2007: http://support.microsoft.com/kb/931389
This is not a problem in previous versions of excel.

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.

XL 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.

XL 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).

XL 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.

Addin Menu Still Shows Old QI Macros Menu

July 2009+ versions of the QI Macros remove this menu automatically.

To remove this menu manually, go to:

C:\Documents and Settings\user name\Application Data\Microsoft\Excel

and delete Excel12.xlb (this file stores the old menu).

Error 400 when opening a template

There's incorrect code in the XL2007 menu. Send us your file from:

c:\program files\microsoft office\office12\xlstart\QIMacros2007menu.xlam

We'll fix it and send it back.

 

 

QI Macros Formulas

QI Macros Test Data

QI Macros Training Resources

 
home | products | services | search | sitemap | Shopping cart view cart | contact
QI Macros | Excel SPC Software | SPC Software Free Trial
Control Charts | c Chart | np Chart | p Chart | u Chart
ImR Chart | XmR Chart | XMedianR Chart | XbarR Chart | XbarS Chart | EWMA Chart
Anom Chart | Cusum Chart | Levey Jennings Chart | Moving Average Chart
Histograms | Pareto Chart | Scatter Plot | Run Chart
Box Whisker Plot | Dot Plot | Multivari Chart

Lean Six Sigma Training | Lean Six Sigma Training Denver
Lean Six Sigma Consulting | Lean Six Sigma Consulting Denver
Lean Six Sigma Training Systems | Do-It-Yourself Lean Six Sigma Training