I would be grateful if anyone can help me please.
I will try to simplify.
Downloaded an example BA excel sheet (XLS extension) while ago.
Worked fine and exactly what i wanted including amended copies(XLS extension) also.
Now trying to copy and amend. The file extensions have excel xlsx when copied and wont autobind to betangel. Tried copying and saving xlsx as excel 2007-2010 with xls which works but wont autobind.
Excel Help
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
When you open an excel worksheet in BA it defaults to just showing .xls file types. Change it to *.* or similar and choose the Xlsx or xlsm file you want.
Thanks Shaun.
Soz bit late in replying as spent many hours changing,copying,deleting,tweeking spreadsheets today.
However I did find something useful as day progressed when trying in live mode and spreadsheets misfired.
This may help others.(non cost effective way)
Later I opened spreadsheets when racing finished.
I typed in theoretical odds in say G9 G11, H9 H11 etc copy paste etc
Found out on spreadsheet where "l" command column wasnt firing.
Cleared the theoretical prices IE G AND H columns
Saved spreadsheet. All set for tomorrow.
Soz bit late in replying as spent many hours changing,copying,deleting,tweeking spreadsheets today.
However I did find something useful as day progressed when trying in live mode and spreadsheets misfired.
This may help others.(non cost effective way)
Later I opened spreadsheets when racing finished.
I typed in theoretical odds in say G9 G11, H9 H11 etc copy paste etc
Found out on spreadsheet where "l" command column wasnt firing.
Cleared the theoretical prices IE G AND H columns
Saved spreadsheet. All set for tomorrow.