After authorising Datadear with HMRC (I can see Datadear is registered and authorised on the HMRC site), I returned to Excel and a pop up advised to click ok to complete authorisation. After doing so it sits calculating for sometime (data miners message in the bottom left), and then eventually brings up an error “Microsoft Excel is waiting for another application to complete an OLE action”, if I click ok it returns the error again on loop. Eventually I give up and click cancel. At this point the VRN number is listed correctly at the top but the VAT return period is blank.
I tried restarting Excel and after entering login details there is a long period of calculation and I get the error “Oops, there has been an unexpected error returned from HMRC. Detailed message from HMRC: - The client and/or agent is not authorised.” as stated above HMRC has Datadear listed as authorised on our account. The VRN number is correct.