Why did Sir Ian McKellen turn down the role of Dumbledore?

Sir Ian McKellen revealed the surprising reason why he turned down the role of Dumbledore in Harry Potter as Sir Michael Gambon took it on instead.