formulae corruption in excel

[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?

 

[Stefi]

Is your calculation mode set to Automatic? (Tools>Options>Calculations tab)
Regards,
Stefi


„Chike Bass†ezt írta:

 

[Chike Bass]

I think that this may have cured my issue - thank you Steffi ))

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„Chike Bass†ezt írta:

 

[Spiky]

Numerous cells

have a small green triangle in the top left of the cell.

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.