Refreshing data in excel from a Dynamic worksheet will not work for me Disappointed

I have tried exporting as a dynamic worksheet in Chrome, Edge and IE.   In Chrome and IE all the data in the spreadsheet disappears when I click Refresh All and in Edge nothing happens when refreshing.

I am using Excel 365 Version 2104 

Dynamics 365 On Premise version 9

Does anyone have any ideas that can help get this working? It would be such an amazing feature if I could get it to refresh from CRM.