Power Query Security Settings

[camachodj]

Hi All,

I am having a difficult time finding guidance on the right settings for Excel 2016 so that I can use Power Query. Most of the files I use are from my own desktop but I continue to receive this error message (Yellow Banner once I initiate the Power Query add in). "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... When I click and select allow content the tool just crashes and doesn't allow me to continue. No one internal can help me and I really rely onthe Power Query tool for my work. Hoping some experts out there have run into this and can help me please?

Thanks very much,
Deb

 

[sandy666]

Try to repair your Office installation or even re-install...