formula change
 

I have already set up formulae in a main worksheet that are linked to other
worksheets in the same file. I notice that everytime data is posted on these
other worksheets the formulae in the main worksheet do not work..shows up as
#REF.The calculation option shows as automatic.