If you mean that the calculated values are not updating when the referenced data changes....try this
Press the [F9] key....to force the workbook to recalculate.
If the correct values display, then you have Calculation set to: Manual
From the Excel Main Menu:
<tools><options><calculation tab>
AUTOMATIC should be checked
Does that help?
Bookmarks