Calculation in cell not updating - Totally baffled!
Until yesterday, calculations in Cell A3 were updating just fine from A2 divided A1 when I would change the number in one of these two cells. Now it does not! The change only shows once I save the file, close it and reopen it.
Totally baffled - why isn't the final calculation not updating automatically?
go into the menu File> options.
on the formula tab the setting for calculation has been changed from "automatic" to "manual (recalculate on save)".
Change this option back and it will be fine.
2+2=5 for extremely large values of 2.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks