I have a very very large excel worksheet (Using Excel 2007) and with all of the formulas trying to refresh every time i press enter it is lagging down the computer and taking all of the resources (250MB of ram it was sucking up)

So again, the question is how can I stop Excel 2007 from refreshing the cells containing formulas every time i enter data into a new cell.

On a side note, Which button on the keyboard is the manual cell refresh button as i'll have to use that at times


-Thanks in advance