Thank you so much Pete. It worked. You are a life saver! :)

"Pete" wrote:

Go to Tools | Options | Calculation (tab) and check Automatic
recalculation rather than Manual. When in the manual mode you can press
F9 to get the sheet to re-calculate.

Hope this helps.

Pete