OK I'll give that a try, thanks Callum. I can't actually say if there is a correlation between when I change something and Connected/Not Connected because I often forget to change things before Connecting so it could be both or either! But if I do want to change something then I should disconnect, make the change, re-save the spreadsheet and then re-Connect … yes?
I also sometimes get a VBA error …
DataCaptureVBError01.JPG
DataCaptureVBError02.JPG
After these errors the only way to close the spreadsheet is to use Task Manager. To get these screen pics I set everything up as suggested before Connecting the spreadsheet. I Connected the spreadsheet in Guardian and then selected the Data sheet for the event. All was OK until I clicked the tab in the spreadsheet to switch the sheet view from Data to BetAngel (or it could have been the other way around). Anyway, I then get the error message and on selecting Debug I always get the same line indicated. (If I select End in the error message the message box just keeps repeating.)
You do not have the required permissions to view the files attached to this post.