you need to force a recalculation just hit F9, or close open the workbook