Jan 05 2023 06:37 AM
I am having a problems with calculations in my spread sheet. The problem is actually in 2 parts:
1. As I enter data into cells it seems to lag in updating the formula cell. I have to press the right arrow to get back to the very beginning of the row and then go back to the formula cell for it to update.
2. I can also enter data into a cell and then the cell with the formula does this funny thing where it a) doesn't calculate properly and b) makes the number a mix of red and black writing. I have to re-enter the data and the formula cell recalculates and is then either black or red (if it's a negative).
Automatic Calculation is On and I have checked to make sure i am using the latest version.
It is making entering data (and a lot of it) very slow and tedious!!
Jan 05 2023 07:50 AM
Without knowing what's in the workbook formula-wise, I'll put this out there as a guess.
If this is enabled, try unchecking it. If it's un-checked, try checking it.