Q
Q
Ihave a workbook with about 20 tabs. I use it to track bank accounts,
stocks, etc. I have used it for about 18months. Recently it has quit
calculating the formula's in each tab. For example I have one tab that is
like a check register and it add/subtracts entries in a balance column. When
I enter a check, the balance cell does not change. I have found that if I
open the cell that is not calculating and overtype a letter or number and
then hit enter, it then calculates. I have checked to make sure the cells
are not text, they are eithyer number or currency.
stocks, etc. I have used it for about 18months. Recently it has quit
calculating the formula's in each tab. For example I have one tab that is
like a check register and it add/subtracts entries in a balance column. When
I enter a check, the balance cell does not change. I have found that if I
open the cell that is not calculating and overtype a letter or number and
then hit enter, it then calculates. I have checked to make sure the cells
are not text, they are eithyer number or currency.