The legendary thespian was offered the role of the iconic Hogwarts headmaster - but decided he 'couldn't do it'.