Edema Water Retention & Weight Gain in Menopause. If you can get through perimenopause and menopause without gaining any weight, you are the rare and fortunate woman. Fluctuating hormones and water weight retention are the bane of middle-aged women. During your reproductive years, progesterone is the hormone manufactured when you ovulate.