When switching markets, calculated formulas are deleted

[amberleith]

So I have been banging my head against the wall for hours on this one.

I can place all the bets I want automatically when I do not have to switch markets using the mutliple template, it just so happens that I want to use the exact same spreadsheet on hundreds of markets, so have had to create a file with about 300 sheets tabbed along the bottom. Considering I'm only using the spreadsheets for a couple of minutes each it seems ridiculous and I noticed it causing a drain on resources.

The problem is that if I attempt to use just a handful of spreadsheets rotating between markets, guuardian handles the switching just fine. It connects a market to a sheet a couple of minutes before the off and then clears it a couple of minutes later, moving along the different sheets as it goes. However once it attempts to switch a market on a sheet thats already been used, the previous values are saved as text rather than a formula.

For example, under the Odds cell (M9) I have it set to =K9, the last traded price. This works fine when the market runs fresh but once the market is over and a new one is loaded in, the cell M9 now will just show the last price before the switch and not =K9.

If the last price on the old market was 4.0, then M9 will now show 4.0 instead of whatever is now in K9. It does this for every cell on the spreadsheet that has been used previously, if there were 4 runners in a market in the first race and the next has 6, the top 4 runners odds, stakes and every other calulation leading to them will be fixed in place from the previous market.

Solutions I have tried- disabling all autosaving and auto recovery, formatted all cells to 'General', formatted all cells to 'Numbers', cell protection, deleting all VBA code, several hours of trial and error on a list of things I can not even remember.

This behaviour is repeated on the default betangel sheets too, so I think theres a problem with my excell unless theres a setting I've missed on betangel, although why there would be a setting to store all formula results until eternity I've no idea.

I just want to be able to switch markets on the same sheet, without needing 500 sheets tabbed open at once.

Can anyone help?

[amberleith]

I dont know if this matters but I'm using Excel 2013 on Windows 10.

[PeterLe]

Are you placing bets simultaneous on many markets or is it just one market at a time?
If it's the former then I've heard of other people (Ie letiss) who have had issues running in many markets in parallel ( if you can you can use guardian to place the bets), you'll find this works much better
If you are using the same spreadsheet on many markets but in series I've one market at a time, you are better having a single spreadsheet but connect via the excel tab rather than connect through guardian
Regards
Peter

[amberleith]

One market at a time.

I have tried using the excel tab with the same outcome, when markets switch the sheets formulas are wiped away.

This evenign I'm goign to do a complete reinstal of bet angel, I'm goign to try and reset back to the most default set up possible to see if its one of the millions of options I've played wit htats causing the issue.

[PeterLe]

......deleting all VBA code....

Have you added your own VBA code to the standard sheet?

[amberleith]

Yes I did.

Removing the code has actually fixed my problem as it goes, I didnt actually need it in the end and that was the issue behind the excessive RAM use by excel. I can have hundreds of sheets open at once at the computer doesnt even notice.