Comprehensive Preventive Health and Promotion Act of 1997 - Mandates establishment and annual revision of a schedule of recommended preventive health care services.

Requires each carrier and employer health benefit plan to include coverage for those services. Amends the Internal Revenue Code to impose a tax on the failure of a carrier or an employer plan to comply.

Amends title XVIII (Medicare) of the Social Security Act to include those services in the definition of "medical and other health services."

Amends title XIX (Medicaid) of the Social Security Act to mandate Medicaid coverage of the services and, in some circumstances, for: (1) home and community care for functionally disabled elderly individuals; and (2) community supported living arrangements services.

Amends Federal law relating to health care services for veterans to include the services under this Act in the definition of "medical services." Regulates provision of the preventive services on an outpatient basis.

Amends Federal law relating to health insurance for Federal employees to add the services to the list of benefits which may be provided under service or indemnity benefit plans.

Amends Federal law relating to medical care for dependents of members of the uniformed services to add coverage of the preventive services.

Mandates: (1) grants to counties for a project to demonstrate the effectiveness of providing those services to improve and reduce health costs; (2) dissemination of information on the benefits of practicing preventive care; (3) grants to employers to establish and conduct on-site workshops on health care promotion for employees; and (4) a program of on-site workshops on health care promotion for Federal employees.