Be sure you have set calculation to automatic.
--
Gary''s Student - gsnu200765


"Yuanhang" wrote:

In Excel 2007, everytime I copy and paste new data to the spreadsheet, it
doesn't refresh those cells which are linked to the data that I updated. So I
have to doubleclick each cell and press F2 to refresh the result. It's not
like that in Excel 2003.