Excel 2007 - 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 help people think!

Copyright © 2008

• QI Macros FAQs
• Excel FAQs
• SPC FAQs

Here are the technical support issues that apply to Excel 2007.

• Runtime error 1004: "Cells" method failed of "_Global" object
• Macro does not run - nothing happens XL 2007
• Run Time Error 1004 - The Macro "xxx" cannot be found
• Run Time Error 1004 QIMacros.xla could not be found (Excel 2007)
• Error Message: qimacros.xla is already open, reopening...

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.

Macro Does Not Run XL 2007

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

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 several things has happened:

1. QIMacros.xla did not get loaded.
2. QIMacros.xla has been disabled by Excel.
3. Excel's XLStart Folder is not a "trusted location"
4. XL Start Folder is not being read by Excel

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

2. QIMacros.xla has been disabled by Excel. Perform the following steps to find and enable the file.

   Click on the Office icon in the upper left corner of the screen and then click on Excel Options

   

   Click on Add ins and look for any Disabled Application addins at the bottom of the list of add ins. If the QIMacros.xla file is listed, enable it.

   

3. XLSTART Folder is not in Excel's Trusted Locations.
   Click on the round Office Button and select Excel Options:
   
   
   Under Excel Options, Select Trust Center and click Trust Center Setting Button.
   
   
   See if there is a trust location in Program Files/Microsoft Office/Office12\XLSTART:
   
   
   If not, click on add new location and add one.
   Also check subfolders to allow Excel to access the templates.
   
   
   Exit and reopen Excel to see if you can access the macros and templates.

 

4. XLSTART Folder is not being read by Excel. If solutions 1 through 3 don't work, try moving the QI Macros files to a new folder and using the Alt Startup option to load the files.

   Go to c:\QIMacros and create a new folder called Xlstart

   Go to c:\Program Files\Microsoft Office\Office(10,11,12)\Xlstart and move the contents of that folder (not the folder itself) to the new folder you just created at c:\QIMacros\Xlstart. The contents will include the QI Templates folder, the qimacros.xla file and the QIMacros menu.xlam files.

   

   Open Excel, QI Macros will no longer be on the menu bar.

   Click on the round Office Button and select Excel Options:
   

   Click on Advanced, then scroll down to the General section and input the path of the new folder in the box next to the words "At startup load all files in". The path should be c:\QIMacros\Xlstart.

   
   Click OK at the bottom of the window, then close Excel and reopen it.

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

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.