Excel 2003

If I change a number that is part of a group that is in a formula (ex: two
numbers being multiplied with a total at the bottom) for some reason the
total is not updating unless I double click on it.

This problem is only with a few a my worksheets.

Thanks