When i copy(drag) a SUM: formula down from another cell, the values in the destination cells do not update yet the formula shown in the viewing bar that it should. However, when i F2 to look at the formula, they suddenly update when i leave the cell in question. Have i turned something off unwittingly?
Hi,Originally Posted by Leroyloverod
Look in Tools, Options, Calculation and set to Automatic.
hth
---
Si fractum non sit, noli id reficere.
Thanks very much for that.
np - unfortunately I don't know which 'accident' turns it off, but thanks for your response.
---
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks