Workbook and Shett Protection

[Shaun]

Wondering why this won't work it locks up the xheet so BA won't connect, i have unprotected the sheet that BA connects to and only my Trigger, stake and Odds cells are protected because they reference another sheet, any help on this problem would be great.

[GaryRussell]

You must still have some cells protected that BA needs to write to. Assuming that the origin cell is A1 the following works.

1) Unprotect columns A to P
2) Unprotect columns T to X
3) Unprotect cells Q4, R4 and S4. These are the column headers for the columns you have protected. This is maybe what you missed.