Starting with AACW 1.09 or NCP 1.03, all abilities have a new parameter, (and thus a new column in the XLS file): Effectivity.
The default, NULL or 0, changes nothing.
Set to 1, it means the ability will only be effective if it is born by an activated land leader.
Set to -1, it means the ability will only be effective if it is born by an non-activated land leader.
Why restrict to land leaders? Because Naval leaders are always activated, this is a core rule.