Excel Template Read Only

[RonObvious]

Hi,

When I try to connect to the Excel template through Guardian nothing happens. The template remains un-populated and at the top says Read Only.

Am I missing something?

[Dallas]

Which template BetAngel_1 or BetAngel_Multiple?

Are your markets refreshing in guardian?

[RonObvious]

Yes markets are refreshing in Guardian and its BetAngel_1

[Dallas]

Have you also selected the sheet in the excel column?

[nigelk]

when you open the template, select "save as", give it a name and use that sheet from then on.

[RonObvious]

Ok I've done as Nigel said and saved it as a copy so now its not Read Only anymore it just has Compatibility Mode in brackets but I'm still having trouble populating it.

In the Excel tab I've chosen the workbook and I've clicked connect, status is showing as connected but the workbook is still blank.

[nigelk]

What version of excel have you got?

This might help

https://support.microsoft.com/en-gb/hel ... excel-2007

[RonObvious]

I'm using Office 2016

[Max W]

This is a spreadsheet I got fed up of, I was trying to create a Volume weighted ADX, copying from one for the stock market to see if it works with racing. Maybe you can get use from it.
Regards, Max.

[RonObvious]

I've got it now thanks guys