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?