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!B160,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


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=487531