Hi all,

Thought i would post this here since i've been doing a lot of work with macros and this could somehow bizarrely be related.

What happens is that formulas do not work, except when you click in the formula bar and press enter, in a way refreshing the formula.

e.g.

=IF(SUPPLIERS!B16>0,SUPPLIERS!B16,"")

If you change cell B16 in the Suppliers worksheet it won't change in the cell where the formula is!!

Beats the hell out of me. Please someone help because i'll have to roll back the version i'm working with and i hate having to do that.

Thanks in advance

Chris