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 Golf Tracker 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 or OK button. If you are still having problems enabling macros or would like additional information, click this link to our Security page.
Golf Tracker for Excel functions more like a standalone program than a typical spreadsheet in that you do not enter data directly into the worksheets. The worksheets are all protected by design to prevent accidental changes that may keep the program from functioning properly. However, there is no need to unprotect any of the sheets as you can add, edit or delete any of the data in the program using one the functions in the program. (There is one exceptions to this rule on the "Data" sheet where you can directly edit the non-calculated data on the sheet.)
Anything can be added, deleted or edited using the correct program tool or function. Most of these functions can be accessed from the main Golf Tracker sheet. Just click on the button for the function you want to use. You can search the program help file index for what you want to do. All of our programs have context sensitive help files that contain an overview section that will get you started with each program. Anytime you need help with something just access the context sensitive help in the dialog box you are using for detailed instructions. If you are having trouble accessing the help file see the "Instructions for Accessing the Program Help Files" on our main Support page.
The blank scorecards and all the scorecards you create are stored as Excel templates and are lcoated in the \Microsoft\Templates\Golf Courses folder under your AppData folder in you Windows user profile. The location will vary slight depending on your version of Windows and the folder is normally hidden. However, the location should appear automatically when you click the "Enter Score" or "New Scorecard" button. If you are using Excel 2002 (XP), the "New Workbook Task Pane" is displayed when you click the "Enter Score" button. Just select the General Template option and the New File dialog box will appear. Select the Golf Courses tab and all of your golf course scorecard file templates will be listed. This behavior only affects the initial release of Excel 2002 (XP) and can be corrected by installing Service Pack 1 for Microsoft Office XP or upgrading to a more recent version of Excel. In more recent versions of Excel, the New File dialog box with all your golf courses is displayed by default.
The blank scorecards and all the scorecards you create are stored as Excel templates and are lcoated in the \Microsoft\Templates\Golf Courses folder under your AppData folder in you Windows user profile. The location will vary slight depending on your version of Windows and the folder is normally hidden. In Windows 7 and later the folder will be located at: "C:\Users\[Your User Name]\AppData\Roaming\Microsoft\Templates\Golf Courses". Simply backup this entire folder and all your score cards will be saved.
The AppData folder will be hidden under your profile so to view it simply open Windows File Explorer and on the View tab check the "Hidden Items" checkbox. Then you will be able to navigate to the folder in File Explorer.
You can easily correct the data on both the scorecard and in the main program. On the scorecard you can simply type over the incorrect data. If you made a mistake on a Fairway Hit or Green in Regulation use the small check mark buttons on the left side of the appropriate row to toggle the check mark in the row while the cell cursor is in the cell you want to change. After you make the change all the formulas will be recalculated automatically to reflect the change.
To correct the mistake in the data that was transferred to the main Golf Tracker for Excel file simply go to the Data sheet in that file and find the row that contains the data for the round you want to change. Then just type over the incorrect data. Once again all the formulas will be recalculated automatically after you make the change. You will need to run any reports again to show the corrected data using the Prepare Reports function.