diff --git a/erpnext/crm/utils.py b/erpnext/crm/utils.py
index a838f16cbe7e07c82e66e3f557d0d647dd350e24..c4e988c220721408f48093a9cced820227c4870f 100644
--- a/erpnext/crm/utils.py
+++ b/erpnext/crm/utils.py
@@ -94,9 +94,7 @@ def get_linked_prospect(reference_doctype, reference_name):
 			"Opportunity", reference_name, ["opportunity_from", "party_name"]
 		)
 		if opportunity_from == "Lead":
-			prospect = frappe.db.get_value(
-				"Prospect Opportunity", {"opportunity": reference_name}, "parent"
-			)
+			prospect = frappe.db.get_value("Prospect Opportunity", {"opportunity": reference_name}, "parent")
 		if opportunity_from == "Prospect":
 			prospect = party_name
 
@@ -171,7 +169,7 @@ def get_open_events(ref_doctype, ref_docname):
 		.where(
 			(event_link.reference_doctype == ref_doctype)
 			& (event_link.reference_docname == ref_docname)
-			& (event.status == "Open")
+			& (event.status.notin(("Closed", "Cancelled", "Completed")))
 		)
 	)
 	data = query.run(as_dict=True)