|
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?
| |
Recent Excel security update has disabled the QI Macros. |
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 loadedExcel 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:
- Click on the Office Icon in the top left corner, then Excel Options, then
Resources.
- 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.
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 and
has been reported to Microsoft. Just hit "ok" and ignore the message
as there is nothing wrong with the template or its formulas.
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: 
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: - Uncheck the Analysis Toolpak in Tools-Addins
- Exit
Excel
- Open Excel
- Click on Tools-Addins and Check the Analysis
Toolpak.
- 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 foundOne of two things
has happened: - Excel 2007 disabled qimacros.xla
or QIMacros2007menu.xlam.
- QIMacros.xla did not get
installed properly.
- 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.
- 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:
- Close Excel
- Go into Control Panel on your PC by clicking on "Start"
and then Control Panel.
- In
the Control Panel, choose "Add or Remove Programs" (Programs and Features
in Vista).
- Select Microsoft Office in the list and click on the Change
button.
- Another
window will open with a list of options, choose "Add or Remove Features."
- 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.
- 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.
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: 
II.
Excel gets confused if it thinks the macros are an addin and in the xlstart folder.
- Click on the Office button and click on Excel Options.
- Select Addins
and click on the "Go..." button:
- Uncheck the QI Macros Addin button:
- Close Excel and start it again.
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: 
- 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:
- Click
on Hidden and Empty Cells button at the bottom of the menu:
- You should see that Excel is defaulting to showing empty cells
as zero, not gaps. Click on Gaps button and then OK.
- 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 changeOn 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 FlickersDelete 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 StartDelete 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). 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.
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). 
There's
incorrect code in the XL2007 menu. Send us your file from: c:\program files\microsoft
office\office12\xlstart\QIMacros2007menu.xlam We'll send you the corrected
one. | 
view cart · contact 
view cart | contact