Refresh rate not always available from Excel logging sheets?

[Joe68]

Have been playing with the refresh rate on an Excel sheet connected for logging. Enter a value in cell Q2 and it gets passed to the relevant page in BA.

However, it doesn't seem to work all the time.

For example, the label "Refresh Rate" only seems to appear in Cell P2 approximately 5 minutes before the jump.

Similarly, values entered in cell Q2 are not passed back to BA until approximately 5 minutes before the jumP.

Is that expected behaviour? Is there a setting somewhere to vary the time before jump at which this is activated?

I want to use Excel to code increasingly frequent refreshes as the jump time approaches.

[Joe68]

I started with an Excel logging sheet which had already had a market associated which had active refresh rate passing back from Excel.

I re-associated a race 3.5 hours in the future with that same, used sheet.

Refresh rate working hunky dory.

I created a new worksheet. Created a new BA page with the exact same race, set up Excel logging that page to the new worksheet - no refresh rate communication back to BA from this page.

With the old, established, refresh-rate-enable worksheet, I seem to be able to log any market to it and I still get refresh rates passed back to BA. However, the new worksheet doesn't have a label for "Refresh Rate" @ cell P2 and I've associated it with a number of races with varying times to off.

Anybody else get this behaviour?

[Yorkie]

Hi

Never seen the refresh rate label missing and as far as i know it's a default part of the excel link.

Are you sure you don't have some vba that is constantly clearing that cell ?

If you new non working sheet has some code attached to it try a new blank workbook linked to ba, what does that do?

Keith

[Joe68]

Thanks for your suggestions Yorkie.

There's no code clearing the cell. All the logic so far is in-cell.

New blank workbooks sometimes have the refresh rate and sometimes don't. They seem more likely to have it closer to jump time.

Has anybody seen this?

[Joe68]

Refresh rate label only exists and refresh rate data is only passed back to BA when trigger betting enabled.

I suppose that makes some sense in that trigger betting is the major data that would need to be passed back to BA.

Still, wouldn't it be nice not to have to risk betting exposure simply to be able to change the refresh rate from Excel?