I have a computer that some workbooks have this problem, but not new ones. The problem is that cells on the effected workbooks that contain formulas will not update with the proper value until I save the workbook.
To demonstrate what I mean, if you open a new workbook and type in values for a1 and a2, then have the formula =a1+a2 in cell a3, it will automatically update as you change the values in a1 or a2. My issue is that if I change values (either, or both, and on my actual workbooks it does not matter how many I change) the value in a3 will not update until I save. Once I save it reflects the changes.
In the effected workbooks I can create new formula cells and it has the same problem. This problem started about 1 week ago, and even some workbooks that I haven't used during that time are now effected as well.
Thank you for any help you can give!