Had Connery accepted the Gandalf role, his 15 per cent of those takings would have been worth $US450 million.
Instead he accepted a part in the critically panned film The League of Extraordinary Gentlemen, which lost $US12 million at the box office.
He has since retired from acting.
Connery has never confirmed he turned down the Gandalf role, but has admitted he never understood the script, saying: "I read the book. I read the script. I saw the movie. I still don't understand it. Ian McKellen, I believe, is marvellous in it."
McKellen is set to reprise his role as Gandalf in The Hobbit: An Unexpected Journey, which will premiere at Wellington's Embassy Theatre on November 28.
Worst movie mistakes
* Will Smith turned down the role of Neo in The Matrix.
* Hugh Jackman reportedly refused the part of James Bond in a reboot of the franchise. It went to Daniel Craig, who is now the highest paid Bond in history.
* Matt Damon and Jake Gyllenhaal were both reported to have turned down the lead role in James Cameron's Avatar. It went on to become the highest grossing movie of all time.
* Mel Gibson turned down the part of Maximus in Gladiator. It netted Russell Crowe an Oscar for best actor.
* Jack Nicholson turned down the iconic role of Michael Corleone in The Godfather, saying "At the time I believed Indians should play roles written for Indians and Italians should do the same."
- Herald Online