"I don't think he has any public future.”

Andrew Lownie has written the biography of the Prince, which is called Entitled: The Rise And Fall Of The House Of York.

Lownie opened up about what the Duke of York has been hurt most by in recent years.

"I don't think he has any public future,” Lownie said.

“I would say his private future is pretty limited too. I mean, he lives in Royal Lodge [on the Windsor Estate], he plays golf, watches TV, and presumably sees his grandchildren.

“He's living the life of a retired man," he concluded.

Lownie says a member of royal staff told him that Andrew is hurt by his “lack of royal status”.

 "That's what really sort of gave him his whole sense of identity. And that's, you know, it's not being able to put on his uniforms and strut around and being self-important."

The reports come after a YouGov poll that showed Andrew is the least favourable member of the royal family, by some way.

The poll found 87 per cent of the public have a negative view of him. Only 5 per cent of people have a favourable view of the Duke of York.