Excel with Dynamics 365 connection - Cannot refresh

Thanks Anonymous. Yes I can login to Dynamics 365 through Edge without issues and this is running in the background. The few users that have attempted this do report the same issue. I can directly link to the API via ODataFeed however this is not a practical solution because it means that I have manually rebuild an advance find query from scatch. And there is just too much data. I've been on a sabatical for over a year so no doubt there may have been changes in the hosting environment.

Unfortunately browsers and other environment settings are managed Corporately, so these settings are greyed out for me. I have cleared cache and cookies etc however this does not resolve the issue. I have logged a ticket with Corporate IT and will let you know how this goes. I also suspect that the Pop-ups and redirects settings in the browser may also need to be updated.