Excel 2000 - QI Macros Technical Support |
||
| home
· products
· services · search
· |
||
| NAVIGATION | |||||||||
Jay Arthur
Copyright © 2011
|
Technical Support Questions Specific to Excel 2000
We have found that many customer questions are actually about Excel or statistics, not the QI Macros. Check these FAQ pages: No QI Macros Menu AppearsQI Macros may have installed in a newer version of Excel (e.g., XP or 2003). The QI Macros always install in the most current version of Excel. Click on Start and look for Excel or Excel 2003. Then open this version of Excel up and see if the QI Macros appear on the menu bar. If you want the QI Macros to appear in Excel 2000, either re-run the installtation wizard and select that version of Excel when prompted or do a search on qimacros.xla and then copy that file and the QI Templates folder found with it to: (c:\program files\microsoft office\office\xlstart) XL 2000 may have failed to autoload the QI
Macros Menu. Alternate: If you've recentlly upgraded Excel,
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. Excel 2000 - Run-Time Error - Automation
Unfortunately,
this is an Excel bug, but they no longer supply the "hot fix" to correct
the problem. Here is what Microsoft has to say. http://support.microsoft.com/kb/813120
The arrows on histograms move aroundExcel 2000 and XP
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:
|
Free Training ResourcesQI Macros Lessons and How to Articles QI Macros 1 hr Webinar Recording Engineering Statistics On Line Handbook
|
|||||||
|
home | products | services | search | sitemap | QI Macros | Excel SPC Software | SPC Software Free Trial Control Charts | c Chart | np Chart | p Chart | u Chart ImR Chart | XmR Chart | XMedianR Chart | XbarR Chart | XbarS Chart | EWMA Chart Anom Chart | Cusum Chart | Levey Jennings Chart | Moving Average Chart Histograms | Pareto Chart | Scatter Plot | Run Chart Box Whisker Plot | Dot Plot | Multivari Chart Lean Six Sigma Training | Lean Six Sigma Training Denver Lean Six Sigma Consulting | Lean Six Sigma Consulting Denver Lean Six Sigma Training Systems | Do-It-Yourself Lean Six Sigma Training |
|||||||||