If you see the “The file couldn’t open in protected view” error while opening Microsoft Excel, the solutions listed in this post may help you resolve the issue ...
How-To Geek on MSN
How to set Power Query to refresh automatically in Excel
Stop relying on manual clicks and clunky code—let Excel refresh your queries automatically.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results