Check your settings when it does not work. In the main menu go t
Tools-Options and then in the Options Window go to the “Calculation
tab. The top of that tab is where you set the calculation of formula
and such to “Automatic” if you so choose. If it is already set t
automatic and is still not working I’d look at the formulas themselves

--
Message posted from http://www.ExcelForum.com