Assuming you don't want to generate a different number every time (which it seems like you don't) once you've generated them, copy them, and then paste values. See: http://office.microsoft.com/en-gb/excel-help/copy-cell-values-not-formulas-HA010244903.aspx
Hi, it could be a few things
1.Airlock ,Did you run a bath or use a large amount of water just b4 this occurred?
2.Solenoid switch, if this is 'gone' water will not flow.
3.Filter, Was there a gradual drop in flow rate over time?
4.Filter, Large blockage has got into pipework,(rare) such as...