When I copy and paste a formula to a new cell, the calculation shows the same result that the formula calculated in the copied cell. If I close and re-open the sheet, the formulas deliver the correct answer.
When I copy and paste a formula to a new cell, the calculation shows the same result that the formula calculated in the copied cell. If I close and re-open the sheet, the formulas deliver the correct answer.
What if you press F9
If the formula updates you are in manual calculation mode.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks