DJI Computer Solutions

Software Applications for Microsoft Excel

Individual Product Support

Checkbook for Excel

Handicap Manager for Excel

Golf Tracker for Excel

Project Manager for Excel

Tax Assistant for Excel

E-mail Support

Troubleshooting and Technical Support

Support Overview

Macros Disabled

Office 2007-2010 Compatibility

Office Updates

Expired Certificates

For individual product support, click one of the links on the left.

Support Overview

DJI Computer Solutions conducts comprehensive testing of all its software releases in order to minimize any bugs or other issues that might plague the end user. In fact, we usually delay our releases for several months in order to thoroughly test them.

Despite our best efforts, we occasionally discover minor issues that require minor updates to our programs. These are supplied at no cost to registered users. We encourage you to visit our web site on occasion to check for minor releases as well as major upgrades and new programs.

If you have a question or problem, check the documentation or help file that came with the program to see if you can find an answer. If you are unable to solve the problem or need additional assistance, check the product support page by clicking the appropriate link in the Product Support contents frame to the left. Also, make sure the problem you are experiencing has not been fixed with a maintenance release of the program. A description of the fixes and enhancements for each maintenance release are listed on its home page.

If you do not find an answer in the help file or on our web site, click the e-mail technical support link or you can e-mail us at support@djicomputer.com. Please be sure to provide a complete description of the problem including the exact wording of any error message, what you were doing when the error occurred, the version of Microsoft Excel that you are using and the version of Windows you are running.

On rare occasions, very aggressive spam blocking software on your ISP's mail server or on your own computer will block our response to your support request. If you do not receive a response within 24 hours, please check your spam folder and spam settings to insure that our e-mail was not blocked. Also, please send us an e-mail reminder so that we can resend the message from a different e-mail address. Please be assured that we do not use bulk e-mailing or participate in any type of spamming.

It is our policy to respond to any request within 24 hours whenever possible and usually much sooner. It is our mission to provide both quality software and quality service.

Thank you for your support,

Dan Ireland

Macros Disabled

Excel 2007 - 2010

If your Excel macro security is set to high and you are using Excel 2007 or Excel 2010 you will see a message along the upper portion of the Excel windows that states "Security Warning - Macros have been disabled" with an Options button to the right.

In order to enjoy all the features that our Excel applications provide, you will need to enable macros. To enable the macros in Excel 2007 and eliminate future warning for files published by DJI Computer Solutions, simply click the Options button and select the "Trust all documents from this publisher" option and click OK.

If you do not have the options shown in the dialog box above, see the Office 2007-2010 Compatibility section below for additional information on how to enable the program macros.

Excel 2003 or Earlier

If you are using Excel 2003 or earlier you will receive a message stating that the file "contains macros by DJI Computer Solutions" or "The macros in this project are disabled."

Simply check the "Always trust macros from this publisher" check box and click the Enable Macros button (see above).

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.

Office 2007-2010 Compatibility

All of our software for Microsoft Excel is compatible with Excel 2007-10. However, with its new Ribbon user interface, it presents a different look and feel and places the custom toolbars and menus in a different location. Excel 2007-10 also has a new Open XML file format which provides better security and response and will ultimately allow better interoperability with other applications. Here are a few tips for using our software with Excel 2007-10.

The custom toolbars and menus used by Checkbook for Excel, Tax Assistant for Excel, Project Manager for Excel, Scheduler for Excel and Excellerator now appear on the Add-Ins ribbon tab at the top of the screen. Just click on this tab to access the custom toolbars and menus.
Excel 2007-10 continues to support the Excel 97-2003 .xls file format. All of our software will continue to utilize this file format when initially installed in order to maintain backward compatibility with older versions of Excel. You can continue to use this file format with our software or you can save under the new Open XML file formats. If you decide to utilize one of the new file formats, see the bullet points below for additional information on macro security and enabling macros in the new file formats. Also, be sure to utilize the macro enabled (.xlsm) or binary (.xlsb) file formats. Saving in the non-macro Excel workbook (.xlsx) format will remove all the macros and destroy the program functionality.
Microsoft is committed to providing a more secure computing experience and has made changes to the Excel macro security settings. Since all of our Excel applications are protected and digitally signed to secure and protect them from tampering, Excel 2007-10 requires the presence of anti-virus software that complies with the new Microsoft Anti-virus API or it automatically disables the program macros when files are saved in the new file formats. If you are using Windows Vista or Windows 7, upgrading your anti-virus program to the latest version will likely solve the problem. However, if you are using Windows XP, there are no Anti-virus programs that are compliant with the Microsoft Anti-virus API. If you are using Windows XP you may need to install a minor registry tweak to overcome the problem. If you receive a Security Warning in the notification bar at the top of the screen that macros have been disabled (as shown below), click the Options button to display the Security Alert dialog box.

If the security alert reads as shown in the dialog box below, simply select the "Trust all documents from this publisher" option and click OK to keep from receiving the warning when using our programs in the future. Our digital signature insures that the programs are virus free. You can also select the "Enable this content" option but you'll continue to receive the warning each time you use our programs.

However, if the security alert reads as shown in the following dialog box, you will need to add the registry value described in the next section in order to utilize the new file formats.

If you receive the warning above when utilizing the new Excel 2007-10 file formats, download the zipped registry file to your computer using the following link, open the zipped folder and copy the registry file to your desktop or another location on your computer. Once you have saved it on your computer, install the registry key by right-clicking on the registry file and selecting Merge from the shortcut menu. Just click Yes when asked if you want to add the information to the registry. Be sure to backup your registry before installing the new registry value. This registry change is only necessary under certain circumstances if you are using Windows XP with Excel 2007-10 and saving protected files in the new Excel 2007-10 Open XML file formats. It provides no benefit unless you are having trouble enabling macros while using our software as described above.

Download Excel Encrypted File Scan Registry Change

Or you can make the registry change manually by following these instructions to add the new registry value to allow the macros to run.

Click the Start Menu then select Run. Type "regedit" (without the quotation marks) into the Run dialog box and click OK.
Select My Computer at the top of the Registry tree in the left pane of the Registry Editor.
Then backup the registry by selecting File - Export from the Registry Editor menu, entering a name for the registry backup file and clicking OK.
Navigate the the following registry key: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security
With the "Security" key highlighted, select Edit - New - DWORD Value from the Registry Editor menu.
Type "ExcelBypassEncryptedMacroScan" (without the quotation marks) for the new value name and hit enter
Then double-click on the newly added value and change the DWORD Value from 0 to 1 and then click OK.
Exit the Registry Editor and the exit and restart Excel 2007-10 for the change to take affect.

This registry change does not compromise the Excel 2007-10 security in any way. It only allows macros to run in protected files that are saved in the new Excel 2007-10 Open XML file format. (If you are using Windows Vista or Windows 7 and have anti-virus software that complies with the new Microsoft Anti-virus API, you should not need this registry modification.) You can modify your macro security settings in Excel 2007-10 by clicking on the Excel 2007 Office Button or the Excel 2010 File tab in the upper left hand corner of the screen and clicking the Excel Options button. Then click the Trust Center button in the left pane and click the Trust Center Settings... button and click the Macro Settings button in the left pane. In the Macro Settings section, we recommend using either the "Disable all macros with notification" or the "Disable all macros except digitally signed macros" option.

To save your files in the new Excel 2007-10 Open XML format, click the Office Button (Excel 2007) or the File tab (Excel 2010) in the upper left hand corner of the screen, select Save As and choose the Excel Macro Enabled Workbook file format.

Important Office Updates

Be sure to install the latest service pack and patches for your version of Microsoft Excel. It's easy to do and will make all your Office applications more stable, secure and error free. Just select Help - Check for Updates from the Excel menu or go to http://office.microsoft.com and click the Check for Updates link.

The earlier releases of each version of Microsoft Excel have a number of bugs that can affect the functionality of the underlying Visual Basic for Applications (VBA) that makes all of our programs run. If you get a cryptic error message when using one of our programs that is not readily explained on the product support page, installing the latest service pack and patches for your Excel version will often solve the problem.

Important Support Notice - Expired Certificates

The old digital code signing certificate that we use to secure our software expired on January 4, 2011 in some of our applications. In order to insure that our software is completely safe, we sign all of our applications with a digital code signing certificate. This insures that it came directly from DJI Computer Solutions and has not been tampered with. If your Excel macro security setting is set too high when the digital signature expires, it will also disable the macros and effectively prevent you from running the program. You will either need to modify your Excel macro security settings as described below or download the latest free maintenance release of our software using one of the links on our home page. The latest releases of all our programs contain a new time stamped digital signature that will never expire.

Adjusting your Excel macro security settings will allow you to run your existing version of the program. To globally enable macros in Excel 2003 or earlier, select Tools-Macro-Security and choose the Medium or Low security option. To globally enable macros in Excel 2007, click the Office button and then click the "Excel Options" button to display the Excel Options dialog box. Then click the Trust Center link on the left side of the dialog box and then the Trust Center Settings button. In the Trust Center dialog box, click the Macro Settings link on the left side and then choose the "Disable all macros with notification" option or the "Enable all macros ..." option. Then exit and restart Excel to invoke the new settings. If you are still not able to enable the macros after you change these settings, see the "Office 2007-2010 Compatibility" section for more details. Read the information carefully as it may be necessary to install a registry tweak to enable macros in the new Excel 2007-10 file format.

In order to obtain the latest certificate, just download the program again using one of the links on our home page. You can use the "Import Data from a Previous Version" function to import your existing data. You may also need to re-enter your registration number into the new program. If you have forgotten or misplaced it, just e-mail us with enough information to identify yourself and we'll send you the registration number again. Unless your product is very old, this will be a free upgrade.

Our current certificate expired in early 2011 but all of our applications have been updated with a new time stamped version that will never expire. The application updates are free to all registered users of the current releases and can be downloaded directly from our web site. We apologize for any inconvenience but we believe it is important to do our part in providing a safe computing environment for our users. See our Security pages for more details.