Multiple Instances of Excel

[rnoble]

Two things:

1) Occasionally, when I have more than one instance of Excel running and want to link BA to one of them, Sometimes BA does not recognise all the sheets - Especially annoying when that one is the one you want.

2) Are there two ways of linking BA to two different spreadsheets? Firstly through linking individual tabs in one session of BA to individual spreadsheets, and Secondly, opening multiple instances of BA and linking each to its own spreadsheet? If the main issue is to have different sets of markets loaded for different spreadsheets, then which linking method is preferable?

[GaryRussell]

It's how you open the spreadsheets. If you want to open multiple instances of Excel open each additional instance from the first instance's file menu, not by using the program shortcut.

[rnoble]

Thanks Gary, I will do that in future.

Meanwhile, do you have a comment on question (2)?

Richard

[GaryRussell]

Sorry, I should have read the questions properly

Yes you can use both ways, but it is preferable in my view to use one instance of BA with separate tab pages. There is no performance difference and the one instance can handle the data request throttling across multiple markets to avoid incurring data charges.

[GaryRussell]

I should also point out then when you add the new tab page you will need to select "Add to quick pick list" from the market menu. You could use two instances of BA with separate profiles to store different preferences for markets to load on startup, but I still think from a request throttling perspective you are better having one instance of BA. You just have the minor inconvenience of adding markets after adding the new tab page.

Some users have many tabs with different markets and it is a headache to set them all up each day. I will be addressing this in a future release.

[rnoble]

Thanks for all that.

I now have 1 instance of BA running with 2 tabs, and linked to 1 session of Excel with 2 windows open.

However, it appears as if BA only refreshes (in BA and Excel) the tab/spreadsheet that I have selected in Excel. In addition, my Excel VBA code (which is triggered on a Recalc) only appears to run on the currently selected spreadsheet.

Clearly I want both BA tabs and both Excel spreadsheets to refresh according to BAs refresh rate. Any suggestions?

[GaryRussell]

It sounds like you have missed something. Did you set up the link in each tab page separately? ie. on each tab page in Betting Assistant did you select "Log current prices", select the appropriate workbook and worksheet from the drop down list and click OK?