CLEAR Triggers on excel log prices not working????

[Snowman54]

Hi Guys,
I have been using excel on version 62 with no problems for some time but on tuesday I downloaded new version 65 (now have version66c) and since download the CLEAR triggers don't work ? any ideas why.

I have ticked all 3 boxes in the log prices box refering to the CLEAR triggers, have correctly connected the lay worksheet and results worksheet and enabled the trigger. The auto select is set to 2 minutes and the bot scrolls through the races correctly but as each new race is loaded the bet refs to profit/loss columns (which are cols T to X) fail to clear and retain the info from the previous race thus stopping any future bets on that line. I have updated my excel version from 2003 to 2007, create the programme again from scratch on a blank worksheet but still have the same problem. I use colums Y to AO to show my own formula and hide the colums that I don't need to see.

Any ideas would be much appricated as the only way I can use the programme with the bot is to manually delete columns T to X after each race which defeats the idea of automation

[GaryRussell]

I cannot replicate this problem. Could you send the spreadsheet to admin@gruss-software.co.uk so I can test it?

In the meantime could you try the following test which will only take a few minutes.

1) Use a complete new spreadsheet and don't change anything, eg. hiding columns, changing formatting etc.
2) Link to the spreadsheet and make sure "Clear bet refs on manual select market" is ticked.
3) Enter "test" in any of the bet ref cells
4) Select another market
After step 4 does it remove "test" from the bet ref cells? If it does then repeat this test with the problem spreadsheet. If it doesn't clear then it's something about the spreadsheet causing the problem and I should be able to fix it if you send me a copy. If it does clear then I will need to create a test version for you to log what is happening when it tries to clear the cells.

[Snowman54]

Hi Gary,


I did rcreate new worksheet before sending query but left cols that had been hidden on old sheet in same position on new. I will run test as suggestted in next hour and if still same will forward 2 copies to your email 1 with all cols showing and the original with hidden cols as they where.

Thanks for your prompt response.

snowman

[Snowman54]

Hi Gary,

No luck so have sent the 2 workbooks by email 2 minutes ago from my hotmail address as aol down this morning.

Thanks for your help


snowman