[Power Query] Active Content - IE settings make no difference

I have a constant problem with Power Query in Excel 365 ProPlus.

When I open up Power Query Editor I get the following yellow prompt below the ribbon:

"To help protect your security, your web browser has restricted this file from showing active content that could access your computer. Click here for options..."


prompt.png

When I select 'Allow' from the drop down Power Query breaks and the menus skew over the page.


Then another prompt appears with the same yellow prompt: "Unexpected Error: Something went wrong. If the problem continues, please restart Excel"

errorafteraccept.png

Restarting Excel makes no difference.

I have changed the settings in IE 11:

settingchanged.png

This has made no difference.


I have repaired and reinstalled Excel which has also made no difference.

PQ still operates if I select nothing from the yellow prompt but it is extremely slow and freezes up.


Any suggestions to fix this would be most appreciated as Power BI is not workable with this constant error.

Thanks for the reply.

I changed the option in Trust Settings to 'Never show information about block content' but unfortunately it still shows the the yellow banner prompt and the error in PQ.

Hi, sorry to bump the thread but this issue with 'Active Content' is still persisting and I'm unable to use Power Query.

I changed several Trust Settings but no joy.

I would much appreciate any suggestions to fix.

I have Google Chrome installed and use it as my default browser. However, there are no settings for Active Content in Chrome though, as far as I can see?

I've also tried switching the default browser back to IE but that made difference.