HERO Quarterly Updates
Whats New at HERO
Risk Assessment News
Troubleshooting CalTOX Problems
Problem: I get the error message "Cannot find DatCal." followed by an arcane macro error.
Cause: The most common reason that CalTOX will not run is that it was not started according to this strict procedure.
- Open Microsoft Excel®;
- Select Open from the File drop-down menu;
- Locate the subdirectory that contains the 6 files needed to run CalTOX in the Look in: drop-down menu at the top of the Open window;
- Open the RunCal.xls file.
RunCal cannot be started from Windows Explorer or from the bottom of the Files drop-down menu (if it was one of the last files used in Excel® it will appear here). The reason these convenient shortcuts cannot be used is that Excel® identifies a default directory for every "session". The best way to ensure that Excel® has set the subdirectory with the six CalTOX files as the default directory is by the four-step process described above.