This page addresses rare issues and issues with older versions of the QI Macros.
- the most common QI Macros issues and questions
- installation instructions and troubleshooting
- uninstall instructions
- issues specific to each version of Excel
QI Macros Menu Issues
Excel Issues and Behavior
Run Time Error Messages
Other Error Messages
Problems with Charts, Templates or Anova tools
Anova Analysis Tools - applies to QIMacros 2010.04 and earlier versions
Control Charts
Histograms
Other Charts
Templates
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:
Problems With Microsoft Windows or Excel
If
you have any other problems...page faults, can't compile, etc. we have found that
it's rarely a QI Macros problem. So, click here to look for answers in Microsoft
Support.
If you still can't find the answer, please complete
the following trouble reporting form. Thanks.
Trouble Reporting Form
How to Determine Your Operating System
and Version of ExcelWe have created an excel file
that you can download and run. It will tell you what operating system and version
of Excel is loaded on your computer (PC or Mac - except Excel 2008). - Download
the PC / Mac Check file
- Save the file to your computer
- Double
click on the file to open it
- If it asks you if you want to enable the
macros in the file - answer "Yes" or "Enable Macros"
- The
file will run and display the results in a window.
Problems
Running a Training DVD The Six Sigma Simplified
and SPC Simplified training DVDs require that you have some kind of media player
loaded on your PC. If you have a media player loaded it should automatically begin
playing the DVD. If you don't have a media player, download one free at:
Once
you have a player loaded, insert your DVD into the drive. If it doesn't automatically
play or prompt you to open the player then: - Open the media player
and select File/Open
- Double click on the DVD drive
- Double click
on the Video_TS folder
- Double click on the Video_TS.VOB file (if you don't
see this file, make sure you are viewing all file types)
- The DVD should
begin playing.
Note: If you have problems with Windows Media Player
and Real Player, try WinDVD. Windows XP allows you to set your computer
to automatically play a DVD. - Without the DVD in your drive, double
click on My Computer
- Right click on the DVD drive and select Properties
- Click
on the Autoplay tab
- Select DVD Movie on the pull down menu
- Then
select a default player
DVD / VHS Formats
There are three video formats used around the world: - NTSC
- used in America and Canada
- PAL - used in Western Europe and Australia
- SECAM - used in Eastern Europe and France
All of our training
videos are in NTSC format. Your VHS or DVD players must be able to play NTSC format
to view our videos. If you are not sure which format is used in your country,
Google "PAL NTSC" and you will find several sites with information by
country and much more information. Resolved
with July 2009 Release. If you have two or more versions
of Excel on your PC, the installer assumes that you want to put the QI Macros
in the most recent version. If you buy a new machine, for example, that
comes with a 60-day trial of the latest Office programs and then install Office
2000, XP, or 2003, Windows still wants you to try the new version! If you want
to change this you can update the registry: - Click on Start-Run and
type "regedit"
- Click on the + for HKEY_CLASSES_ROOT
- Scroll
down until you find Excel.Application and click on it's + sign.
- Click
on CurVer. You should see something that looks like this:
- Double click on (Default) and change the version to:
- Excel.Application.9 (XL 2000)
- Excel.Application.10 (XL XP - 2002)
- Excel.Application.11(XL 2003)
- Excel.Application.12 (XL 2007)
- Excel.Application.14 (XL 2010)
- Reinstall the QI Macros
(this won't work with the 30-day trial).
Alternatively, find where
the QI Macros were installed and move them to the correct folder. - XL
2000 - c:\program files\microsoft office\office\xlstart
- XL 2002 - c:\program
files\microsoft office\office10\xlstart
- XL 2003 - c:\program files\microsoft
office\office11\xlstart
- XL 2007 - c:\program files\microsoft office\office12\xlstart
- XL
2010 - c:\program files\microsoft office\office14\xlstart
Installation
Problems - PC Symptom: C:\WINDOWS\SYSTEM32\AUTOEXEC.NT System
file is not suitable for running MS-DOS and Windows Applications. These
are specific operating system files that will prevent installation. Acording to
Microsoft, the file is either missing or corrupted. See: http://support.microsoft.com/default.aspx?scid=kb;en-us;305521
Resolution: Restore missing file, reinstall Excel or email
us and we can send you an alternate way to install the QI Macros.
Symptom: Cannot find ???.DLL There are specific operating system
files that, when unintentionally removed from a client's system directories, will
cause damage or unpredictable symptoms to occur. These symptoms can include corruption,
crashing, failure to reboot, or slow processing. Some of these files have binary
information that prevents them from being copied. Resolution: Restore
missing file, reinstall Excel or email us
and we can send you an alternate way to install the QI Macros. Win16
.dll files: USER.DLL, KERNEL.DLL, SHELL.DLL, TOOLHELP.DLL, VER.DLL, LZEXPAND.DLL,
GDI.DLL, KEYBOARD.DLL, COMMDLG.DLL, WIN87EM.DLL, DDEML.DLL, Win32 .dll
files: COMCTL32.DLL, COMDLG32.DLL, USER32.DLL, KERNEL32.DLL, ADVAPI32.DLL,
GDI32.DLL, DSKAPI32.DLL, ICM32.DLL, IMM32.DLL, LZ32.DLL, RICHED32.DLL, SHELL32.DLL,
SAGE.DLL, VERSION.DLL, WINSPOOL.DRV, WINMM.DLL, URL.DLL, LINKINFO.DLL, SHLWAPI.DLL,
SHDOCVW.DLL, SHFOLDER.DLL, WSOCK.DLL, WININET.DLL. Other Install Problems:
Excel looks in the XLSTART directory when it first starts up to determine if there
is anything there to load. The QI Macros must be in this directory stored in the
correct sequence for Excel to function properly. Of course, Microsoft never puts
things in the same place and your local tech support may have installed Excel
in a non-standard directory. You can load the macros using Windows Explorer, but
first you have to know where they go. To check if they were loaded in
the directory, from the Excel Window Menu select UNHIDE. This will give you a
list of the Macros if they are in the XLSTART directory. If not, they were not
installed in XLSTART. So, cancel the Unhide and do the following. 
Office 2000, XP, 2003, 2007, 2010Other versions should be stored
in c:\Program Files\Microsoft Office\Office\Xlstart. If not, use Start-Find File
to locate xlstart. 
Network Install
All Versions of Excel
If installing on the network server,
change macro permissions to ReadOnly and install in server XLSTART folder.
If installing on your PC, but loading Excel from the network: - Run
a:setup.exe to load the QI Macros onto your hard disk. It will put them in c:\qimacros\xlstart.
Copy this folder to your network drive.
- Start Excel
- Go to
Tools-Options-General on the menu bar (Excel-Preferences-Options in OS X).
-
Enter the Alternate Startup Directory: g:\qimacros\xlstart
CAUTION: changing
the Alternate Startup Directory back may invoke an Excel bug. You may need to
reinstall the macros to correct the problem. - Close Excel to update Windows
Registry
- Restart Excel. When you have a worksheet open, the QI Macros
menu should appear.
Installation
Problems - 64 bit Machines
The QI Macros setup.exe file will work on 32-bit and 64-bit machines for both Excel 32-bit and 64-bit.
There may still be things we don't quite understand. If you install and don't get a menu or some other odd behavior. Give us a call and we can get online together to check it out.
Runtime error 1004
Cannot Paste Data because... If you have
merged or hidden cells, you may get this error.
To correct, unmerge or unhide
cells and rerun the macro: 
XL2007 - 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.
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).
The formula you typed contains an error.
If you received this error, you have a copy of the QI Macros purchased
before Dec 2006 and recently loaded Excel 2003 Service Pak 3. Unfortunately, this
service pack is not compatible with these older versions of the QI Macros. Here
are your options: - Uninstall the new release of Excel.
- Start-Control
Panel-Add or Remove Programs (e.g., Excel 2003 SP3) or
- Start-All Programs-Accessories-System
Tools-System Restore to an earlier date before the installation.
- Purchase
a QI Macros Upgrade
Charts on template
flicker.Error checking causes charts to flicker. Solution: Click
on Tools-Options-Error Checking and uncheck Formulas refering to blank cells: 
XmR Dashboard stops at 24 ChartsExcel has a physical limit of
124 charts per workbook.
Since there are 4 charts on each XmR sheet, each
time we copy it and add one to the dashboard you end up with 5 more charts (24*5=120).
Solution: Before you create the dashboard: - Delete the other XmR sheet
(median or range)
- Delete the Histogram, probability plot and even the
range chart from the remaining XmR sheet.
- This will allow you to create
up to 60 charts on the dashboard.
- If you need more than 60 charts
- Right click on any sheet name and select "view Code".
- Change
the code in XmR-Dashboard.xls, Module1,Create_Dashboard_XmR:
from "ActiveSheet.ChartObjects(1).Copy"
to "ActiveSheet.ChartObjects(1).Cut"
Rather than make a copy,
this will move the chart to the dashboard, minimizing the number of charts
in the workbook. - Create the Dashboard
Run Time Error 1004: QIMacros.xla could not be foundOne of two
things has happened: - Excel 2007 or 2010
disabled qimacros.xla or QIMacros2007menu.xlam or QIMacros2010menu.xlam.
- QIMacros.xla did not get installed properly.
- Excel 2007
disabled qimacros.xla or QIMacros2010menu.xlam.
To enable the
qimacros.xla or QIMacros2007menu.xlam or QIMacros2010menu.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. 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 2 below. Run
Time Error 1004: Cannot apply the default chart typeYou may have an unusual
"default chart type" that is causing the problem. To fix this, reset
your default chart to a line chart as follows: - Select some data and
use Excel's chart wizard to draw a line chart
- After running the chart, right click on it and select Chart
Type
- Click
"Set as Default Chart" button at the bottom of the window:
This will set the line chart as your default chart.
Macros run, but
can't get templates. - PC Users: If you've recently upgraded
Excel, Excel copies the macros to the new XLStart folder, but not the QITemplates.
Simply reinstall the QI Macros or copy the QITemplate folder from the old xlstart
folder to the new one (e.g., c:\program files\microsoft office\office\xlstart
to office11\xlstart):
- Macintosh Users: If you've recently upgraded Excel, Excel
will copy the qimacros, but not the QITemplates. You will need to copy the QITemplates
folder from wherever it was to the new startup folder:
Microsoft Office
2004:Office:Startup:Excel folder:
- PC Users: In the urge to be thorough, you may have run
setup.exe and then changed the Alternate Start Up File to include the c:\qimacros\xlstart
folder. To resolve this problem, go to TOOLS-OPTIONS-GENERAL and delete the Alternate
Startup Folder. Close Excel and reopen it. The Fill-in-the-blanks Templates should
now work.
Vista stores the old version in:
C:\Users\username\AppData\Local\VirtualStore\Program
Files\Microsoft Office\Office10\XLStart To resolve this issue:
- Close Excel
- Open this folder and delete qimacros.xla and QITemplates
folder.
- Then start Excel.
The Macintosh Office team, in their infinite
wisdom, chose not to support Visual Basic for Applications (VBA) in Excel 2008
for the Macintosh. This means that the QI Macros will not run in Excel 2008 for
the Mac. You can still open and use all of the control chart templates, value
stream maps and so on. We'd recommend that when you install 2008, choose
"custom install" and keep an Excel 2004 or older version to run the
QI Macros. (They are also a lot faster than 2008.) There are rumors that
VBA might return in Service Pack 3 in 2010. We will keep an eye on service packs
for the Macintosh to see if VBA support is added later. 
When
you upgraded Excel, it moved all of the old QI Macros files to:
Windows XP:
- c:\Documents
and Settings\User name\Application Data\Microsoft\Excel\XLStart.
Windows 7:
- c:\users\User name\AppData\local\virtualstore\program files\Microsoft Office\Office14\XLStart.
- Simply delete all of the *.xlm or *.xla files from this folder and open Excel
to bring up the new version.
- If you cannot find these files, search your
hard drive for any file named qimacros(.xlm or xla) or zqimenu.xlm. Remove the
xlm files that are not in c:\program files\microsoft office\office..\xlstart
- Excel
2000 - Service Pack 3 will fix this problem. Download it here: http://support.microsoft.com/kb/326585/en-us
Also: According to clients, the Excel Y2K updates from Microsoft
for DateWatch and DateFix can cause this error. To disable these tools, go to
Excel's TOOLS-ADDINS page and remove the tools. Other addins may cause this problem.
Turn them off one at a time until you find the culprit. Early
versions of the 2007 QI Macros had incorrect code that put "Demo Expired"
Title on the upgrade message. Nothing has expired. Your QI Macros will continue
to function just fine. The revised message looks like this: 
Early versions of the 2007 QI Macros failed to recognize the difference
between regional differences in date formats: mm/dd/yy, dd/mm/yy, yyyy/mm/dd.
If you are getting QI Macros Over One Year Old message, then you must be using
a regional format other than English U.S. (mm/dd/yy). Check Control Panel-Regional
and Language Options: 
In the U.S., change your regional language to English U.S. To
get a corrected version if this happens shortly after purchase, email support@qimacros.com
and request the revised setup file. If your copy is over a year old, you
will need to purchase an upgrade. The QI Macros can't update your
windows registry. When I added the reminder we didn't know that IT departments
can lock the registry. Solutions
1. Have your administrator
reinstall from your QI Macros Setup File.
2. Download
this file and have your administrator run it to update the registry.
To Uninstall
the QI MacrosWarning: If you uninstall the 30-day trial, you
will not be able to reinstall!
Close Excel and run
the Uninstall File or remove the files manually:
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
Office 2010: Remove
qimacros.xla and QIMacros2010menu.xlam files in:
XL 2010 - c:\program files\microsoft
office\office14\xlstart Office 2007: Remove qimacros.xla and
QIMacros2010menu.xlam files in:
c:\Program Files\Microsoft Office\Office12\Xlstart
Office Office 2011 for Macintosh: Remove qimacros.xla file in:
Applications/Microsoft Office 2011/Office/Startup/Excel
Office
2003 and Office 2011 for Macintosh: Remove qimacros.xla file in:
c:\Program Files\Microsoft
Office\Office11\Xlstart
Office XP: Remove qimacros.xla
file in:
c:\Program Files\Microsoft Office\Office10\Xlstart Office
2000 and 97: Remove all qimacros.xlm or .xla files in:
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
Addins
sometimes use the same procedure names which confuses Excel. If you have
recently upgraded Risk Solver or other Addin, the July 2009 release of the QI
Macros was revised to prevent these most of these kinds of conflicts. Workaround:
Open Excel (to load addins), then open files.
Double clicking on
a file to start Excel will still result in Excel quitting unexpectedly.
I have spoken with Excel techsupport and they have no insights or workarounds.
Order an upgrade (item #232) at www.qimacros.com/products.php. For some reason, Norton Antivirus
prevents loading qimacros.xla. First, check trusted locations (XL 2007/2010)
to make sure the xlstart folder is trusted. 
If not, you can run Live Update to get the latest version of the Office
Plugin
or you may have to turn off the Office plugin for Norton Antivirus:
Open the antivirus software, click on Options - Miscellaneous and uncheck
the Office Plugin. See: http://support.microsoft.com/kb/329820
If you get a qimacros menu that looks like this:
You have renamed the qimacros.xla
file to some other name (e.g., qimacros1.xla).
When you do, the menu cannot
find the menu text.
Solution: Rename the qimacros file in c:\program files\microsoft
office\office11\xlstart to qimacros.xla.
Lately I've noticed a number of weird behaviors cropping up in Excel (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:
Excel 2010
Start - Control Panel - Microsoft Office 2010 - Change - Repair
Excel 2007
Click on Options-Resources-Diagnose. You may need your installation CD to complete this process.
Excel 2000-2003
Click on Help-Detect and Repair. You may need your installation CD to complete this process.
WinZip asks for User Name and Password
If you have installed a trial of WinZip on your computer and it expired, WinZip has become the default program to open zipped files. You might consider removing WinZip.
Solution: Use Windows-Compressed (zipped) Folders tool to extract the contents. Right click on the zip file and choose Open With-Compressed (zipped) Folders:
Excel 2000 - No QI Macros Menu
AppearsYou may have a newer version of Excel installed (e.g., XP or 2003).
The QI Macros always install in what the Windows Registry considers the most current
version of Excel. Click on Start and look for Excel or Excel 2003. You
may also use Tools-Options-General-Alternate Startup Folder to specify the path
to the current version's XLStart folder (c:\program files\microsoft office\office11\xlstart). XL
2000 fails to autoload the QI Macros Menu.
You may have Macro Security
set too high.
Click on Tools-Macros-Security and set to medium or low.
Alternate: If you've recentlly upgraded Excel, - You
may have to reinstall the QI macros for the new version
- If you use a
desktop shortcut to start Excel, it may still be pointing to the old version of
Excel. Go to c:\program files\microsoft office\office10 and create a new shortcut
from Excel.exe
No QI Macros menu appears or get a Run Time Error 1004, qimacros.xla could not be found.
Excel has disabled one or more of the QI Macros files. The process for enabling a file is different depending on your version of Excel.
Excel 2010 Instructions
Excel 2007 Instructions
Excel 2000 to 2003 Instructions
A. Click on HELP-ABOUT EXCEL
B. Click
on Disabled Items
C. Enable the QI Macros files: qimacros.xla (2007 -current) or qimacros.xlm (2006) or
zqimenu.xlm (1997-2005) or any other macro.
Excel 2002 Instructions
Try this: Hold down Ctrl-Shift Keys and press "Q".
This will manually load the menus in Excel 97-2003.
If Excel Continues to Disable the file
You may have Macro Security set too high.
Click on Tools-Macros-Security
and set to medium or low.
You may have Addin security set too high in Excel
2007-2010. Click on the Office Button-Excel Options-Trust Center-Trust Center
Settings-Addins, and uncheck both boxes. 
No
QI Macros Menu and there's a Run Time ErrorIt's possible that Visual
Basic For Applications (VBA) was not installed or is disabled. To check, right
click on any sheet name and look at the menu. If "View Code" is grayed
out (see below), VBA is disabled or not installed. 
To enable VBA, you may need to 1)) get into the registry (per Microsoft) of 2)
install VBA.
If VBA is installed, it may be disabled. If one of the
following DWORD registry keys exists and has a value that is greater than 0, VBA
is disabled. Change it back to zero:
Microsoft Office 2010
HKLM\Software\Microsoft\Office\14.0\Common\VBAOff
HKCU\Software\Microsoft\Office\14.0\Common\VBAOff
HKCU\Software\Policies\Microsoft\Office\14.0\Common\Vbaoff
Microsoft
Office 2007
HKLM\Software\Microsoft\Office\12.0\Common\VBAOff
HKCU\Software\Microsoft\Office\12.0\Common\VBAOff
HKCU\Software\Policies\Microsoft\Office\12.0\Common\Vbaoff
Microsoft Office 2003
HKLM\Software\Microsoft\Office\11.0\Common\VBAOff
HKCU\Software\Microsoft\Office\11.0\Common\VBAOff
HKCU\Software\Policies\Microsoft\Office\11.0\Common\Vbaoff
Microsoft Office XP
HKLM\Software\Microsoft\Office\10.0\Common\VBAOff
HKCU\Software\Microsoft\Office\10.0\Common\VBAOff HKCU\Software\Policies\Microsoft\Office\10.0\Common\Vbaoff
To Install Visual Basic for Applications
1. Exit Excel and Open the Control Panel 2. Add/remove programs - Microsoft
Office 20??- Add/remove features 
3.
Choose Advanced Customization of Applications 
3.
Click on Shared Features 
4.
Install Visual Basic For Applications 
5.
Start Excel
Excel
2003: Example above shows main menu, but no choices, just a blue square. Cause:
If Excel or Windows crashes it may leave a ~tmp...xla file in the XLStart
folder. This file gets loaded instead of the qimacros.xla file. To check this,
right click on a sheet name and choose view code. There should only be one QIMacrosSPCforExcel2007
(qimacros.xla) listing in XL97-2003. (XL2007 will have a qimacrosmenu.xlam for
the ribbon.) 
Solution:
Close Excel. Go to c:\program files\microsoft office\office11\xlstart and remove
the ~tmp...xla. Reopen Excel and the problem should be gone.
QI Macros Menu shows up twiceWindows 2000:
For some reason, Windows 2000 "auto opens" the macro twice. It won't
affect your performance and either menu will work. I've opened a ticket with Microsoft.
Win XP, 2003: You probably have installed the macros and
created an alternate startup link to the macros (you load them twice). Go
to TOOLS-OPTIONS-GENERAL and clear the Alternate Startup Folder entry. Win
2007-2010: You probably have installed the both types of menus: qimacros2003menu.xlam
and qimacros2007menu.xlam or qimacros2010menu.xlam.
QI Macros Menu DisappearsIf you: - click on the X in
the upper right hand corner to exit Excel
- or accidentally click it while
trying to close a workbook
- or choose File-Exit
and then Cancel
before exiting Excel, the menu will disappear, because we have to remove the menu
prior to exit. Simply exit and restart Excel.
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.
Runtime
Error 1004:
Command not available in shared workbook.If you get
an error like this one: 
Excel
will not let the QI Macros add charts and sheets to shared workbooks. You
must go to Tools-Share Workbook and uncheck the sharing to allow the QI Macros
to run.
Macros run when I use
the shift keyYour CTRL key is stuck. (This happened to me.)
Turn your keyboard upside down and whack it a couple of times to dislodge whatever
is making the keys stick. (Worst case: you may need a new keyboard.)
Press
both CTRL keys simultaneously to unlock them (pressing one or the other for longer
can cause them to lock from a Windows perspective).
Excel Opens Slowly XL 2000-2010Excel.xlb
Growth
On the PC, Excel stores the toolbar configuration in a file in:
C:\Documents and Settings\user name\Application Data\Microsoft\Excel
Excel 2002: Excel10.xlb
Excel 2003: Excel11.xlb
Excel 2007:
Excel12.xlb
Excel 2010: Excel14.xlb These files grow with every open/close
of Excel with the QI Macros versions dated 3/08-9/09. If you cannot find
the Application Data folder, you may have to show hidden files. Double click on
MyComputer and the c: drive. Then click on Tools-Folder Options and select Show
Hidden Files: 
Changes
will be released in September, 2009 to prevent the growth of these files. You
may upgrade at: www.qimacros.com/orderup.html. To
resolve this problem temporarily, navigate to the folder and right click on the
xlb file and rename it. Excel will create a newer, smaller one as shown in the
example below. 
Preventing
Excel11.xlb growth causes a different issue:
Clicking on Excel's "Close"
button instead of the "Close Window" button to close a file, will remove
the QI Macros menu from your toolbar in Excel XP and Excel 2003.
To
restore the QI Macros Menu, simply hold down the Control-Shift Keys and press
Q. 
Antivirus Issues
See
Microsoft Support Article
Microsoft Excel 2000 and 2002
SYMPTOMS
When you open one of the Microsoft Office programs listed at
the beginning of this article, the program may open slowly. CAUSE
This behavior may occur if Norton AntiVirus is installed on your computer. It
will scan the QI Macros EVERY time you start Excel. RESOLUTION OPTION 1
To resolve this problem, unregister the Norton AntiVirus Officeav.dll add-in by
following these steps:
1. Click Start and then click Run.
2. In
the Open box, type the following command (including the quotation marks), and
then click OK :
regsvr32 /u "c:\program files\norton antivirus\officeav.dll"
If the command is successful, you see the following message:
DllUnregisterServer
in C:\Program Files\Norton AntiVirus\Officeav.dll succeeded. NOTE: If the command
is unsuccessful, search your computer's hard disk for the Officeav.dll file. The
file may be located in a different folder. RESOLUTION OPTION 2 If
you don't want to change your Norton settings AND if you don't use the QI Macros
often, you can move the QI Macros files from the xl startup folder and only have
Excel access them when you need to create a graph. Here's how: - Go
to c:\qimacros and create a folder called xlstart.
- Go to c:\program files\microsoft
office\office\xlstart and move (not copy) the QI Macros files from the c:\program
files\microsoft office\office\xlstart folder to the c:\qimacros\xlstart folder.
Move the contents of the xlstart folder not the folder itself. The QI Macros files
include the QI Templates folder and all of the QI Macros .xlm files including
the zqimenu.xlm file.
- When you open Excel it will no longer see the macros
in its startup folder and Excel should open faster. Note: The QI Macros pull down
menu will be gone.
- When you want to use the QI Macros, go into Tools/Options/General
and type c:\qimacros\xlstart in the alternate startup box. This box is labeled
"Alternate Startup" or "At startup, open all files in: "
- You
may need to restart Excel. Excel will open slowly since Norton is checking all
of the macros. When Excel opens you should now see the QI Macros pull down menu.
- When
you are done running charts, delete c:\qimacros\xlstart from the alternate startup
file box. Excel will open faster again.
Excel Locks Up Or Is Very Slow To
CloseMicrosoft knows this is an EXCEL bug, but there is no fix that I
can find in their support pages. One customer, however, said to go into
Microsoft Outlook-Options-Journaling and deselect Excel, Word, and other files.
Turn Off Macros TemporarilyPress the ESCAPE Key
When
you start Excel, any files that are located in the XLStart folder or the alternate
startup folder begin to open. You can press ESCAPE after the files start to open
to prevent any additional files from opening.
Macro Does Not Run XL
2007-2010Click 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 disable all macros except digitally signed macros. The QI Macros have been digitally signed since February, 2010: 
Macro Does Not Run or Template Does Not Open - Nothing HappensSome
recent Microsoft Excel service releases have tightened up security by limiting
the macros and files Excel allows to be opened and run. To workaround this issue,
change Excels macro security level. - Go to Tools/Macros/Security
- Change your security level to Medium or to Low then close and reopen
Excel and try to run a macro or open a template from the QI Macros pull down menu.
Note: If you have Excel 2000, change the security level to Low.
Template Does Not
Open or Runtime ErrorThe macros look for the templates in a standard location.
If you have an alternate startup folder specified (Tools-Options-General), the
macros may look in that folder instead. If the macros can't find the file, you
may get an error. 
You
can: - Clear the field: "At Startup, open all files in:"
(see above)
- Move the QITemplates folder to the Alternate Startup
location
Copy/Move c:\program files\microsoft office\office11\xlstart\QITemplates
to the specified Alternate Startup file location. Template Dates
off by four yearsDates set
to PC or Macintosh date format.
Go to Tools-Options-General and change
date format to match your machine. March 2009 only. The RunTime
Error 9 is caused by trying to access and change the color of a point that doesn't
exist on the chart.
Example:
If there's 25 points and stability
analysis tries to change the color of the 26th point, RunTime Error 9.
Prior to March 2009, the QI Macros counters
allowed up to 32,767 data points or rows.
If you had more than 32,767 data
points, you get a Run Time Error 6 (overflow).
After March 2009, counters
were changed to long to allow 2 billion. Either a) reduce the
number of data points or b) upgrade to a newer version of the QI Macros. Run
Time Error This is usually caused by
something unusual in the data or labels you selected when running a chart. If
you selected labels and data try just selecting the data. If you are still
having problems, send your excel spreadsheet to support@qimacros.com.
Include a description on what chart you were trying to run and what error message
you received. We will take a look at your data and get back to you as soon as
possible. This
is caused by file names that are too long. Choose File-Save As and pick a name
shorter than 20 characters. Then rerun the chart. If you still can't find the
problem, send your data file and the error message to support@qimacros.com.
Macro Error at Cell A123These are often caused by invalid data (e.g.,
text instead of numbers). Check your data. If you still can't find the problem,
send your data file and the error message to support@qimacros.com.
Macro Not FoundMicrosoft Excel 2002-2003 SYMPTOMS
Excel can't "see" a macro.
RESOLUTION
To resolve this problem,
- In Excel, go to HELP-ABOUT EXCEL
- Click on Disabled
Items
- Enable the missing macro
Excel 2000-XP-2003 - Macro
error at Cell A???You may get this error if there is No Printer Defined
on your computer. Go to START-Settings-Printers and Faxes.
Add a Printer
(any printer) and then rerun the macro.
Can't Open Two
Files With The Same NameIn the urge to be thorough, you may have run setup.exe
and then copied these files into c:\qimacros\xlstart and changed the Alternate
Start Up File to include the c:\qimacros\xlstart folder. You've installed two
copies and Excel is trying to load both. To resolve this problem, go to TOOLS-OPTIONS-GENERAL
and delete the Alternate Startup Folder. Close Excel and reopen it.
Invalid Page Fault in Module OLE32.DLL
when opening templates - PCMicrosoft Office log file is corrupted. This is
where Office stores information about files opend, closed, saved, etc. To correct:
- Find and rename the Offitems.log file (to Offitems.old. All information
in the original log file will be lost.)
- Restart Excel
- Open
a template using FILE-NEW. Problem should be corrected.
Invalid Reference Argument at Cell ...Have you installed another macro package
for Excel (e.g., some other SPC package)? If so, thise may create conflicts that
cause this error. Uninstall the other package. The QI Macros should then work
correctly. That command cannot be used on multiple selectionsMost
likely you have two different data sets selected in Excel and it does not know
which one you want to use to create the chart. Check your spreadsheet and other
spreadsheets in your workbook to make sure you do not have other data fields selected.
Note: selected fields are usually highlighted in black.
Compile Error in Hidden Module - PCExcel startup folder contains
either or both of the following Adobe Acrobat PDFMaker add-in template files.
To correct: - Exit Excel.
- Use Start-Search to find Pdfmaker.dot
and /or Pdfmaker.xla
- Cut them out of the XLSTART folder and paste them
into MyDocuments
Excel
Won't Start (Excel 2000-XP-2003)Check the other xlstart folder
accessed by Excel:
c:\document and settings\user\applicationdata\microsoft\excel\xlstart
Remove any unusual files (e.g., resume.xlw).
You
may have a corrupted installation disk.
H8000ffff hex code catastrophic failure on visual basicYou may
not have enough memory to run Windows, Excel and the QI Macros. Go to desktop
and right click on My Computer, choose Properties to check memory. One user got
this error with only 1GB of memory:
Anova and Analysis Tools requires
Analysis Toolpak If you go to Tools-Addins and check Analysis Toolpak,
Excel will either turn these tools on or ask you to install them. To check
if they have been installed, click on Tools-Data Analysis. If you cannot see Data
Analysis in the Tools menu, the statistical analysis tools are not installed.
Use your installation disk to install them. To Install (get your Excel
or Office installation disk). - On the Tools menu, click Add-Ins.
- In
the Add-Ins available list,
select the Analysis ToolPak box, and then click
OK.
Follow the instructions in the setup program. - You may have
to exit Excel and reopen it to find the data analysis tools at the bottom of the
TOOLS menu.
Office 2000: There may be a Microsoft glitch
in Excel 2000 that allows you to install the addins, but still not see Data Analysis.
The QI Macros Anova and Analysis tools should work, but you may get an "alert"
message each time because they cannot find Data Analysis on the Tool bar. Possible
addin coflict: One client was using the Megastat addin, which may have turned
off the Data Analysis menu item. Where XXXXX
can be ANOVA1, TTESTM, etc. Only Applies to QI Macros versions purchased before April 2010
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 Tools menu and look
for the Data Analysis (i.e., analysis toolpak) at the very bottom of the menu.
You should not see it (left missing, right correct): 
If you click on Tools-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.
The QITemplates
folder may be read only (IT departments do this sometimes, see below). This makes
it impossible to update the ControlChartRules.xls file which keeps the formatting
rules. To correct this, have IT make the folder read/write, then redo the p/u
format change. 
Excel
has the default format for a chart set to include data labels. Solution: Reset
the default chart type. Click on the chart to bring up the chart menu and
choose: "Change Chart Type": 
Then
click on the plain line graph style and click Set as Default Chart: 
After changing the default chart type, when you run a QI Macros control
chart, the data labels should disappear.
Try
inserting a chart using Excel's chart tools. Is this one scrunched?
If
so, exit Excel and go to: c:\Documents and Settings\your user name\Application
Data\Microsoft\Excel 
Delete
Excel??.xlb and any .xls files (like XLUSRGAL.XLS above).
I think Excel
stored a previous chart file (XLUSERGAL.XLS) in this folder and uses it as a template
for something weird. Start Excel. Any charts you create should now look
normal.
Excel 2000-2010
We found that if you've accidentally or on purpose set Excel's default chart type
to pie or radar chart, the pareto, scatter and dot plot won't work correctly. Set
your default chart back to a column or line chart. Excel 2000 and XP
In
both 2000 and XP, once you create a histogram with USL and LSL and control limits,
if you save the file and reopen it, Excel moves the arrows and text fields to
the left. 
Excel
seems to remember where to put the arrows and text, but doesn't display them properly.
If you open the file in 2003 or 2007, the histogram displays correctly. If you
click on File-Print Preview in Excel 2000 or XP, you'll see that they should print
properly: 
You
can use the Drawing toolbar's selection arrow to select and reposition the arrows.
Use the selection tool to click on an arrow and move everthing back to it's original
position: 
Or,
once you've created a chart, you can "protect" the sheet to lock the
arrows in place: 
Cp, Cpk, etc are off the chart to the rightThe
most recent version of the QI Macros fixes this in most instances. If you have
an older version of the QI Macros you might consider purchasing an upgrade.
If you have a recent version of the QI Macros, you may experience this
problem when your spec limits are far apart but your data is clustered together.
In order to make room for the spec limits, the macro may have pushed the metrics
too far to the right. You can select and move the text boxes as follows:
- Make sure your drawing toolbar is open (usually appears at the bottom of your
spreadsheet). If it is not, select View/Toolbars/Drawing.
- Click on the
arrow to change your cursor.
- Click
and drag over the text boxes to select them.
- Move
the boxes back on the page.
- Click on the arrow to change your cursor back
to normal.
I can't change the sheet name of a chartIn
Excel XP (System release 0), if you type a name that's too long for the sheet
name, Excel reverts to the original name. 1. Use a shorter name 2.
Upgrade to System Release 3 (SR3) Using
Lot Numbers on ChartExcel and the Macros cannot distinguish lot numbers from
data, unless you put a leading character in front of the number. To do this,
- insert a column between your lot numbers and your data.
- Use Excel's text
function as shown below to convert the numbers into text with leading text, in
this case L for lot.
- Select the new column/data and run the chart of your
choice.
Histogram
Print Truncates Decimal PointsFor some reason, some versions of Excel truncate
numerical fields linked to the histdata page. To make the decimals reappear, simply
click on the bottom right "handle" of the textbox and drag to
increase the size of the box. Dates on the X-axis cause
data to plot strangelyWhen you use dates or time for the X-axis labels,
Excel automatically treats them as a time-series: it plots them in date/time order.
On a control chart, this can cause points to stack up. Look at this c Chart: 
We
have four points for the same day and Excel stacks them instead of spreading them.
To resolve this problem,click here to go
to our Excel FAQ Page. Strange colored background
on charts and spreadsheetsXL 2000-2003 have the ability to reset your
color palette. This may cause problems with your backgrounds. If you get a chart
or sheet that looks like this with a green or other colored background: 
Then simply reset your color palette to clear the problem. Click on Tools-Options-Color
then click the Reset button and OK to restore the defaults.
XL 97-2003 Worksheet menu bar displays
the 'Chart' menu no matter what I do.Don't know what caused this for a
customer, but I found a way to resolve it using VBA. Download
the file by clicking here and it will activate the menus when it opens.
Extra Blank Worksheet AppearsThe
QI Macros always open a blank worksheet (to mimic Excel at start up). If you double
click on a file to start Excel, the information about your file isn't available
until after the QI Macros have loaded. So the software cannot check for
the existence of an open document to prevent opening a blank sheet. If this really
bugs you: If you purchased the QI Macros prior to Feb 20, 2006 -
Close Excel
- Go to C:Program files/Microsoft Office/Office (10, 11 or 12) and
find the zqimenu.xlm file.
- Right click on the file, select properties, and
uncheck the READONLY box.
- Open Excel and click on Window-Unhide and select
zqimenu.xlm
- In Column A, about line 16 you will find an IF statement that
checks for Book1 before it opens a NEW workbook.
= IF(ISERROR(GET.DOCUMENT(1,"Book1")),NEW(5))
- Clear this cell
- Select Window-Hide to hide the macro
- Exit Excel and
save the zqimenu.xlm file over the existing one in the XLSTART folder.
- When
you start Excel again, it will not open a blank workbook.
If you purchased
the QI Macros between Feb 20, 2006 and Jan 1, 2007 - Close Excel
- Go
to C:Program files/Microsoft Office/Office (10, 11 or 12) and find the QIMacros.xlm
file.
- Right click on the file, select properties, and uncheck the READONLY
box.
- Open Excel and click on Window-Unhide and select QIMacros.xlm
- In
Column A, about line 7 you will find an IF statement that checks for Book1 before
it opens a NEW workbook.
= IF(ISERROR(GET.DOCUMENT(1,"Book1")),NEW(5))
- Clear this cell
- Select Window-Hide to hide the macro
- Exit Excel and
save the QIMacros.xlm file over the existing one in the XLSTART folder.
- When
you start Excel again, it will not open a blank workbook.
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
