ExcelBanter - Refresh Cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Refresh Cells (https://www.excelbanter.com/excel-discussion-misc-queries/174103-refresh-cells.html)

Yuanhang

Refresh Cells

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.

Gary''s Student

Refresh Cells

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.

All times are GMT +1. The time now is 09:45 PM.