Troubleshooting Guide for Common Problems
On this page we have provided information needed to deal with any known issues that one may encounter using Uncertainty Toolbox. These problems are known Excel and VBA issues for which we have listed the fixes and workarounds. If you have any problem not addressed here, please call Quametec at 810-225-8588 for free assistance.
INDEX of SOLUTIONS
1. Known Installation Issues
2. Known Template Error Issues
3. Known Interface Error Issues
4. Known Analysis Workbook Open Error Issues
Known Installation Issues
PROBLEM: Old version of Uncertainty Toolbox Addin is still coming up after NEW version is installed
Excel 2000 to 2003: If after running the install file you still have the older version coming up in the menu bar, do the following:
1. With Excel closed, navigate to the old install directory, this is probably found under "Program Files", "Uncertainty Toolbox". Then delete any and all files named "UncertaintyApp.xla" or "UncertaintyApp.bak".
2. Open Excel, click on "Tools" and then "Addins". Deselect "UncertaintyApp" from the list. You should get a message that Excel cannot find the Addin and it will ask if you want to remove it from the list, click "Yes".
3. Close and re-open Excel to ensure that no error messages remain.
4. Click on "Tools" and select "Addins".
5. In the window that opens, click on the "Browse" button.
6. Navigate to the "UncertaintyApp.xla" file. By default this is located at C:\UncToolbox_2.8\.
7. Select the "UncertaintyApp.xla" file and click "Ok". You should be back to the Addins window. Ensure that "Analysis Toolpak", near the top of the list, is selected along with the Uncertainty Toolbox addin, now found at the bottom of the list.
8. Click "Ok" and you should now see the "UncToolbox" in the menu bar.
Excel 2007:
1. With Excel closed, navigate to the old install directory, this is probably found under "Program Files", "Uncertainty Toolbox". Then delete any and all files named "UncertaintyApp.xla" or "UncertaintyApp.bak".
2. Open Excel, click on the Office Button in the upper left corner and selecting "Excel Options". Select "Trust Center " in the windows left bar and click on "Trust Center Settings" button.
3. Select "Addins" on left bar and click on the "Go" button.
4. In the window that opens, deselect "UncertaintyApp" from the list. You should get a message that Excel cannot find the Addin and it will ask if you want to remove it from the list. Click "Yes".
5. Close and re-open Excel to ensure that no error messages remain. Close Excel.
6. Re-open Excel, click on the Office Button in the upper left corner and select "Excel Options". 7. Select "Trust Center " in the windows left bar and click on "Trust Center Settings" button.
8. Select "Addins" on left bar and click on the "Go" button.
9. In the window that opens, click on the "Browse" button.
10. Navigate to the new "UncertaintyApp.xla" file. By default this is located at "C:\UncToolbox_2.8\".
11. Select the "UncertaintyApp.xla" file and click "Ok". You should be back to the Addins window. Ensure that "Analysis Toolpak", near the top of the list, is also selected along with the "Uncertainty Toolbox" addin, now found at the bottom of the list. Click "Ok".
12. Close window(s) and return to Excel, you should now see the "UncToolbox" in the Addin ribbon.
PROBLEM: Uncertainty Toolbox Addin is NOT in Menu Bar (2000-2003) or Addin Ribbon (2007) after Installation or you received an Error 1004 during installation.
Excel 2000 to 2003: If after running the install file you do not have "UncToolbox" in the menu bar do the following:
1. Click on "Tools" and select "Addins".
2. In the window that opens, click on the "Browse" button.
3. Navigate to the "UncertaintyApp.xla" file. By default this is located at C:\UncToolbox_2.8\.
4. Select the "UncertaintyApp.xla" file and click "Ok". You should be back to the Addins window. Ensure that "Analysis Toolpak", near the top of the list, is selected along with the Uncertainty Toolbox addin, now found at the bottom of the list.
5. Click "Ok" and you should now see the "UncToolbox" in the menu bar.
Excel 2007: If after running the install file you do not have "UncToolbox" in the "Addins" ribbon and the F12 key does not open the Main User Interface, do the following:
1. Click on Office Button in the upper left corner and selecting "Excel Options".
2. In the window that opens, click on "Addins" and then click the "Go" button.
3. In the window that opens, click on the "Browse" button.
3. Navigate to the "UncertaintyApp.xla" file. By default this is located at C:\UncToolbox_2.8\.
4. Select the "UncertaintyApp.xla" file and click "Ok". You should be back to the Addins window. Ensure that "Analysis Toolpak", near the top of the list, is selected along with the Uncertainty Toolbox addin, now found at the bottom of the list.
5. Click "Ok" and you should now see the "UncToolbox" in the Addin ribbon.
If problem persists call 1-810-225-8588 for assistance.
Known Template Error Issues
PROBLEM TEMPLATE: "_Summary" Template
Problem Description: The "Scheduled Review Date" cell has an error rather than a date.
Cause: The Excel "Analysis Toolpak" addin is not installed.
Excel 2000 to 2003:
1. Install the Analysis Toolpak addin as follows:.
2. Click on "Tools" and select "Addins".
3. In the window that opens, click on the checkbox next to "Analysis Toolpak", near the top of the list. Follow on-screen instructions.
4. Click "Ok" and the window will close.
5. On the summary sheet you will need to click on the green button next to Last Review date or the Submit date. The Schedule Review cell should now have a date.
Excel 2007:
1. Install the Analysis Toolpak addin as follows:.
2. Click on Office Button in the upper left corner and selecting "Excel Options".
3. In the window that opens, click on "Addins" and then click the "Go" button.
4. In the window that opens, click on the checkbox next to "Analysis Toolpak" to select it.
5. Click "Ok" and follow the on-screen instructions. Excel disk may be required.
6. On the summary sheet you will need to click on the green button next to Last Review date or the Submit date. The Schedule Review cell should now have a date.
If problem persists call 1-810-225-8588 for assistance.
Known Interface Error Issues
ERROR 1004 PROBLEM: When using a user form to link to other sheets, an error 1004 occurs.
Problem Description: The VBA linking mechanism fails. This is caused by worksheet tab names including something other than letters, numbers, and underscores as required by VBA for Excel.
Fix for all versions of Excel
1. Rename your sheet tabnames using the Main User Interface. Ensure that you have only letters, numbers and underscores ("_") in the tab name. Use "p" for decimal points and "Pct" in place of using a "%" sign.
2. Once all tabnames have been corrected, retry the form that was not working. It should now work.
If problem persists call 1-810-225-8588 for assistance.
Known Analysis Workbook Error Issues
RESOURCES ERROR PROBLEM: When re-opening an Uncertainty Toolbox analysis workbook the user get "Not enough System Resources" error.
Problem Description: This is a known problem with Excel when two pages are linked together and both pages are "zoomed" above 100% with one of these pages being the active page upon opening the workbook.
Fix for all versions of Excel
1. Resize the "_Summary" sheet in your analysis to 100%. Ensure that you save the file with this sheet as the active sheet. Save and close.
2. Re-open workbook, error should not appear.
If problem persists call 1-810-225-8588 for assistance.
ANALYSIS WORKSHEET BUTTONS NOT WORKING PROBLEM: When reopening an analysis made with an older version, some of the button are not working.
Problem Description: Templates are designed to work with the current version, analyses made with older templates may not work. While these older version are OK, if you want to have full editing functions, you will need to update the workbook as follows:
Fix for all versions of Excel
1. Open the "Main User Interface", and go to the "Create/Edit Analyses" tab. At the bottom you will see a green "Copy Workbook to NEW Templates". NOTE: If the interface asks to update tabnames, select "Yes". Then click in the "CopyWorkbook to NEW Templates". Follow the onscreen instructions. This will take all your entries and data and relocate it into new templates. You will have both workbooks when completed. Save new workbook to new location or close old workbook first and save new workbook in place of the old.
2. This is a new feature and it may still have some issues with the numerous template versions our users may be using. If you have any problems with updating older analyses, please forward a copy of the old analysis to Quametec at info@quametec.com, or call 1-810-225-8588 for assistance.
© 2009 Quametec Corporation
| 
