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?