Site Mitigation & Restoration Program

We protect and maintain California’s land and places
by setting strict standards for land restoration and cleanup

Human and Ecological Risk Office

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 2.3 will not run is that it was not started according to this strict procedure.

  1. Open Microsoft Excel®;
  2. Select Open from the File drop-down menu;
  3. Locate the subdirectory that contains the 6 files needed to run CalTOX 2.3 in the Look in: drop-down menu at the top of the Open window;
  4. Open the RunCal.xls file.

 

Note that 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.

Page last updated April 15, 2019.