DJI Computer Solutions
Software Applications for Microsoft Excel
Individual Product Support
Handicap Manager for Excel Support PageOur online technical support provides answers to common questions and work arounds for common problems. If you do not find the information you need, please use our e-mail support option.
When I exit or close Handicap Manager for Excel, I am prompted for a password but I don't know the password and the password dialog box won't close and I have to invoke the Windows Task Manager to exit Excel.
This problem is occurs with a small number of users and is caused by poorly written Excel COM add-ins and has most often been associated with the Adobe Acrobat or Adobe PDF Maker add-in. Many programs install Microsoft Office add-ins without your knowledge It is recommended that you disable any Excel COM add-ins that are running. If that solves the problem, you can re-enable the disabled add-ins one at a time until you find the one causing the problem. A newer version of the add-in or program may be available that resolves the issue so check with the software company that created the add-in.
You can view the installed add-ins in Excel by clicking the Office orb or File Tab, then Excel Options, Add-ins, then select COM Add-ins in the Manage drop down list and click the Go button). (In Excel 97-2003 select Tools – Add-ins on the Excel Menu.) You can see which ones are active and de-activate them from this screen if you like. The problem seems to most evident in Excel 2010.
If you are not able to resolve the issue by disabling the offending add-in, we can specifically modify your Handicap Manager for Excel file to fix the problem. Just attach your Handicap Manager for Excel file to an e-mail and send it to firstname.lastname@example.org. We'll make the necessary modifications and e-mail your file back to you within 24 hours.
When I start Handicap Manager for Excel, I receive a message stating that "The macros in this project are disabled."
In order to enjoy all the features that our Excel applications provide, it is necessary to have macros enabled in Excel. You may receive a security warning that the file "contains macros by DJI Computer Solutions." In order for Handicap Manager for Excel to do its job, you will need to enable the macros it contains. Rest assured that the macros are safe and perform only basic Excel functions. They have been digitally signed and protected to insure that they were created by DJI Computer Solutions. To enable the macros and eliminate future warning for files published by DJI Computer Solutions, check the "Always trust macros from this publisher" check box and click the Enable Macros button. If you are still having problems enabling macros or would like additional information, click this link to our Security page.
When calculating handicaps, I get a "Run-time error 1004; Application-defined or object-defined error" message.
This problem is caused by the presence of quotation marks in any golfer's name on the Golfer's sheet. Excel misinterprets the quotation marks when querying the golfer's scores in order to calculate his or her handicap index. To correct the problem, go to the Golfers sheet and change the golfer's name to remove any quotation marks. Then go to the Scores sheet and Uncombined Nines sheet and change the golfer's name on any scores that are listed for that golfer. You can use the copy and paste function to make it easier.
This problem is caused when a golfer's name is manually changed on the Golfers sheet but not changed on the Scores and Uncombined Nines sheets. Excel uses each golfers name exactly as it is entered on the Golfers sheet to match scores to that golfer. If the name is changed on the Golfers sheet but not on the Scores sheet, Excel does not identify the score as belonging to that golfer. To correct the problem, go to the Scores sheet and Uncombined Nines sheet and change the golfer's name on any scores that are listed for that golfer to match his or her name exactly as it appears on the Golfers sheet. You can use the copy and paste function to make it easier.
When entering scores I get a "run-time error 13 - type mismatch" or "run-time error 16 - expression too complex".
This problem occurred under certain circumstances when the program automatically combined nine hole scores. The issue was present in version 3.0, 3.0a & 3.0b. It was corrected with version 3.0d or higher.
When Preparing Scoring Reports, I get a "Run-time error 1004; Unable to set the RowHeight property of the Range class.
This problem was due to an obscure bug in Excel 97 and did not occur in more recent versions of Excel. The issue was corrected with the release of Version 3.6c or higher. Download and install the latest version of the program if you are using Excel 97 and run into this problem.
Sometimes the Score Entry dialog box does not update the course handicap when switching golfers and the incorrect course handicap and net score is entered on the Scores sheet.
This occurred when switching golfers but not golf courses when entering scores and would sometimes result in an incorrect course handicap and net score being entered on the Scores sheet. It did not affect handicap calculations. The issue was present in version 3.0, 3.0a & 3.0b. It was corrected with version 3.0d or higher.
When I enter a new golfer, the information in the last three columns of the Golfers sheet becomes displaced. How can I correct this problem.
This problem occurred in version 3.0 and has been corrected with version 3.0a and higher. You can work around the problem in your existing version by using the "Prepare Golfer Reports" function. This will automatically correct the problem. To check the version number of your existing program, click on the Golf Course graphic on the Main Menu sheet to display the Welcome dialog. The version number is displayed in the title bar. If no version number is listed, you are not using the latest version.
I receive a run-time error 1004 "Unable to get the Match property of the WorksheetFunction Class" when I try to enter a new score or enter a new golfer or select a different golfer. How can I correct this problem?
This problem is caused when the golfer's home course listed on the Golfers sheet is not listed on the Golf Courses sheet. It is important that each golfer's home course have an exact match on the Golf Courses sheet. This usually occurs when the name of the home course is typed directly into the Golfers sheet and a typo is made. The problem has been corrected with version 3.0b and higher. You can work around the problem in your existing version by making sure that each golfer's home course has an exact match on the Golf Courses sheet. To check the version number of your existing program, click on the Golf Course graphic on the Main Menu sheet to display the Welcome dialog. The version number is displayed in the title bar. If no version number is listed, you are not using the latest version.
When I select a different golfer, his home course is incorrect and the first golf course on the Golf Courses sheet is displayed instead of the correct course. How can I correct this problem?
This problem is caused when the golfer's home course listed on the Golfers sheet is not listed on the Golf Courses sheet. Since Handicap Manager does not recognize the golf course, it substitutes the first golf course on the Golf Courses sheet. This usually occurs when the name of the home course is typed directly into the Golfers sheet and a typo is made. To avoid the problem, always use the buttons on the Main Menu sheet to initiate data entry instead of typing information directly into the various sheets. You can correct the problem by making sure that each golfer's home course has an exact match on the Golf Courses sheet.
After using the "Delete Old Scores" function on the Scores sheet, the information in the last three columns (Score, Course Handicap and Net Score) has shifted to different rows and is no longer in the correct location.
This is a confirmed bug with version 2.0, 2.1 and 2.1a and has been fixed with version 2.1b which is currently available for download on the Handicap Manager main page. Once you have used the "Delete Old Scores" function, the data in the Score, Course Handicap and Net Score columns will be shifted to different rows and will no longer correspond to the correct score entry. None of this information is used for the handicap calculation so the best solution is to simply delete all the data in these three columns. When deleting the data, be sure to extend your deletion well beyond the last row of your existing data as there may be data from the last three rows stranded lower in the worksheet. Be sure not to delete the column headings.
You may be able to copy the data in the last three columns to the correct location farther up in the worksheet but this will be a difficult process if you are managing a large number of golfers. Some of the data remaining in the last three rows will be left over from score entries that were deleted, but if you can determine which data belongs to which golfer, you can start with the most recent post and just copy the data for the number of scores remaining for each golfer. Even if you copy it to the wrong location, this data is not used for the handicap calculation and will not affect the functionality of the program.
The first page of handicap cards print correctly but the information shifts down the page on subsequent pages. What adjustments can I make to fix the problem?
With the wide variety of printers and print drivers on the market, adjustments are necessary to make the cards print correctly on some printers. This problem can often be fixed by adjusting the page margins as follows:
Many inkjet printers do not support bottom margins as low as 0.5 inches. If you have already adjusted the bottom margin to zero and the page break is still too high, you will need to adjust the paper size using your printer driver as follows.
The information on the handicap cards does not print in the correct position even on the first page. What adjustments can I make to fix the problem?
Make sure you are using Avery Inkjet (8371) or Laser (5371) business cards or equivalent. Business card sheets that are not this exact specification will not work correctly.
If the card rows are spaced correctly but are all shifted up, down, left or right, you will need to adjust the margins as follows:
If the cards are not spaced correctly, i.e., the first row is correct but rows near the bottom are too far up or down, you will need to adjust the row heights in the Handicap Card sheet as follows:
I downloaded a new version of Handicap Manager for Excel. How do I transfer the data from the old version to the new version?
Make sure that you have downloaded the most recent version from the Handicap Manager for Excel home page.
Your data from any previous version of Handicap Manager for Excel can be easily imported into the new version using the automatic import feature. Click on the golf course picture at the bottom of the Main Menu sheet to display the "Welcome" dialog box. Then click the "Import Data from a Previous Version" bottom and follow the directions on the screen carefully. All of your data will be imported in just a few seconds.
The imported data will overwrite any existing data so make sure you are starting with a blank copy of the Handicap Manager workbook.
When I try to import my data from a previous version, I get the following error message even though I know I'm opening the correct file: "The file that you opened to upgrade from was not a Handicap Manager for Excel file. The upgrade was not successful."
In order for the old version to be recognized, it must be saved with the "Main Menu" sheet active. Open the old version, make the "Main Menu" sheet active, save and close the file, and then try the Import again from the new version. This problem will be fixed in a future release. Also, make sure you are opening the correct Handicap Maanger for Excel file.
The dates are showing as dollar signs because the system short date format on your computer has been modified to use a four digit year and the longer dates no longer fit in the cells. There was an incorrect rumor that this was necessary to make Windows Y2K compliant and many Y2K programs made this modification automatically. This problem was fixed with a maintenance release of Handicap Manger (version 1.8). Version 2 is available for download on the Handicap Manager home page. You can also fix the problem by changing the system short date format back to a two digit year if you don't want to download the free upgrade.
The "Scores Posted" number never seems correct. It is always less than the number of scores the golfer has posted.
If you are using the USGA Handicap Method, the "Scores Posted" should be equal to the number of scores previously posted during the handicap revision period set by the "Previous" and "Current" handicap calculation dates. For example, if the previous handicap calculation date is 8/1/2001 and the current handicap calculation date is 8/14/2001, the "Scores Posted" will be the total number of scores posted from 8/1/2001 through 8/14/2001. This number is meant to show how much a golfer has played recently.
You can define the scores posted calculation in the most recent versions of the program. Just hit the F1 key while the Handicap Calculation dialog box is displayed to bring up the help information and it will explain this topic in detail.
Handicap Manager for Excel can be used to calculate either 18 or 9 hole handicaps. However, you cannot enter both 9 hole and 18 hole scores into the same file. If you want to calculate nine hole handicaps, you must enter all nine hole scores, splitting any 18 hole scores into two 9 hole scores. If you want to calculate eighteen hole handicaps, you must enter all 18 hole scores, combining any 9 hole scores to make 18 hole scores.
If you wish to track both 9 and 18 hole handicaps, save separate copies of the Handicap Manager workbook with different names, designating one for 9 hole handicaps and one for 18 hole handicaps.
Sometimes a score posted from a round played on a golfer's home course gets marked as an away score. How can I correct this problem?
There was an obscure bug in earlier versions of Handicap Manager for Excel that caused this problem on some machines running Excel 97 or Excel 2000. This problem has been corrected in versions 1.9 and higher. You can download the latest version from our Handicap Manager Home Page. To see instructions for importing your data from a previous version to the new version, click the previous link.
The context sensitive help is not displayed when I hit F1 key or use the help tool in any of the Handicap Manager custom dialog boxes.
The context sensitive help feature in the custom dialog boxes is not supported in Excel 97. This feature is only available to users of Excel 2000 or higher. To access the help file, click on the "Help" button on the Main Menu sheet. You can then use the Contents or Index buttons to find the desired help topic. Keep the help file minimized on the Windows Task Bar so that it is available as needed while you are using the program.
Excel crashes frequently when I'm using Handicap Manager for Excel with an error message that Excel has caused an error in OLEAUT32.DLL (or some other file). How can I correct this problem?
This problem is caused by a bug in Office/Excel 97 and you can correct the problem by downloading the latest patches for Office 97. The bug is due to a program installing a newer version of the Office Automation files (including OLEAUT32.DLL) that is not completely compatible with Excel 97. You can determine which Excel patches you need to apply by reading the Microsoft Knowledgebase article Q232652 at: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q232652
If you are experiencing frequent crashes in Excel 2000 or Excel 2002/XP, use the Detect and Repair option on the Help menu to verify that your Excel installation has not been damaged and the Office automation features are still intact. You can also go to Microsoft's Office web site and use the Office Update feature to install the latest patches. When installing the latest patches, Excel's macro security policy will be modified without your permission. Click this link to our Virus Protection page for more details.
I receive a run-time error when using the Publish function to publish a web page from the Handicap Manager data.
Excel 97 doesn't support the VBA calls for the automation of the web publishing feature. (All the other program features work properly in Excel 97.) However, the process is very simple and you can still save a copy of your data in HTML format from Excel 97, which is what Handicap Manager does with the publishing feature. We simply automate the process to simplify the range selection.
To publish your reports in HTML with Excel 97, follow these directions.
1) Go to the sheet you want to publish and select the range you want to included in your HTML file.
2) Once you have the range selected, choose File - Save as HTML from the Excel menu.
3) The HTML wizard will guide you through the process. You can just accept the defaults and click the Next button until finished.
Copyright © 2000-2012 DJI Computer Solutions. All rights reserved.