View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
impslayer impslayer is offline
external usenet poster
 
Posts: 22
Default 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