A certain man had great grandchildren, yet none of his grandchildren had any children.
How come?

The question talks about great grandchildren, not great-grandchildren. The hyphen makes all the difference. The grandchildren were great, top, brilliant and awesome, but childless.