The man in charge of Tesco's US venture has reportedly ruled himself out of contention to succeed Sir Terry Leahy as the company's chief executive.