PDA

View Full Version : Odds Type Not Populating



spanarkel8
4th September 2019, 12:11 PM
I've downloaded each version of the US Dollar excel and none of them are allowing me to select any Odds Type to change it to American Odds. The entire area is just blank. Does anyone know a work around? I'm using a surface with the latest version Excel

admin
4th September 2019, 12:27 PM
Hi spnarkel8,

It may be that you have opened the file in protected mode. What is supposed to appear is a dropdown selection. The dropdown menu changes the value of cell AB3 in the Settings worksheet (for the latest basic version). Try the following:

1. Unlock the Settings worksheet using the password sport
2. Highlight columns Z-AK and unhide the cells in-between.
3. Change the value of the cell in AB3 to 2

spanarkel8
5th September 2019, 08:14 AM
it worked! Thank you!


Hi spnarkel8,

It may be that you have opened the file in protected mode. What is supposed to appear is a dropdown selection. The dropdown menu changes the value of cell AB3 in the Settings worksheet (for the latest basic version). Try the following:

1. Unlock the Settings worksheet using the password sport
2. Highlight columns Z-AK and unhide the cells in-between.
3. Change the value of the cell in AB3 to 2