Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell with formula is not automatically updating - Excel Office 200
I have an excel file, one column has 200 cells with same formula. I have
been using it for a year, data automatically updates. However, recently, after the files got changed hands from one pc to another, the cells in that column does not update anymore. I have to press F2, enter for each cell in order to get each cell refreshed. 1. Does anyone has any idea what is the common cause for such problem, i.e. failing to auto refresh? 2. What could be done to enable the automatic refresh without having to press F2 for each cell everytime? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Since updating Office 2003 to 2007 Excel formulas do not work? | Excel Discussion (Misc queries) | |||
automatically updating a column in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel not automatically updating cells | Excel Discussion (Misc queries) | |||
Automatically updating a formula | Excel Worksheet Functions | |||
Excel formulas are not automatically updating | Excel Discussion (Misc queries) |