You could make sure that Tools?OptionsCalculation is set to Automatic.

To refresh you can hit F9 or CTRL + F9


Gord Dibben MS Excel MVP

On Thu, 30 Mar 2006 15:52:17 -0600, craftcenter
wrote:


Can I create a button to refresh all the formulas. The IF statements
don't update when new information is input.