chris100 skrev:


=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!!


Hi Chris,

Too obvious perhaps, but is calculation set to manual?

/impslayer, aka Birger Johansson

Hi Impslayer,

Chalk this one down to the thickie group of questions but how to I
check that?

Thanks,

Chris


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

chris100 skrev:

Hi Impslayer,

Chalk this one down to the thickie group of questions but how to I
check that?

Thanks,

Chris



Tools -- Options and then the Calculation tab, or something like that
:)

/impslayer, aka Birger Johansson

Ok -- The lightbulb has lit up.

For anyone else facing this issue:-

Tools
Options
Calculation
Automatic

Ciao,

Chri

--
chris10
-----------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...fo&userid=2516
View this thread: http://www.excelforum.com/showthread.php?threadid=48753