Off-shell no-go theorems for higher dimensional supersymmetries and supergravities