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.
- Open Microsoft Excel®;
- Select Open from the File drop-down menu;
- 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;
- 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.
HERO Quick Links
HERO Quarterly Updates
Whats New at HERO
- HERO HHRA Note 4. May 14, 2019. Guidance for Screening Level Human Health Risk Assessments
- HERO HHRA Note 1 April 2019. DTSC-Recommended Default Exposure Factors
- HERO HHRA Note 3. April 2019. DTSC Recommended Screening Levels
- HERO HHRA Note 10 February 2019. Toxicity Criteria
- HERO HHRA Note 8. Recommendations for Evaluating Polychlorinated Biphenyls (PCBs)
- HERO HHRA Note 6. California Arsenic Bioavailability Method
- Rulemaking Notice: Toxicity Criteria Selection for Risk Assessments, Screening Levels, and Remediation Goals
- Review: Risk Assessment Implications of Variation in Susceptibility to Perchloroethylene Due to Genetic Diversity, Ethnicity, Age, Gender, Diet and Pharmaceuticals
- HERO HHRA Note 2. Soil Remedial Goals for Dioxins and Dioxin-like Compounds, April 2017