formulae corruption in excel

  • Thread starter Thread starter Chike Bass
  • Start date Start date
C

Chike Bass

I operate a financial spreadsheet using Excel 2003. The problem I am having
is that my formulae is not being updated throughout the rest of the table. I
have rebuilt the table and all formulae and it works perfectly, then I close
down and the next time I use it, my formulae do not update throughout the
table. I also note that another table which links into the original table
becomes heavily corrupted, with formulae appearing in what should be empty
cells and other cells being pushed over to a different column. Numerous cells
have a small green triangle in the top left of the cell. An simple example of
the problem is I enter a value in cell B6. B9 is =Sum(B6:B8) but B9 stays the
same as when opened and doesn't update with the new value for B6. I'm at my
wits end - anyone help?
 
Is your calculation mode set to Automatic? (Tools>Options>Calculations tab)
Regards,
Stefi


„Chike Bass†ezt írta:
 
Numerous cells
have a small green triangle in the top left of the cell.
Click to expand...
This may be a separate problem. The green triangle indicates a
potential formatting error. If you select one of these, you should
have a little menu suddenly appear right next to it. Go into that and
it will tell you what Excel thinks is wrong, usually a number that is
formatted as text or other similar issue. Some of these are just
cosmetic, others can affect calculation.

You can pick which errors Excel will highlight with the green triangle
in Options on the Error Checking tab.
 
Back
Top