Different Worksheet or Different Workbook

[crocogotter]

Quick question, when using Excel to trigger bets in different markets, is it better to use difference sheets in the same workbook, or completely separate workbooks, or does it make absolutely no difference?

[Captain Sensible]

I've been thinking about this too and come to the conclusion it's probably better to have separate instances of Excel running. I'm not sure if any additional refreshes would also cause the formulas within the other markets worksheets to recalculate at each refresh.

Obviously with no change in data nothing extra would fire off but just from a CPU point of view it'd use unnecessary resources and slow things down. But I've no real idea of what happens when BA an Excel connect so it'd be nice if someone more clued up could confirm it.