| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I refresh cells after changing the format? | Excel Discussion (Misc queries) | |||
| Shortcut to refresh format cells | Excel Worksheet Functions | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
| refresh all cells in column | Excel Worksheet Functions | |||
Linear Mode
