Cancelling bets in Excel

[Tony5578]

I have just started using excel so apologies if the answer to my question is obvious. I run more than one excel sheet on a given market. Once I have greened up I want to be able to cancel all further bets even if the trigger condition is met. I can sever the link with the worksheet but as there are several sheets I was wondering if there was a quicker way to do it.

Thanks in advance.

Tony

[GaryRussell]

Are all sheets in the same workbook? You could use a cell as an indicator that you don't want the trigger to fire. eg. put "N" in cell T1 of sheet1 then refer to this cell in your formula eg. =IF(Sheet1!T1<>"N","BACK","")

[Tony5578]

Thanks for replying so quickly. My excel skills are a bit basic so I've set up different workbooks. It's working for me for now but I obviously need to learn a bit more about excel formulas.