We found out both times. The first time it wasn't that much of a secret. Family knew mostly, etc.
The second time around we decided we could tell 2 ( or less) people that we trust each and then no one else would know until the birth. Our trusted people did their jobs well and didn't tell anyone nor let on they knew.

Good luck with whatever you decide.