New limits on the population of normal and millisecond pulsars in the Large and Small Magellanic Clouds