Macintosh - 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

Mac Installation Instructions

• QI Macros purchased in Oct 2011 and later
• QI Macros purchased in Sep 2011 and before

Mac OS / Excel Compatibility Information

Compatible with Apple Macintosh OSX 8,9,X (10.1 to 10.6)

Compatible with these Microsoft versions of Office and Excel for the Mac:

• Excel 2004
• Excel 2011 - make sure the latest service paks are loaded

Excel 2008 - does not support macro code so only the QI Macros fill-in-the-blank-templates work with this version of Excel for the Mac.

New 30 Day Trial for Mac Users

Technical Support for QI Macros SPC Software for the Macintosh

Installation Instructions - QI Macros purchased Oct 2011 and later

1. Close Excel and locate the QI Macros installation file



On your CD	Download from Internet in your Downloads folder



2. Click on the QIMacros.mpkg file to begin the installation wizard.




3. Input your password if asked (this is the password you set up and have to input whenever you install any software on your Mac).



4. Then follow the prompts to install the QI Macros.

5. Open Excel and see the QI Macros on your menu.

Installation Instructions QI Macros purchased Sep 2011 and earlier

1. The Macintosh Installation Files folder contains a folder titled "Excel"
2. Copy the qimacros.xla file and the QITemplates folder in the Excel folder to the following folder on your Mac (Hint: do not copy the folder, just the files it contains).

• Applications : Microsoft Office : Office : Startup : Excel

Excel 2011 Menus Grayed Out

Solution: When you open Excel 2011, it shows the Gallery of templates.

• Simply put a checkmark beside the "Don't show this when opening Excel" box at the bottom (see below) then choose a template.
• Close Excel. You may have to use Command-Option-Esc to "force close" Excel.
• Start Excel. All menus should be visible.
  
  

Or, if you double click on a file to start Excel, you'll be able to get to Preferences-General.
Uncheck Open Excel Workbook Gallery when application starts:

QI Macros do not work in Excel 2008

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.

VBA Run-Time Error '68'

The QITemplates folder is missing from Startup-Excel.

Solution: Move QITemplates folder into:
Applications:Microsoft Office 2011:Office:Startup:Excel

QI Macros Menu shows up twice

You probably have installed the macros and created an alternate startup link to the macros (you load them twice).

Go to EXCEL-PREFERENCES-GENERAL and clear the Alternate Startup Folder entry.

Dates in the template are off by 4 years?

Excel has two date formats: 1900 for the PC and 1904 for the Macintosh. To correct this problem while in the template, click on Excel's Tools-Options-Calculation and check/uncheck the 1904 Date System checkbox:

Excel 2004 - Out of control points on control charts do not change to red.

After extensive testing, I determined that Excel 2004 VBA cannot change point colors on control charts. I have reported this to Microsoft.

Excel 2004 - Shadows on line charts cause double vision.

After extensive testing, I determined that Excel 2004 defaults to shadows on line graphs, control charts, etc. (See below). This was fixed April 2009. If you have this problem and want it fixed, you will need to purchase an upgrade.

Free Training Resources

QI Macros Lessons and articles

QI Macros Example Videos

QI Macros formulas

QI Macros User Guide