Applying Sort Order To Horses In Excel Linked Worksheet

[dogform]

Hi,

Is there a means of applying sort orders to the runners in a horse race to an excel linked workbook?

I have applied a "saddlecloth" sort order in Gruss which works OK, however, this is not cascaded through to an excel workbook if it is linked to Gruss.

I may have missed a setting somewhere for this?



Rgds
dog

[Captain Sensible]

I think the sort order for the horses has always used the original sort order applied by Betfair from the time the market was accessed. The reason being that it would mess up peoples formulas if that order changed and bets had been placed (favs flip flopping etc). And realistically if you're automating things the order of how they appear on screen is pretty much irrelevant as there's plenty of excel functions to order for betting.

[austingrd]

Sorry but I'm lost here. Does it simply mean that excel linked workbooks don't work?

[alrodopial]

They work but the order is not sorted
If you want to sort them you must do it by yourself IN excel with formulas etc