Excel add-in run-time error '-2147024891 (80070005)' Access is denied.

After latest update to office 365, the excel add-in is now giving this error message.

I just spent an hour with chat support checking trust center settings but that couldn't figure it out.   

The excel add-in is from the St Louis Federal Reserve https://fred.stlouisfed.org/fred-addin/

|
Answer
Answer
The same error happens here, this has nothing to do with Office, the error is inside the Add-In.

Technical details: The error occurs on the Send method in "moduleAddinVersion"

xmlhttp.Open "GET", "https://research.stlouisfed.org/fred-addin/vers...;, False
xmlhttp.send

The Add-In calls the webside that you can see above to check if there is a new version, and the server of the bank did no allow that. Hence the error.

If I skip that and continue, the rest of the code runs without problems here. See screenshot below.

I suggest that you contact the bank and tell them what I wrote above, they have to change the Add-In and/or there website.

Andreas.

3 people found this reply helpful

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated September 19, 2021 Views 3,001 Applies to: