Excel link not working

[Bart]

Hi I am unable to link any markets into a previously working excel sheet. The Excel sheet just does not update. I have tried rolling back to BA version 46 but it hasn't made any difference. This is the Excel activity log if it means anything to anyone, any help much appreciated.

16:14:05:990: Requesting Excel refresh. Origin cell:A1
16:14:05:991: Excel update skipped. First update after market changed.
16:14:06:494: Requesting Excel refresh. Origin cell:A1
16:14:06:501: Severe error:System.Exception: Cannot create ActiveX component.
at Microsoft.VisualBasic.Interaction.GetObject(String PathName, String Class)
at Betting_Assistant.Excel.getWorksheets() in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:line 1700
at Betting_Assistant.Excel.ExcelUpdateThread(Boolean triggersOnly) in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:line 3393
16:14:06:501: Excel updated.

[MarkRussell]

Hi,

Where have you saved the previously working Excel document? i.e. is it saved to your local drive and not on a cloud location?
Does the Excel sheet have any macros / vba?

Regards,
Mark

[Bart]

Hi Mark,

Yes I think the problem is related to Excel always wanting to use OneDrive rather than a BA issue, thanks for the advice,