|
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 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:
- 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.
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 found
One 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 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).
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 fix it and send it back.
|
view cart · contact 
view cart | contact