Sean Connery has ditched plans for his long-awaited autobiography, returning a staggering €1.4m advance to the publishing giants Harper Collins.