Strange problem with formulas...
 

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

Strange problem with formulas...
 

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

Strange problem with formulas...
 

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

Strange problem with formulas...
 

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

Strange problem with formulas...
 

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