cell-formula does not calcualte

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Additonal note: I just figured out that when I do a manual "save" it also
causes the forula to recalcualte....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell reading Balanced problem 2
Cell to the left of an Index function result 2
Formula To Keep Certain Cells Blank 5
NONFUNCTIONING FORMULA 1
Need formula to change cells from negative numbers to a zero. 2
First row where a cell is zero 1
Update formula automatically for inventory 1
cell does not recalc 3

Back
Top