Whenever the Market linked to an Excel worksheet changes there should be an option to reset the worksheet clearing all residue data from the previous Market.
REASONING:
Yes, I know it's (supposed to be) possible to clear the cells using VBA but I can never get it to work and after 3 postings in the Excel forum I'm no closer to the solution!
![Sad :(](./images/smilies/icon_e_sad.gif)
viewtopic.php?f=19&t=21026
viewtopic.php?f=19&t=20947
viewtopic.php?f=19&t=19957)
All I want to do is clear the spreadsheet of the previous race/runner data when the market changes. Forum members have been very helpful in trying to help but as yet without success.
![Sad :(](./images/smilies/icon_e_sad.gif)
I can understand that you want to protect people from shooting 100's of unintentional bets into the market by accident but I cannot understand why you should think that someone would want to carry over the Bet Status (and other runner specific cells) from an old redundant market to a new active market. And if anyone wants to do so then why not have a checkbox that gives the option … "Do you want to clear the workheet when the market changes … Yes/No". This would only apply at change of Market so the risk is only for 1 bet for each selection because the "PLACED" protection would still apply.
Many (me included) come to BA as competent Excel users but have never needed to resort to VBA until exploring BA. As an immediate fix why not post a subroutine to achieve this that people can download and install into their worksheets if required.